Ori Samara

/// <summary>
/// Extracts the underylying SQL query from an IQueryable datatype
/// </summary>
/// <param name="source">https://visualstudiomagazine.com/blogs/tool-tracker/2011/11/seeing-the-sql.aspx</param>
/// <returns>Returns a SQL Query in a string datatype</returns>
public static string ToSQLQuery<T>(this IQueryable<T> source)
{
    var x = IsNullOrEmpty(Convert.ToString(source)) ? "" : source.ToString().Replace("[Extent", "[D");
    return x;
}

var res = new List<EntityName>();
string query = "";
using (Entities sp = new Entities())
{
    var q = sp.EntityName;
    query = q.ToSQLQuery();
    res = q.ToList();

}

return res;