Hi,
I am doing join in sql query and returning in Ilist., how can we
return list in this query.
config = new NHibernate.Cfg.Configuration();
config.AddAssembly(typeof(CSTS.Main.CashPosting).Assembly);
factory = config.BuildSessionFactory();
session = factory.OpenSession();
IList<> cash = new List<>();
cash= session.CreateSQLQuery("SELECT * FROM CSTS_T_CASH_POSTING C
INNER JOIN CSTS_M_FUNDGROUP F ON C.Acct_Cd=F.Acct_Cd WHERE
F.Acct_Grp_Cd='ASPRUI'","CSTS_T_CASH_POSTING",NHibernateUtil.Class());
grdAll.DataSource = cash;
grdAll.DataBind();
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"nhusers" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/nhusers?hl=en
-~----------~----~----~----~------~----~------~--~---
