What would we return type here if we have list IList<CSTS.Main.CashPosting> cashpostlist = query.List<CSTS.Main.CashPosting>();
On May 28, 5:01 pm, Mitjast <[email protected]> wrote: > 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???- Hide quoted text - > > - Show quoted text - --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
