<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
-~----------~----~----~----~------~----~------~--~---
