Sql generated by Linq

Question

Sql generated by Linq

Navigation

#1 by (1 votes)

2

Hello, I would like to know how to view the sql code that a linq expression generates to be run by ADO.Net.

I'm using NHibernate as an ORM framework.

c# .net nhibernate linq

asked by anonymous 03.03.2016 / 20:49

1 answer

LEFT Outer Join does not work in LINQ when 0 is the reference? only null How do two objects always keep the same distance from each other?

score 1 · Accepted Answer

Make a function like this

public string GetGeneratedSql(System.Linq.IQueryable queryable, ISession session)
{
    var sessionImp = (ISessionImplementor) session;
    var nhLinqExpression = new NhLinqExpression(queryable.Expression, sessionImp.Factory);
    var translatorFactory = new ASTQueryTranslatorFactory();
    var translators = translatorFactory.CreateQueryTranslators(nhLinqExpression, null, false, sessionImp.EnabledFilters, sessionImp.Factory);

    return translators[0].SQLString;
}

Font