this is my version of dlls NHibernate.Linq-1.0.0.Alpha-bin
2009/6/1 Tuna Toksoz <[email protected]> > <class name="User" table="Users" > proxy="IUser" > > > <id name="Id" column="UserId" type="Int32"> > <generator class="native" /> > </id> > > > <property name="InvalidLoginAttempts" type="Int32" /> > > > <property name="RegisteredAt" type="DateTime" /> > <property name="LastLoginDate" type="DateTime" /> > > <property name="Enum1" > type="NHibernate.Linq.Tests.Entities.EnumStoredAsStringType, > NHibernate.Linq.Tests"> > <column name="Enum1" length="12" /> > </property> > > <property name="Enum2" not-null="true" /> > > <many-to-one name="Role" class="Role"> > <column name="RoleId" /> > </many-to-one> > > <component name="Component" class="UserComponent"> > <property name="Property1" type="AnsiString" /> > <property name="Property2" type="AnsiString" /> > > <component name="OtherComponent" class="UserComponent2"> > <property name="OtherProperty1" type="AnsiString" /> > </component> > </component> > <join table="UserName"> > <key column="UserId" not-null="true" /> > <property name="Name" column="Name" type="AnsiString" > not-null="true" /> > </join> > </class> > > > This mapping with > > var query = (from user in nhib.Users > where user.Name == "ayende" > select user).ToList(); > this query produced > > > NHibernate: SELECT this_.UserId as UserId0_0_, this_.InvalidLoginAttempts as > InvalidL2_0_0_, this_.RegisteredAt as Register3_0_0_, this_.LastLoginDate as > LastLogi4_0_0_, this_.Enum1 as Enum5_0_0_, this_.Enum2 as Enum6_0_0_, > this_.RoleId as RoleId0_0_, this_.Property1 as Property8_0_0_, > this_.Property2 as Property9_0_0_, this_.OtherProperty1 as OtherPr10_0_0_, > this_1_.Name as Name1_0_ FROM Users this_ inner join UserName this_1_ on > this_.UserId=this_1_.UserId WHERE this_1_.Name = @p0; @p0 = 'ayende' > > and the result was correct. > > Where did you get the dlls? > > > Tuna Toksöz > Eternal sunshine of the open source mind. > > http://devlicio.us/blogs/tuna_toksoz > http://tunatoksoz.com > http://twitter.com/tehlike > > > > > On Mon, Jun 1, 2009 at 4:33 PM, Ahmed Emad <[email protected]> wrote: > >> yes >> >> 2009/6/1 Tuna Toksoz <[email protected]> >> >> And the query was something like tihs? >>> >>> from q in session.Linq<MyUser>() >>> where q.FirstName=="Fabio" >>> select q >>> >>> >>> >>> ? >>> >>> >>> Tuna Toksöz >>> Eternal sunshine of the open source mind. >>> >>> http://devlicio.us/blogs/tuna_toksoz >>> http://tunatoksoz.com >>> http://twitter.com/tehlike >>> >>> >>> >>> >>> On Mon, Jun 1, 2009 at 4:22 PM, Ahmed Emad <[email protected]> wrote: >>> >>>> sorry for ambiguity in my words >>>> but what i mean that when i tried to Use Linq to Nhibernate >>>> i downloadedd the (dlls) and Linq to Nhibernate worked well >>>> but there were errors while using join like this Example>> >>>> >>>> <?xml version="1.0" encoding="utf-8" ?> >>>> <hibernate-mapping xmlns="urn:nhibernate-mapping-2.2" >>>> assembly="NHibernateTest.Entities" namespace="NHibernateTest.Entities" > >>>> >>>> <class name="MyUser" table="MyUser" lazy="false" > >>>> <id name="UserId" column="UserId" type="Int32"> >>>> <generator class="native"/> >>>> </id> >>>> <property name="UserAge" column="UserAge" type="Int32" >>>> not-null="true" /> >>>> <many-to-one name="Department" class="Department"> >>>> <column name="DepartmentId"/> >>>> </many-to-one> >>>> <join table="UserName"> >>>> <key column="UserId" not-null="true" /> >>>> <property name="FirstName" column="FirstName" type="String" >>>> not-null="true" /> >>>> <property name="SecondName" column="SecondName" >>>> type="String" not-null="true" /> >>>> </join> >>>> </class> >>>> </hibernate-mapping> >>>> >>>> it was working before changing the (dlls) >>>> so i think that the new dlls doesn't suport Join as it was for older >>>> version of NHibernate >>>> so is there anewer version which support Linq & <join> property? >>>> 2009/6/1 Fabio Maulo <[email protected]> >>>> >>>>> 2009/6/1 Ahmed Emad <[email protected]> >>>>> >>>>>> i don't mean that i mean that the NHibernate reference for project >>>>>> which support Linq >>>>>> doesn't support <join> >>>>>> so if i need one i must let the other >>>>>> so, >>>>>> is there is new version which support both? >>>>>> >>>>> >>>>> To hard to understand for me. >>>>> >>>>> -- >>>>> Fabio Maulo >>>>> >>>>> >>>>> >>>> >>>> >>>> >>> >>> >>> >> >> >> > > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
