search

albertodall / IdentityServer4.NHibernate

IdentityServer4.NHibernate is a persistence layer for IdentityServer 4 configuration data that uses NHibernate to access data stored in a database.
Apache License 2.0
8 stars 8 forks source link

MySql support #13

Closed pigsi closed 3 years ago

pigsi commented 3 years ago

Hi , I've tried to use MySql or Postgres but i'm having trouble with the reverved words (Key). the problem is that NHibernate produces SQL stament with the [] format, but brackets are not compatible with these databases. Can you provide a solution that also will work with other db's other that SQL Server and SQLite ? Thank's

MohamedElbasuony1 commented 3 years ago

any updates !? @pigsi @albertodall

albertodall commented 3 years ago

Hello @pigsi Thanks for your feedback I think it's a matter of NHibernate configuration. I'll try to reproduce the issue and find a solution.

pigsi commented 3 years ago

Thank you Alberto, let me know if you have trouble to reproduce this issue.

albertodall commented 3 years ago

@pigsi @MohamedElbasuony1, I should have found the issue, and I'm going to push a fix ASAP. Since MySQL and PostgreSQL are now first class citizens, I need to add these databases to the Integration Test suite.