LINQ over traditional stored procedures

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.

Mulakdeep Singh, Jun 15, 2011

Reply 1

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.

Aaron Burton, Jun 16, 2011

Thanks! Other than changing the TimeOut setting, I also change the maxItemsInObjectGraph="2147483647" and it works now.

Feb 17, 2011