You might wonder which SQL statements are used by LINQ to Entities to interact with the databases. In this section, we will use two ways to view the generated SQL statements used by LINQ to Entities queries. The first one is to use the ToString method and the second one is to use SQL Profiler.
First, let's write a new test method to contain one LINQ to Entities query:
static void ViewGeneratedSQL()
{
using(var NWEntities =
new NorthwindEntities())
{
var beverages =
from p in NWEntities.Products
where p.Category.CategoryName == "Beverages"
orderby p.ProductName
select p;
}
}Now, we can print out the SQL statement of the LINQ to Entities query using the following statement:
// view SQL using ToString method
Console.WriteLine("The SQL statement is:" +...