Linq stands for Language Integrated Query. LINQ to SQL is an ORM (object relational mapping) which allows you to model a relational database using .NET classes.
ORM is not a new for some programmer which already using these mapping tools in Java. Before Linq to sql many .net programmer already using such type of tools like Nhibernate and Sub-Sonic. But due to Microsoft tools its more friendly and easy to learn compare to other ORM in market. You can use native language to query the database using LINQ, With Linq you can select/update/insert/delete data from database.
In LINQ to SQL, the data model of a relational database is mapped to an object model expressed in the programming language of the developer. When the application runs, LINQ to SQL translates into SQL the language-integrated queries in the object model and sends them to the database for execution. When the database returns the results, LINQ to SQL translates them back to objects that you can work with in your own programming language.
LINQ to SQL DMBL designer create DBML file which container classes and properties which mapped to database table reduce the workload for the database application developer. In our tradition application our lots of time involve in creation of Business Objects and Data Access Layer. L2S designer create these classes and business objects for you.
L2S supports transactions, views, and stored procedures. It also provides an easy way to integrate data validation and business logic rules into your data model. L2S automatically generate query on runtime.
Linq stands for Language Integrated Query. LINQ to SQL is an ORM (object relational mapping) which allows you to model a relational database using .NET classes.
ORM is not a new for some programmer which already using these mapping tools in Java. Before Linq to sql many .net programmer already using such type of tools like Nhibernate and Sub-Sonic. But due to Microsoft tools its more friendly and easy to learn compare to other ORM in market. You can use native language to query the database using LINQ, With Linq you can select/update/insert/delete data from database.
In LINQ to SQL, the data model of a relational database is mapped to an object model expressed in the programming language of the developer. When the application runs, LINQ to SQL translates into SQL the language-integrated queries in the object model and sends them to the database for execution. When the database returns the results, LINQ to SQL translates them back to objects that you can work with in your own programming language.
LINQ to SQL DMBL designer create DBML file which container classes and properties which mapped to database table reduce the workload for the database application developer. In our tradition application our lots of time involve in creation of Business Objects and Data Access Layer. L2S designer create these classes and business objects for you.
L2S supports transactions, views, and stored procedures. It also provides an easy way to integrate data validation and business logic rules into your data model. L2S automatically generate query on runtime.
ORM from Microsoft
|
Other non- Micorosft ORM in markets
|
Linq to sql
Entity Framework |
NHibernate
Genome LLBL Gen Pro SubSonic OpenAccess ORM by Telerik |