LINQ to SQL

Question

1.What is the key difference between ADO.NET Entities and LINQ to SQL?2.What is the performance hit of LINQ to SQL compared to writing data methods with commands and parameters?

Answer 1

1.LINQ to SQL is an ORM over your relational database schema plus some mappings. LINQ to Entities is an ORM over a conceptual object-less model (ERM) that is a mapping over your relational database schema.

2.There is of course a performance cost of both translating queries into SQL and materializing results as objects. The relative cost of this depends on how complicated the query is and how much data is being retrieved. Yet much of this can be mitigated for server apps by using compiled queries (available soon).