If you are trying to do HQL you should use join like this.
FROM CashPosting C INNER JOIN c.FundGroup as F where ....
other wise you can use
session.CreateSQLQuery("Select * FROM CashPosting C INNER JOIN
FundGroup
F On C.Acct_Cd=F.Acct.Cd WHERE F.Acct_Grp_Cd='ASPRUI'")
hope i helped you.
On 28 maj, 10:09, Viki <[email protected]> wrote:
> 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
-~----------~----~----~----~------~----~------~--~---
