Using LinqToSql is much better than other approches because :
-It is easy to query multiple data sources.
-I think LINQ will populate the collection faster.
-You don't need to worry about the opening and closing of a Connection.
-It is easier to understand.
-Linq improves the readability and correctness of your code.
-And implementing Linq is very time saving.
For more information on Linq to Sql click the below link:
LINQ to SQL was a ORM introduced in .NET Framework 3.5 and provides a runtime infrastructure for managing relational data as objects without losing the ability to query. LINQ to SQL queries are written within .NET managed code whereas stored procedures reside
in the database so that's one of the fundamental differences.
However in the years to follow Microsoft decided LINQ to SQL wouldnotbe Microsoft's flagship OMR and shifted all focus to the Entity Framework. In fact LINQ to SQL is not really being enhanced anymore as all efforts are on EF as Microsoft's primary ORM.
It stillworksand is supported, but it would not be my technology of choice; I would use EF instead.
Please don't confuse this with LINQ in general; it is ever present as a technology and going strong in .NET. This is specific to Linq to SQL.
For more information have a look at the following link:
Why to go for LINQ to SQL rather than normal SQL ?
LINQ or SQL which is good ?
It's hard for us to decide which is better or good depending on their different kinds of aspects：generally speaking，LINQ is more coding in the form of OOP programming than pure data connection or things to do than SQL；so it's easy for us to apply that in
some tier-layed proj like MVC or N-Tier app。
Compared with this，SQL is always used with ADO.NET，and it's more flexible——Remeber it that Not every SQL statement can be converted to LINQ successfully。So sometimes you have to use SQL。
khanahmed
Member
328 Points
135 Posts
LINQ or SQL which is good ?
Mar 27, 2012 10:10 AM|LINK
Why to go for LINQ to SQL rather than normal SQL ?
LINQ or SQL which is good ?
Shankar_ss
Participant
1270 Points
279 Posts
Re: LINQ or SQL which is good ?
Mar 27, 2012 10:26 AM|LINK
This link gives you some good info
http://www.danielgpratt.com/2008/12/why-linq-is-better-than-sql-part-3.html
Shankar
thaicarrot
Contributor
5132 Points
1465 Posts
Re: LINQ or SQL which is good ?
Mar 27, 2012 12:37 PM|LINK
1. when use SQL, there's lots of work to do that is Linq is qickly.
2. Linq plus EF , L2q or other tool you App is scalable on the cloud because base on N-Tier design(Declupping component).
Weera
sravanisrav
Member
470 Points
107 Posts
Re: LINQ or SQL which is good ?
Mar 28, 2012 10:44 AM|LINK
Using LinqToSql is much better than other approches because :
-It is easy to query multiple data sources.
-I think LINQ will populate the collection faster.
-You don't need to worry about the opening and closing of a Connection.
-It is easier to understand.
-Linq improves the readability and correctness of your code.
-And implementing Linq is very time saving.
For more information on Linq to Sql click the below link:
http://www.bestdotnettraining.com/Online/Training/LINQ/LINQ-to-SQL/109
Thanks & Regards
Sravani
atconway
All-Star
16846 Points
2756 Posts
Re: LINQ or SQL which is good ?
Mar 28, 2012 01:29 PM|LINK
LINQ to SQL was a ORM introduced in .NET Framework 3.5 and provides a runtime infrastructure for managing relational data as objects without losing the ability to query. LINQ to SQL queries are written within .NET managed code whereas stored procedures reside in the database so that's one of the fundamental differences.
However in the years to follow Microsoft decided LINQ to SQL wouldnotbe Microsoft's flagship OMR and shifted all focus to the Entity Framework. In fact LINQ to SQL is not really being enhanced anymore as all efforts are on EF as Microsoft's primary ORM. It stillworksand is supported, but it would not be my technology of choice; I would use EF instead.
Please don't confuse this with LINQ in general; it is ever present as a technology and going strong in .NET. This is specific to Linq to SQL.
For more information have a look at the following link:
Update on LINQ to SQL and LINQ to Entities Roadmap:
http://blogs.msdn.com/b/adonet/archive/2008/10/29/update-on-linq-to-sql-and-linq-to-entities-roadmap.aspx
Decker Dong ...
All-Star
118619 Points
18779 Posts
Re: LINQ or SQL which is good ?
Mar 29, 2012 01:41 AM|LINK
It's hard for us to decide which is better or good depending on their different kinds of aspects：generally speaking，LINQ is more coding in the form of OOP programming than pure data connection or things to do than SQL；so it's easy for us to apply that in some tier-layed proj like MVC or N-Tier app。
Compared with this，SQL is always used with ADO.NET，and it's more flexible——Remeber it that Not every SQL statement can be converted to LINQ successfully。So sometimes you have to use SQL。
Reguards！
jsiahaan
Contributor
2322 Points
596 Posts
Re: LINQ or SQL which is good ?
Mar 29, 2012 03:30 AM|LINK
Have fun
Indonesian Humanitarian Foundation
jsiahaan
Contributor
2322 Points
596 Posts
Re: LINQ or SQL which is good ?
Mar 29, 2012 04:26 AM|LINK
Additional info for LINQ and SQL:
Have fun
Indonesian Humanitarian Foundation
jsiahaan
Contributor
2322 Points
596 Posts
Re: LINQ or SQL which is good ?
Mar 31, 2012 11:24 AM|LINK
Hi
khanahmed
Do you find any good replies? All them are good replies.
Indonesian Humanitarian Foundation