LINQ to SQL Interview Questions and Answers


 

Interview Question in LINQ to SQL

Difference between LINQ and Stored Procedures?

 What are the main difference between LINQ and Stored Procedures?

Pros and Cons of LINQ (Language-Integrated Query)

 

  • What are the pros and cons of LINQ (Language-Integrated Query)?
  • What are the best and worst cases in which to use LINQ?
  • How have you benefitted or not benefitted from using LINQ?
  • Which data sources benefit the least and the most from LINQ?

Disadvantages of LINQ over Stored Procedures

Can you tell me about the disadvantages of LINQ over Stored Procedures?

Advantages of LINQ over Stored Procedures

 Can you tell me some advantages of LINQ over Stored Procedures?

Are LINQ to SQL entities Business Entities or Data Transfer Objects?

 Are LINQ to SQL entities Business Entities or Data Transfer Objects?  How do I build a business layer on top of LINQ to SQL?

How do I get default values from the database when inserting new entit

 How do I get default values from the database when inserting new entities?