LINQ to SQL

This is one of the most useful and the easiest method to do database operation with sqlserver.

This is one of the most useful and the easiest method to do database operation with sqlserver

• Its all features located in System.Data.Linq
• It also include basic object relation (O/R) mapper directly in Visual studio.
• The O/R mapper enables you to quickly map sql-based datasource to CLR object.

Just Follow these simple steps:

Step 1: Add a LINQ to SQL Class like this



Step 2: Drag the Database table which one you are going to use.



Step 3: Save the page(Ctrl + s) where serialization mode=”Unidirectional” like this image



Step 4: Then In Design page, take one Gridview and Linqdatasource control and configure the Linqdatasource control like this





Step 5: You will get output like this