When to use "Linq to sql"?

Question

What are the pro's and con's of using "Linq to SQL" and core ADO.NET technology for access databases?

possible duplicate of [LINQ to SQL vs ADO.Net](http://stackoverflow.com/questions/671179/linq-to-sql-vs-ado-net) — Jørn Schou-Rode, May 28 '10 at 08:18
or [What are the advantages of LINQ to SQL?](http://stackoverflow.com/questions/593808/what-are-the-advantages-of-linq-to-sql) — Jørn Schou-Rode, May 28 '10 at 08:19
and see also [Entity Framework vs LINQ to SQL](http://stackoverflow.com/questions/8676/entity-framework-vs-linq-to-sql) — Jørn Schou-Rode, May 28 '10 at 08:20

score 1 · Accepted Answer · edited May 23 '17 at 11:47

Advantage

No need to create business objects dbml files will do for you
No need to worry about writing queries because linq2sql convert your statment in efficient queries
Important is Lazy Loading of related objects

Disadvantage

Disconnect linq is not supported i.e you cannot deatch you objects form DataContext object. for more detail : Most efficient way to update with LINQ to SQL

score 0 · Answer 2 · answered May 28 '10 at 08:16

I have the same view point as this post, I've yet to find any major disadvantages of Linq.

I have built a number or application and websites using Linq and found it to be extremlly simple to use

http://forums.asp.net/t/1520157.aspx comment by BoogleC

Regards Sp

score 0 · Answer 3 · answered May 28 '10 at 09:18

Id also be carefull about how you write you LINQ statement. Sometimes its better to compile your Linq rather than not as every single run of the Linq query is fully parsed every time it happens. See below linq

http://www.codinghorror.com/blog/2010/03/compiled-or-bust.html

Graham · Answer 4 · 2010-05-28T08:50:01.220

-1

I wouldn't recommend LINQ to SQL at all as it is effectively dead (you don't want to be writing legacy code, right?). Microsoft is no longer developing it and they recommend using the Entity Framework instead (see here), however, if you are interested in using an ORM, I would strongly recommend looking at NHibernate.

edited May 28 '10 at 08:50

answered May 28 '10 at 08:28

Graham

14,885
4
36
42

There are reasons why you may choose one over the other described here http://msdn.microsoft.com/en-us/library/cc161164.aspx – Peter Willis May 31 '10 at 11:19

When to use "Linq to sql"?

4 Answers4