Table names with reserved names throw exception (SQL Server)

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

Closed ssiltanen closed 4 years ago

ssiltanen commented 4 years ago

How to repro:

How to mitigate:

Add [ ] around table name in generated SQL eg. Select .... FROM [Group]
User is able to mitigate this by themselves only if there is no joins or where in the query by adding [] by hand to table definition in select query.

This is also an issue in other queries other than just select.

Not sure if this is an issue in other database engines.

Dzoukr commented 4 years ago

Hello @ssiltanen, thanks for finding out. MSSQ is already fixed, working on MySQL & Postgres. Will release fix soon.

Dzoukr commented 4 years ago

Fixed in v1.12.1