Yes, it's simpler when you want to answer the question : "What account has
<this> client?" but actually i'm trying to answer the question: "Who is the
owner of <this> user account" . However I've decided to change the mapping
and refuse to "ReferencesAny" because as the nhforge.org says it has many
limitations. Instead i've created intermediate tables such as
"UserAccountToEmployee" and "UserAccountToClient", mapping at ClientMap,
and EmployeeMap that they "HasOne(x => x.UserAccount)", and mapping at
these intermediate tables that they "References(x => x.Employee/Client)".
Thank you for trying to help me. If you see something wrong with this
approach please share :) Thank you!!
Cu stimă,
Eriomenco Cristian
------------------
tel: +373 078 213 175
e-mail: cristian.eriome...@gmail.com
2014-02-23 22:36 GMT+02:00 Chris Bingham <ccb...@gmail.com>:
> alternatively, if Client holds a reference to UserAcount then a simpler
> solution would be to query through the Client?
>
> (using linq, sorry i tend to avoid QueryOver)
> session.Query<Client>().Where(c => c.Id == {idToFind}).Select(c =>
> c.UserAccount)
>
>
> On 23 February 2014 09:48, Cristian Eriomenco <
> cristian.eriome...@gmail.com> wrote:
>
>> Good idea I'll try it. Thanks
>>
>> Cu stimă,
>> Eriomenco Cristian
>> ------------------
>> tel: +373 078 213 175
>> e-mail: cristian.eriome...@gmail.com
>>
>>
>> 2014-02-22 22:58 GMT+02:00 Chris Bingham <ccb...@gmail.com>:
>>
>>> Use an interface rather than object?
>>> On 21 Feb 2014 17:39, "Cristian Eriomenco" <cristian.eriome...@gmail.com>
>>> wrote:
>>>
>>>> have an UserAccount class, which may belong to an Employee or a Client
>>>>
>>>> I don't know how to QueryOver a object OwnerRefObject field, with a
>>>> filter.
>>>>
>>>> For Example:
>>>>
>>>> public class UserAccount{
>>>> public virtual int Id {get;set;}
>>>> public virtual string UserName {get;set;}
>>>> public virtual string Password {get;set;}
>>>> public virtual object OwnerRefObject {get;set;}}
>>>> public class UserMap:<User>{
>>>> public UserMap()
>>>> {
>>>> Id(x => x.Id).GeneratedBy.Indentity();
>>>> Map(x => x.UserName);
>>>> Map(x => x.Password);
>>>> ReferencesAny(x => x.OwnerRefObject)
>>>> .IdentityType<int>()
>>>> .EntityTypeColumn("OwnerObject_Type")
>>>> .EntityIdentifierColumn("OwnerObject_Id")
>>>> .AddMetaValue<Client>(typeof(Client).Name)
>>>> .AddMetaValue<Employee>(typeof(Employee).Name);
>>>> }}
>>>>
>>>> Inside service:
>>>>
>>>> public UserAccount GetClientUserAccountByClientId(int clientId){
>>>> var result = _userAccountRepository
>>>> .QueryOver()
>>>> .Where(x => x.OwnerRefObject is Client)
>>>> // Here I want something like (x => x.OwnerRefObject.Id==clientId)
>>>> .Future()
>>>> .FirstOrDefault();
>>>>
>>>> return result;}
>>>>
>>>> --
>>>> You received this message because you are subscribed to the Google
>>>> Groups "Fluent NHibernate" group.
>>>> To unsubscribe from this group and stop receiving emails from it, send
>>>> an email to fluent-nhibernate+unsubscr...@googlegroups.com.
>>>>
>>>> To post to this group, send email to fluent-nhibernate@googlegroups.com
>>>> .
>>>> Visit this group at http://groups.google.com/group/fluent-nhibernate.
>>>> For more options, visit https://groups.google.com/groups/opt_out.
>>>>
>>> --
>>> You received this message because you are subscribed to a topic in the
>>> Google Groups "Fluent NHibernate" group.
>>> To unsubscribe from this topic, visit
>>> https://groups.google.com/d/topic/fluent-nhibernate/K74kY4f2m4o/unsubscribe
>>> .
>>> To unsubscribe from this group and all its topics, send an email to
>>> fluent-nhibernate+unsubscr...@googlegroups.com.
>>>
>>> To post to this group, send email to fluent-nhibernate@googlegroups.com.
>>> Visit this group at http://groups.google.com/group/fluent-nhibernate.
>>> For more options, visit https://groups.google.com/groups/opt_out.
>>>
>>
>> --
>> You received this message because you are subscribed to the Google Groups
>> "Fluent NHibernate" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to fluent-nhibernate+unsubscr...@googlegroups.com.
>> To post to this group, send email to fluent-nhibernate@googlegroups.com.
>> Visit this group at http://groups.google.com/group/fluent-nhibernate.
>> For more options, visit https://groups.google.com/groups/opt_out.
>>
>
> --
> You received this message because you are subscribed to a topic in the
> Google Groups "Fluent NHibernate" group.
> To unsubscribe from this topic, visit
> https://groups.google.com/d/topic/fluent-nhibernate/K74kY4f2m4o/unsubscribe
> .
> To unsubscribe from this group and all its topics, send an email to
> fluent-nhibernate+unsubscr...@googlegroups.com.
> To post to this group, send email to fluent-nhibernate@googlegroups.com.
> Visit this group at http://groups.google.com/group/fluent-nhibernate.
> For more options, visit https://groups.google.com/groups/opt_out.
>
--
You received this message because you are subscribed to the Google Groups
"Fluent NHibernate" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to fluent-nhibernate+unsubscr...@googlegroups.com.
To post to this group, send email to fluent-nhibernate@googlegroups.com.
Visit this group at http://groups.google.com/group/fluent-nhibernate.
For more options, visit https://groups.google.com/groups/opt_out.
