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.
List of Asked Interview Questions: C# .NET SQL MVC WCF Questions
