Dzoukr/Dapper.FSharp

Add overload on innerJoin keyword to allow join on multiple columns

TerenceHinrichsen opened this issue · 2 comments

TerenceHinrichsen commented

Allows the user to specify either the current setup tableName, colName, col2Name OR
tableName, joinList
Example:

select {
      table "Dogs"
      innerJoin "VaccinationHistory" ["PetOwnerId", "Dogs.OwnerId"; "DogNickname", "Dogs.Nickname"]
      orderBy "Dogs.Nickname" Asc
            }

We have been using this extensively and it works extremely well in our "eventsourced" tables where we have the EntityId and Version as a composite primary key.

Requires update to Net 5.0

I am able to test on MSSQL, but I am having a difficult time with getting the MySQL and PostGres tested, would someone be able to help with those?

Dzoukr commented

Done by... wait for it... YOU! 😁

  • 🎉1
TerenceHinrichsen commented

Thank you so much for your helpful feedback! Many lessons learned!

  • 👍1