Question

What is the full form of LINQ? Explain LINQ to SQL.

Answer 1

The LINQ stands for "Language Intergrated Query". It is related to the C# (C sharp a programming language).
There are many types of LINQ, which are as under:

• LINQ to Entities
• LINQ to DataSet
• LINQ to Objects
• LINQ to SQL (DLINQ)
• LINQ to XML(XLINQ)

Advantages of using LINQ are as under:
It has a common and easy syntax for querying to any type of data source.
It fasten the development time, because it catches error at the compile time.
It fills the gap between relational and object oriented approaches.

Expalanation of LINQ to SQL:

LINQ to SQL is an ORM(Object Relational Mapping) framework. It is used to create databased tables based on .net classes.
Selct, Update, Insert and Delete any type of query using LINQ to SQL. It supports C#, Visual Basic etc langauges of .Net.
It supoorts views, stored procedures and transactions. But LINQ to SQL restricts the use of it only on SQL server.
Following are some advantages of LINQ to SQL:

• Debugging support
• Intellisense support
• Compile time error checking

Execution Architecture of LINK to SQL as drawn in below screenshot: