Hi,
I am doing query from 2 table using join.
config = new NHibernate.Cfg.Configuration();
config.AddAssembly(typeof(CSTS.Main.CashPosting).Assembly);
factory = config.BuildSessionFactory();
session = factory.OpenSession();
query = session.CreateQuery("FROM CashPosting C INNER JOIN FundGroup
F On C.Acct_Cd=F.Acct.Cd WHERE F.Acct_Grp_Cd='ASPRUI'");
IList<CSTS.Main.CashPosting> cashpostlist =
query.List<CSTS.Main.CashPosting>();
grdAll.DataSource = cashpostlist;
grdAll.DataBind();
Here i am adding assebely of Cashposting only not for Fundgroup, so I
am getting error.
outer or full join must be followed by path expression [FROM
CSTS.Main.CashPosting C INNER JOIN FundGroup F On C.Acct_Cd=F.Acct.Cd
WHERE F.Acct_Grp_Cd='ASPRUI']
how can we do nhibernate query with join???
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
