search

Dzoukr / Dapper.FSharp

Lightweight F# extension for StackOverflow Dapper with support for MSSQL, MySQL, PostgreSQL, and SQLite
MIT License
374 stars 35 forks source link

Add overload on innerJoin keyword to allow join on multiple columns #36

Closed TerenceHinrichsen closed 3 years ago

TerenceHinrichsen commented 3 years ago

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 3 years ago

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

TerenceHinrichsen commented 3 years ago

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