LinqToSql Tutorial View Generated SQL
LINQ to SQL follows the following three steps.
- Translate C# code into SQL statements
- Execute SQL on a target database
- Return values back to C# objects.
The simple way of viewing the generated SQL is to use the DataContext.Log property to display SQL code in the console window before the code is executed.
- You can use this property with a query, insert, update, and delete commands.
- It can be useful for understanding LINQ to SQL functionality and for debugging specific problems.
using (var db = new CustomerContext(@"Data Source=(localdb)\ProjectsV13;Initial Catalog=CustomerContext;")) { db.Log = Console.Out; var list = db.Customers.OrderBy(c => c.FirstName).ToList(); }
In this example, the Log property display the following generated SQL in the console window.
SELECT [t0].[CustomerId], [t0].[FirstName], [t0].[LastName], [t0].[Address] FROM [Customers] AS [t0] ORDER BY [t0].[FirstName]