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?
1 回答
泛舟湖上清波郎朗
TA貢獻1818條經驗 獲得超3個贊
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).
- 1 回答
- 0 關注
- 355 瀏覽
添加回答
舉報
0/150
提交
取消