Dzoukr / Dapper.FSharp

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

Fix ambiguous column error #87

Closed jindraivanek closed 1 year ago

jindraivanek commented 1 year ago

"Ambiguous column" error can happen when we try to limit select query with join(s) to just one table. This PR fixes that by fully qualifying column names also for select1 when there is some join in query.

Dogs test table was extended with Id column to create ambiguous columns scenario.