Linq-to-SQL - Application architecture

Question

I'm trying to design application that will have UI with database in the backend.

I will be using Linq-to-SQL as the database layer to update and insert.

Now I'm trying to find out the best practice to use in designing the project, suppose I have 2 tables in the DB (Customers, Orders)

Shall I depend on the generated Linq-to-SQL classes, or shall I still create classes for Customers, Orders?
Shall I wrap the generated Linq-to-SQL inside another class to add validations?

I hope my questions are clear.

Anders Abel · Accepted Answer · 2011-04-18 13:54:15Z

1

L2S is in my opinion an excellent light-weight data access method. If you have control over the database and have limited application data processing logic it is often a good choice.

If you have a two-tier app with a UI communicating directly with the DB then you can depend on the L2S generated classes. If you have a multi tier app with a client communicating with e.g. a WCF service you probably need Data Transfer Objects.
Use the partial methods on the L2S classes for validation.

answered Apr 18, 2011 at 13:54

Anders Abel

69.6k18 gold badges154 silver badges221 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Sergey K · Accepted Answer · 2011-04-18 13:44:30Z

1

I think you should use other ORMs for better implementation DAL for example Entity Framework or Nhibernate this ORMs allow you Model First approach without attributes and the validation logic you should separate in other classes for exmaple MyEntityValidator And also good approach to use the Repository pattern this pattern allow doesn't depend on Data access EF or Nhibernate

and look at this Entity Framework and Repository

answered Apr 18, 2011 at 13:44

Sergey K

4,1162 gold badges25 silver badges36 bronze badges

Collectives™ on Stack Overflow

Linq-to-SQL - Application architecture

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related