难以置信,我找不到答案,但你如何执行像下面这样的查询:
SELECT LTRIM(RTRIM("ColumnName")) FROM ....
在NHibernate中
谢谢
难以置信,我找不到答案,但你如何执行像下面这样的查询:
SELECT LTRIM(RTRIM("ColumnName")) FROM ....
在NHibernate中
谢谢
作为POCO的银行示例:
public class Bank
{
public virtual int ID { get; set; }
public virtual string City { get; set; }
public virtual string Street { get; set; }
}
对于 LTRIM(RTRIM...
有一种语法。
Bank bank = null;
var session = ...;
var query = session.QueryOver<BankAddress>()
.SelectList(l => l
// properties ID, City
.Select(c => c.ID).WithAlias(() => bank.ID)
.Select(c => c.City).WithAlias(() => bank.City)
// projection Street
.Select(Projections.SqlProjection(
" LTRIM(RTRIM({alias}.Street)) as Street" // applying LTRIM(RTRIM
, new string[] { "Street" }
, new IType[] { NHibernate.NHibernateUtil.String }
))
.TransformUsing(Transformers.AliasToBean<Bank>())
;
var list = query.List<Bank>();