Question

I have a table A that has a references to a table B through a third table C. C contains the primary key of A and B. For each A there is at most one record in C. When I try to create a mapping for A such that I am referencing B, I use the References function, but it does not allow me to specify that the mapping goes through another table and not directly. What is the proper way to do that?

Answer 1

I believe I have found the answer in google code samples. In the mapping class, it is possible to write an additional:

WithTable("SomeTable", c => { c.Map(x => x.Col1); });

Answer 2

我所知道唯一能做到这一点的映射是在A的映射中使用HasManyToMany。

HasManyToMany(x => x.B)
    .WithTableName("C")
    .WithParentKeyColumn("A_Id")  
    .WithChildKeyColumn("B_Id");

问题在于映射是A拥有B列表，而不仅仅是一个。我不知道你如何以清晰的方式仅获取一个。

友情链接