Mapping oneToMany object to smooth nhibernate

The problem seems simple, but I'm having so many problems trying to match these objects. I just can't see what I am doing wrong. Can you guys help me?

I have a class Cliente

:

public class Cliente
{    
    public Cliente () { }
    public virtual int ClienteId { get; set; }  
    public IList<Medidor> ListaMedidores { get; set; }   
    public virtual string NumeroMedidor { get; set; }       
}

      

        
        
        
      

    

And class Medidor

public class Medidor
{
    public Medidor() { }
    public virtual string NumeroMedidor { get; set; }
    public virtual string MarcaMedidor { get; set; }
    public virtual Cliente Cliente { get; set; }
}

      

        
        
        
      

    

I tried to display like this

public ClienteMap()
{
    Map(x => x.NumeroMedidor).Column("CORE_NUMERO_MEDIDOR");
    HasMany(x => x.ListaMedidores)
        .KeyColumn("NUMERO_MEDIDOR").Inverse().Cascade.All();
}


public MedidorMap()
{
    Table("medidor");
    LazyLoad();

    Id(x => x.NumeroMedidor).Column("NUMERO_MEDIDOR");
    Map(x => x.TipoMedidor).Column("TIPO_MEDIDOR");
    References(x => x.Cliente).Column("CORE_NUMERO_MEDIDOR");
}

      

        
        
        
      

    

The target is my list Medidor

according to the database. So I did:

Session.Query<Cliente>().Fetch(x => x.ListaMedidores).ToList();

      

        
        
        
      

    

And I get the list always empty. Even with the data on these tables ... I would appreciate any help or suggestion.

Hello

My database is like this:

CREATE TABLE CLIENTE
(
  CORE_ID NUMBER NOT NULL,
  CORE_NUMERO_MEDIDOR VARCHAR2 (50 BYTE)
)

CREATE TABLE MEDIDOR
(
  NUMERO_MEDIDOR VARCHAR2 (50 BYTE),
  MARCA_MEDIDOR VARCHAR2 (50 BYTE)
)

Given sql select * from cliente where core_numero_medidor = '3569371'

:

CORE_ID CORE_NUMERO_MEDIDOR
123     3569371

      

        
        
        
      

    

and sql select * from MEDIDOR where numero_medidor = '3569371'

:

NUMERO_MEDIDOR MARCA_MEDIDOR
3569371        general_motors
3569371        kia
3569371        FIAT

      

        
        
        
      

    

So, I have to get 3 elements in class IList<Medidor> Lista Medidores

on Cliente

..

EDIT

I changed to this:

public class Cliente
{    
    public Cliente () { }
    public virtual int ClienteId { get; set; }  
    public IList<Medidor> ListaMedidores { get; set; }   
    public virtual string NumeroMedidor { get; set; }       
}
public class Medidor
{
    public Medidor() { }
    public virtual string NumeroMedidor { get; set; }
    public virtual string MarcaMedidor { get; set; }
}

      

        
        
        
      

    

And changed the map ClienteMap

to:

Map(x => x.NumeroMedidor).Column("NUMERO_MEDIDOR");    
HasMany(x => x.ListaMedid)
            .KeyColumns.Add("NUMERO_MEDIDOR")
            .Table("MEDID")
            .PropertyRef("CoreNumeroCliente")
            .Cascade.All();

      

        
        
        
      

    

and now the list gets the expected number of entries, but they are all the same as the first ones. i.e:

Expected

NUMERO_MEDIDOR MARCA_MEDIDOR
3569371        general_motors
3569371        kia
3569371        FIAT

      

        
        
        
      

    

My result

NUMERO_MEDIDOR MARCA_MEDIDOR
3569371        general_motors
3569371        general_motors
3569371        general_motors

      

        
        
        
      

    

Any suggestions? I'd like to thank @Radim Köhler for the help.

OTHER IMAGE

I found a solution!

I was trying to map a non-unique column as the primary key ... I just changed the column to a real primary key and it works!

So now the solution

public class Cliente
{    
    public Cliente () { }
    public virtual int ClienteId { get; set; }  
    public IList<Medidor> ListaMedidores { get; set; }   
    public virtual string NumeroMedidor { get; set; }       
}
public class Medidor
{
    public Medidor() { }
    public virtual string NumeroMedidor { get; set; }
    public virtual string MarcaMedidor { get; set; }
}

public class ClienteMap : ClassMap<Cliente>
{
    public ClienteMap()
    {
        Map(x => x.NumeroMedidor).Column("NUMERO_MEDIDOR");    
        HasMany(x => x.ListaMedid)
            .KeyColumns.Add("NUMERO_MEDIDOR")
            .Table("MEDID")
            .PropertyRef("CoreNumeroCliente")
            .Cascade.All();
    }
}

public class MedidorMap : ClassMap<Medidor>
{
    public MedidorMap()
    {
        LazyLoad();

        Id(x => x.NumeroMedidor).Column("NUMERO_MEDIDOR");
        Map(x => x.MarcaMedidor).Column("MARCA_MEDIDOR");
        [...] //Other properties
    }
}

      

        
        
        
      

    

And here is my request:

Session.Query<CorteReligacao>()
                .Fetch(x => x.ListaMedid)

      

        
        
        
      

    

I would really like to thank Radim Köhler for his help. His patience, attention and willingness to help solve a problem leave me with a lack of gratitude. I can only wish him all the best in life.

And I really hope this thread can help people with the same problem.

Sincerely.