Simple mapping in fluent nhibernate

Question

I have a class Client which has a attribute of dogs

public class ClientsMap : ClassMap<Clients>
{
    public ClientsMap()
    {           
        Id(x => x.ClientID);
        HasMany(x => x.Dogs);
    }
}

public class Client
{

    public virtual IList<Dog> Dogs { get; set; }
    public virtual int ClientID { get; set; }
}

and a class of dog that references client.

public class Dog
{
    public virtual Clients Client { get; private set; }
    public virtual int Id { get; set; }
}

public class DogMap : ClassMap<Dog>
{
    public DogMap()
    {
        Table("Pooches");
        Id(x => x.Id);

        References(x => x.Client).Column("ClientId");
    }

}

Because I am mapping on to an existing DB i cannot change the field names.

When I try and return the dogs collection I am getting an invalid column error on client_id with the SQL

SELECT 
dogs0_.Clients_id as Clients3_1_, 
dogs0_.Id as Id1_, 
dogs0_.Id as Id1_0_, 
dogs0_.ClientId as ClientId1_0_ 
FROM 
pooches dogs0_

How can I make this use clientid over cliet_id. I thought I specified this in the dogs map.

Cole W · Accepted Answer · 2011-10-31 13:21:39Z

1

You should also specify the column name on the one to many relationship.

HasMany(x => x.Dogs)
    .KeyColumn("ClientId");

answered Oct 31, 2011 at 13:21

Cole W

15.4k7 gold badges56 silver badges88 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Johnno Nolan Over a year ago

i know its would be something simple... Couldn't find the answer in TFM.. thanks

Collectives™ on Stack Overflow

Simple mapping in fluent nhibernate

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related