Hi,
I think there might be a bug here.
It has to do with the "casing"
The mapping.
Set(x => x.CurrentlyReading, mapper =>
{
mapper.Table("UsersReadingBooks");
mapper.Key(y => y.Column("`User`"));
}, element =>
{
element.ManyToMany(y =>
{
y.Class(typeof(Book));
y.Column("Book");
//y.Column("book");
});
});
Generated sql:
SELECT currentlyr0_.[User] as User1_1_, currentlyr0_.elt as elt1_,
book1_.Id as Id4_0_, book1_.Name as Name4_0_, book1_.ImageUrl as
ImageUrl4_0_, book1_.Image as Image4_0_, book1_.Author as Author4_0_
FROM UsersReadingBooks currentlyr0_ left outer join Books book1_ on
currentlyr0_.elt=book1_.Id WHERE currentlyr0_.[User]=?
The problem is the "currentlyr0_.elt"-column that doesn't exists. This
should be "currentlyr0_.Book".
However is I use y.Column("book") -> all in lowercase, then the
generated sql is as it should be
Best regards,
Ike
--
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.
