search

jchristn / DatabaseWrapper

Simple database wrapper for Microsoft SQL Server, MySQL, PostgreSQL, and Sqlite written in C# supporting dynamic query building and nesting using expressions.
MIT License
97 stars 26 forks source link

Postgresql database access problem #15

Closed rinkusahu1 closed 1 year ago

rinkusahu1 commented 1 year ago

Hi Joel, It just a great library I came across. I was trying to use gatekeeper nuget package for postgresql database. Did required changes to support it. I was getting a following error. image

In following scenario I reproduced it

  1. Ran GateKeeperConsole project
  2. first time it is running properly and creating all required table in database
  3. during second time execution, it is giving above error I think it is trying to get table information from database, during that time we are getting error. function LoadTableColumnsQuery from DatabaseWrapper.Postgresql/PostgresqlHelper.cs class had hardcode test value. It should be like * "FROM " + database + ".INFORMATION_SCHEMA.COLUMNS cols " + image

Could you please do this changes?

jchristn commented 1 year ago

Thank you for catching this! I am making the changes now and will get published and provides links ASAP

jchristn commented 1 year ago

Fixed in DatabaseWrapper v5.0.2 (NuGet: https://www.nuget.org/packages/DatabaseWrapper/5.0.2, commit: https://github.com/jchristn/DatabaseWrapper/commit/f93176a89653fd39c29cd243d8ffcd25606db811). Moving onto WatsonORM for dependency update, will report back.

jchristn commented 1 year ago

Fixed in v2.1.2 of Watson.ORM.Postgresql: https://www.nuget.org/packages/WatsonORM.Postgresql

Please re-open if any issues!

rinkusahu1 commented 1 year ago

Thank you for doing the changes in a very short time.