DapperLib / DapperLib/Dapper.Contrib
Insert method does not generate SQL suitable for PostgresSQL
Nobody has claimed this yet.
- Dominant language
- C#
- Stars
- 293
- Forks
- 109
- PR merge metrics
- No merged PRs in 30d
Description
The method generates sql that returns the identifier that was generated by the database, but the sql writing that was generated from the returning writes a reserved word from the postgres database (it should write the "Id" field in double quotation marks to identify the field). For this reason, it generates an error in the insertion. Is there any way to convert this situation?
This is the SQL generated by contrib
insert into "User" ("Name", "Email", "PasswordHash", "Bio", "Image", "Slug") values ($1, $2, $3, $4, $5, $6) RETURNING Id
Contributor guide
No contributing guide indexed for this repository
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Locate the Insert method that produces the shown SQL and reproduce the PostgreSQL insertion failure. Ensure the generated RETURNING clause quotes the Id field, then verify that the insertion succeeds without the reserved-word error.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- csharp, postgres
- Domain
- database
- Issue type
- Bug
- Difficulty
- 2/5
- Estimated time
- 1-3 hours
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 45/100