LINQ over traditional stored procedures

 
50   50
Jun 15, 2011
 
Tech experts,

What are advantages of using LINQ over traditional SQL connections and calling stored procedures?
Does affect it in terms of execution time?

I have not used them yet but intend to use them.

Any example to highlight the effectiveness would be appreciated.

Thanks.



254   99.4
Jun 16, 2011
linq to sql was created to protect the programer from the database. That said, linq to sql is not as fast or as transparent as ADO.  Linq to sql is added on top of ADO.
 1 comment
 
Also, it provides ORM, keeps .NET developers away from fussy logic of database, prevents SQL injection and performs database trip only at the time when it is actually needed --- Saurin Travadi  Jul 07, 2011