How can I have NHibernate only generate the SQL without executing it?

by

You can get the generated sql queries without execution with the following methods:

For the NHibernate.Linq queries:

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;
}

For Criteria queries:

public String GetGeneratedSql(ICriteria criteria)
{
    var criteriaImpl = (CriteriaImpl) criteria;
    var sessionImpl = (SessionImpl) criteriaImpl.Session;
    var factory = (SessionFactoryImpl) sessionImpl.SessionFactory;
    var implementors = factory.GetImplementors(criteriaImpl.EntityOrClassName);
    var loader = new CriteriaLoader((IOuterJoinLoadable) factory.GetEntityPersister(implementors[0]), factory, criteriaImpl, implementors[0], sessionImpl.EnabledFilters);

    return loader.SqlString.ToString();
}

For QueryOver queries:

public String GetGeneratedSql(IQueryOver queryOver)
{
    return GetGeneratedSql(queryOver.UnderlyingCriteria);
}

For Hql queries:

public String GetGeneratedSql(IQuery query, ISession session)
{
    var sessionImp = (ISessionImplementor)session;
    var translatorFactory = new ASTQueryTranslatorFactory();
    var translators = translatorFactory.CreateQueryTranslators(query.QueryString, null, false, sessionImp.EnabledFilters, sessionImp.Factory);

    return translators[0].SQLString;
}

More Related Contents:

  1. How to request a random row in SQL?
  2. What is the difference between UNION and UNION ALL?
  3. How can I do an UPDATE statement with JOIN in SQL Server?
  4. Select First Row of Every Group in sql [duplicate]
  5. Comparing Dates in Oracle SQL
  6. The multi-part identifier could not be bound
  7. must appear in the GROUP BY clause or be used in an aggregate function
  8. MySQL number of items within “in clause”
  9. GROUP BY / aggregate function confusion in SQL
  10. Possible to perform cross-database queries with PostgreSQL?
  11. SQL Query to get aggregated result in comma separators along with group by column in SQL Server
  12. Mixing implicit and explicit JOINs
  13. Calendar Table – Week number of month
  14. how can I Update top 100 records in sql server
  15. mysql – how many columns is too many?
  16. SQL Server 2008 – IF NOT EXISTS INSERT ELSE UPDATE
  17. Determine Oracle null == null
  18. What is a simple and efficient way to find rows with time-interval overlaps in SQL?
  19. Errors in SQL Server while importing CSV file despite varchar(MAX) being used for each column
  20. Get the records of last month in SQL server
  21. Log record changes in SQL server in an audit table
  22. alternatives to REPLACE on a text or ntext datatype
  23. How can I backup a remote SQL Server database to a local drive?
  24. Update a column of a table with a column of another table in PostgreSQL
  25. Query json dictionary data in SQL
  26. How to Execute SQL Query without Displaying results
  27. How to insert a string which contains an “&”
  28. Subtracting Dates in Oracle – Number or Interval Datatype?
  29. Syntax to define a NHibernate Filter with Fluent Nhibernate?
  30. Why are aggregate functions not allowed in where clause

Leave a Comment