Closed raaffaaeell closed 4 years ago
After further investigation, I see that most of the problems I have are "resolved" in version 2 of this library (beta 7) together with a patch from the FluenMap.Dommel.
One major issue now, after fixing these I posted above (apparently everything is kind of working), when I use ToTable("tblname"), it'll quote it, generating invalid sql (for sql server, at least, it'll be 'select * from [Exame]' which doesnt run).
Also, I think this issue should be moved to the other repo and closed after fixing this quoting bug
You should add [ForeignKey("ID_EXAME_STATUS")]
to the navigation property (e.g. ExameStatus
).
I remember trying that, but didnt work really. The first issue was that it was trying to join Status with Motivo instead of Exame with Motivo, before I used the patches to the latest versions of both libraries.
After the patch, using the code like I posted works ok, it should not ?
@raaffaaeell does it works now?
I didnt reply earlier, but as I said, only works if I use the latest beta7 and apply the patch so FluentMap-Dommel works with the latest version of Dommel
Hello there, currently I'm trying to add this extension (together with fluentmap)
I have a class that has 3 object properties
The field names, as you can see, are not the same as the database ones, I tried using the foreignkey attribute like that, but I hit my first issue. When I use it like this, it first join Exame with ExameMotivo then it tries to join ExameMotivo with ExameStatus. What am I doing wrong there ?
Also, if I specify only one including object, in a query like this
conexao.GetAll<Exame, ExameStatus, Exame>((e, es) => { e.ExameStatus = es; return e; });
It supposedly works, but then I hit another problem. Using regular dapper, when I do this, I write my query and I can specify the splitOn parameter, with the GetAll method it is not possible. Should I just drop this extension and write the queries by hand again ?
If it helps, I have my ExameMap like this