How to view Generated SQL statements by LINQ when querying object?

Question

when we use linq to sql then few visualizer exist which show us what sql is generating by linq but when we query object by linq then is there any way out to have similar sql statement. as exmple

string[] names =
        new string[] { "Jon Skeet", "Marc Gravell", "tvanfosson", 
                       "cletus", "Greg Hewgill", "JaredPar" };

    var results = from name in names
                  where name.StartsWith("J")
                  select name;

can we extract sql from result?

a person advise to use this below function to have sql....

public static class MyExtensions
{
public static string ToTraceString<T>(this IQueryable<T> t)
{
    string sql = "";
    ObjectQuery<T> oqt = t as ObjectQuery<T>;
    if (oqt != null)
        sql = oqt.ToTraceString();
    return sql;
}
}

is it true? if yes can u tell me how to convert my result to IQueryable and then call ToTraceString() method. thanks

In your example you're using LINQ to objects. There's no SQL for it and nothing to extract. Why would you want that? — Sergei Rogovtcev, Aug 05 '12 at 09:02

Paul Fleming · Answer 1 · 2012-08-05T09:13:20.887

2

Linq to objects will not produce SQL for you. This would only be the case if you were using linq to entities or linq to sql.

edited Aug 05 '12 at 09:13

answered Aug 05 '12 at 08:53

Paul Fleming

24,238
8
76
113

It isn't. At least not in linq2objects. – nothrow Aug 05 '12 at 09:01

score 2 · Accepted Answer · edited May 23 '17 at 10:34

I am pretty sure that you cannot use SQL against 'linq2objects', so getting SQL from those is not possible.

Linq 2 objects works, basically, as table-scan in sql. When executed, it reads lines of source one by one, and applies filters/selectors on each of them. See, for exmaple, http://blogs.msdn.com/b/wesdyer/archive/2007/01/03/how-linq-to-objects-queries-work.aspx.

I assume you are interested in debugging query, and there is another topic on stack overflow answering this: How to debug a LINQ Statement

How to view Generated SQL statements by LINQ when querying object?

2 Answers2