Wednesday, October 12, 2011

LINQ interview questions: -What is the difference between LINQ to SQL and Entity framework?

Following is the LINQ interview questions asked in an interview: -

• LINQ to SQL is good for rapid development with SQL Server. EF is for enterprise scenarios and works with SQL server as well as other databases.

• LINQ maps directly to tables. One LINQ entity class maps to one table. EF has a conceptual model and that conceptual model map to storage model via mappings. So one EF class can map to multiple tables or one table can map to multiple classes.

• LINQ is more targeted towards rapid development while EF is for enterprise level where the need is to develop loosely coupled framework.

View the following video on calling a stored procedure using LINQ: -

See more LINQ interview questions


Visit author’s more LINQ interview questions

No comments: