How to decide whether to use LINQ to SQL or ADO.NET

Question

I am just wondering which of the above technology is to use and when with SQL Server

What are the factors that can use to determine which technology is to use
Will the performance of those technologies acting differently in web based application and standalone application.

Thanks

Related: Choosing a .NET ORM: http://stackoverflow.com/questions/1377236/nhibernate-entity-framework-active-records-or-linq2sql/ — Michael Maddox, Mar 16 '12 at 11:18

score 3 · Answer 1 · edited May 23 '17 at 12:27

3

Well, Linq2Sql is additional layer on top on ADO.NET. Here is comparison of ORM's for 4.0 .net: Best ORM to use with C# 4.0

I would also recommend EF over Linq2Sql, even if EF still does not have some simple things (like enum support).

edited May 23 '17 at 12:27

Community

1
1

answered Mar 15 '12 at 12:08

Giedrius

8,430
6
50
91

Kishore Kumar · Answer 2 · 2012-03-15T12:08:29.300

0

If you want to make an adventure use Linq2Sql but we have learn something about that.

I will suggest you to use EntityFrameWork if you are using .Net Framework 4.0.. In EntityFramework you can use Linq queries more well than Linq2Sql files.

ADO.Net is became old now and we need to learn new things now and then.

edited Mar 15 '12 at 12:08

answered Mar 15 '12 at 12:01

Kishore Kumar

12,675
27
97
154

How to decide whether to use LINQ to SQL or ADO.NET

2 Answers2