,
In this article we will see how to use LINQ to interact with a SQL Server database, or in other words, how to use LINQ to SQL in C#.
In this article, we will cover the basic concepts and features of LINQ to SQL, which include:
- What is ORM
- What is LINQ to SQL
- What is LINQ to Entities
- Comparing LINQ to SQL with LINQ to Objects and LINQ to Entities
- Modeling the Northwind database in LINQ to SQL
- Querying and updating a database with a table
- Deferred execution
- Lazy loading and eager loading
- Joining two tables
- Querying with a view
Use above (Ref) link to to read article.
