Best Data Access Techniques for a New Web Application

Question

I am creating a new web application project and am confused by the numerous data access methods. I support SQL and is a bit confused, should I use LINQ to SQL or trtaditional ADO.net?

What are the advantages and disadvantages of using LINQ / SQL through ADO.net?

If this is ADO.net, then what is the best way to get data means either calling stored procedures or calling t-sql code?

My question is what is cleaning and the most efficient and professional way to create DAL for web applications in asp.net?

thank

Answer 1

What are the advantages and disadvantages of using LINQ / SQL ADO.net?

• Linq2sql , 1--1 () - , ado.net .
• Linq2sql , - ( 1--1) - , linq2sql, .
• Linq2sql linq. linq intellisense, , ado.net .
• linq, t-sql, ado.net( , linq !). t-sql, , .Skip(page * size).Take(size).
• Linq2sql t-sql, , SQL-, ado.net, .
• Linq2sql - , , linq2sql sprocs.
• Linq2sql , , ado.net, .

ADO.net, t-sql?

• linq2sql, ado.net , , t-sql . , , linq / .

, DAL web- asp.net?

• , DAL, , linq2sql, ORM SQL Server (, SQL Server , ).
• , ado.net, , , , , , linq2sql, , 90% .
• , DAL linq2sql, , , Entity Framework NHibernate ( ) - .
• DAL ado.net.

Answer 2

- O/RM. Linq2Sql, Entity Framework 4 NHibernate (Fluent NHibernate).

SP , - , . , - TDD.

- DAL , .

Answer 3

ORM, NHibernate: http://nhibernate.info

Answer 4

, , Linq2Sql.

Linqpad , .

Answer 5

, , ADO.NET. : http://ormbattle.net/.