How to see the actual SQL query generated by Entity Framework in Visual Studio Debug Windows
using (TailspinToysEntities context = new TailspinToysEntities())
{
context.Database.Log = s => System.Diagnostics.Debug.WriteLine(s);
var products =
from product in context.Products
where product.BasePrice > 5.00m
select product;
}
//This will show the SQL in the Output -> Debug window.
//Source: http://blogs.msdn.com/b/mpeder/archive/2014/06/16/how-to-see-the-actual-sql-query-generated-by-entity-framework.aspx