pinalbhatt
3/9/2015 - 2:14 PM

How to see the actual SQL query generated by Entity Framework in Visual Studio Debug Windows

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