Where to find translated Linq to Entity query to Sql

Question

I want to get the translated Linq query programmatically and do some stuff with that Sql syntax.

Suppose this is my code:

public class MyApiController:ApiController
{
   public IQueryable<object> Get()
   {
      var objs=Context.Objexts.Where(m=>m.Id>10);
      return objs;
   }
}

I want to find and get the Sql syntax like:

SELECT * FROM dbo.Objexts where Id > 10

Answer 1

You can call the ToString() method on objs. This will result in a call to the ToTraceString method that returns the executed SQL:

string sql = objs.ToString();

Answer 2

another option if you are using Entity Framework 6 is use the new feature to logging whats is happen, you can get the t-sql and the query time:

Logging and Intercepting Database Operations

using (var context = new BlogContext()) 
{ 
    context.Database.Log = Console.Write; //here, you can write this info to a text file for example.

    // Your code here... 
}