Why Linq to SQL?
-
Just getting back into some of the newer stuff from MS. I can't figure out why LINQ to SQL exists. I always thought query's should run in the DB in stored procs and not be in code. Essentually LINQ to SQL is a hard coded SQL Query. I thought this was bad form. What am I missing?
-
Just getting back into some of the newer stuff from MS. I can't figure out why LINQ to SQL exists. I always thought query's should run in the DB in stored procs and not be in code. Essentually LINQ to SQL is a hard coded SQL Query. I thought this was bad form. What am I missing?
Linq to SQL is a ORM, Object Relational Mapper, tool. It is more than just a way to run queries. It removes the need for the developer to hand create entities, execute queries and map the result sets to those entities. It gives the ability to track changes when objects have been modified. Plus a host of other things. You can still use stored procs with Linq to SQL.
I know the language. I've read a book. - _Madmatt