criteria mysql filed_如何从Hibernate Criteria API获取SQL（*不*用于记录）

对于使用NHibernate的用户，这是[ram]的代码的一部分

public static string GenerateSQL(ICriteria criteria)

{

NHibernate.Impl.CriteriaImpl criteriaImpl = (NHibernate.Impl.CriteriaImpl)criteria;

NHibernate.Engine.ISessionImplementor session = criteriaImpl.Session;

NHibernate.Engine.ISessionFactoryImplementor factory = session.Factory;

NHibernate.Loader.Criteria.CriteriaQueryTranslator translator =

new NHibernate.Loader.Criteria.CriteriaQueryTranslator(

factory,

criteriaImpl,

criteriaImpl.EntityOrClassName,

NHibernate.Loader.Criteria.CriteriaQueryTranslator.RootSqlAlias);

String[] implementors = factory.GetImplementors(criteriaImpl.EntityOrClassName);

NHibernate.Loader.Criteria.CriteriaJoinWalker walker = new NHibernate.Loader.Criteria.CriteriaJoinWalker(

(NHibernate.Persister.Entity.IOuterJoinLoadable)factory.GetEntityPersister(implementors[0]),

translator,

factory,

criteriaImpl,

criteriaImpl.EntityOrClassName,

session.EnabledFilters);

return walker.SqlString.ToString();

}