Following is the pictorial representation of LINQ to SQL Architecture.
By using LINQ to SQL we can perform multiple operations like insert, update, delete and get data with minimal coding when compared with ADO. We will see how to create and use LINQ to SQL (dbml file) in web application with example.
While Visual Studio provides a way for developers to be more productive, dealing with a lot of SQL Server database objects with LINQ is totally inefficient.
The dragging-and-dropping process to create the object model will take a lot of time, depending on the amount of objects.
As I was going thru the April 2008 edition of the SQL Server Magazine, I've learned about this utility called Sql Metal.
Sql is a command-line tool that generates code and mapping for the LINQ to SQL component of the . When I started working with LINQ, I was only using Visual Studio 2008 to generate the object-relational diagram by (you guessed it) dragging-and dropping the database objects on my designer surface.
You can find this tool inside the \Program Files\Microsoft SDKs\Windows\v6.0a\bin folder.
It generates the necessary data entity and Data Context object for LINQ as either a or source file.NET) from the Northwind database running on my SQL Server 2000 instance that represents the database object model.This can then be imported as code in your Visual Studio project.First create new application for that open visual studio -- Project Now select “Asp.Net Empty Web Application” and give project name as “LINQ2SQL” and click OK like as shown below Now we finished creating new project.Just remember the file name and where the file is stored when importing it in your Visual Studio project or you can specify the path where you want to store the files as they are generated by the tool.