Entity framework 5 Log

Question

how to convert linq query to sql query in entity framework 5 ?

Manish Kumar Choudhary · Answer

Hi Namit Kumar  You can do the following: var result = from x in appEntities where x.id = 32 select x; var sql = ((System.Data.Objects.ObjectQuery)result).ToTraceString(); or Read these links for details http://msdn.microsoft.com/en-us/magazine/gg490349.aspx http://www.asp.net/mvc/overview/getting-started/getting-started-with-ef-using-mvc/connection-resiliency-and-command-interception-with-the-entity-framework-in-an-asp-net-mvc-application