|zyciis| Nhibernate 如何进行有函数转换的子查询，谢谢

zyciis166 2010-08-04 11:43:26

如SQL
select
(select top 1 [name]
from sys_manager
where sys_company.guid = sys_manager.companyguid) AS FirstManager
from sys_company
用以下方法可以生成



[NUnit.Framework.Test]

public void SubFieldQuery()

{

    var session = Z.Core.NHibernateCore.NHibernateHelper.GetCurrentSession();

    var subCrit = NHibernate.Criterion.DetachedCriteria.For<Model.Sys.Manager>("M");

    subCrit.SetProjection(NHibernate.Criterion.Projections.Property("Name"));

    subCrit.SetMaxResults(1);

    subCrit.Add(NHibernate.Criterion.Expression.EqProperty("M.ParentCompany.Guid", "C.Guid"));

    var crit = session.CreateCriteria<Model.Sys.Company>("C");

    crit.SetProjection(NHibernate.Criterion.Projections.ProjectionList()

        .Add(NHibernate.Criterion.Projections.SubQuery(subCrit)));

    var list = crit.List();

    Console.Write(list.Count);

}

然后我要生成语句
select
(select top 1 [name]
from sys_manager
where sys_company.guid = Convert(nvarchar(50), sys_manager.companyguid) ) AS FirstManager
from sys_company



[NUnit.Framework.Test]

public void SubFieldQuery()

{

    var session = Z.Core.NHibernateCore.NHibernateHelper.GetCurrentSession();

    var subCrit = NHibernate.Criterion.DetachedCriteria.For<Model.Sys.Manager>("M");

    subCrit.SetProjection(NHibernate.Criterion.Projections.Property("Name"));

    subCrit.SetMaxResults(1);

    subCrit.Add(NHibernate.Criterion.Expression.Sql("Convert(nvarchar(50), {alias}.CompanyGuid) = this_.Guid"));

    var crit = session.CreateCriteria<Model.Sys.Company>("C");

    crit.SetProjection(NHibernate.Criterion.Projections.ProjectionList()

        .Add(NHibernate.Criterion.Projections.SubQuery(subCrit)));

    var list = crit.List();

    Console.Write(list.Count);

}

上面的写法也可以生成
但是这里有一个地方就是写死的
"Convert(nvarchar(50), {alias}.CompanyGuid) = this_.Guid"
这里的this_.Guid 是我根据SQL最终出来的时候自己补上去的
那这里的this_.Guid要怎么改呢，有没有像
"Convert(nvarchar(50), {alias}.CompanyGuid) = {parent}.Guid"
谢谢

...全文