Trim NHIBERNATE String

Question

I can’t believe that I did not find the answer to this, but how can you make a request like

SELECT LTRIM(RTRIM("ColumnName")) FROM .... 

at NHibernate

thanks

Answer 1

An example of a bank as POCO:

 public class Bank { public virtual int ID { get; set; } public virtual string City { get; set; } public virtual string Street { get; set; } } 

There is syntax for 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>();