IdentityServer / IdentityServer3.EntityFramework

EntityFramework persistence layer for IdentityServer3
Apache License 2.0
68 stars 97 forks source link

Entity Token uses MySQL keyword #99

Closed xiongtec closed 8 years ago

xiongtec commented 8 years ago

Token has a property named Key which is a reserved keyword in MySQL.

brockallen commented 8 years ago

And?

xiongtec commented 8 years ago

Sorry forgot to mentioned that it throwing exception when I was using DropCreateDatabaseAlways initializer. The query would get mysql exception until I changed key to TokenKey.

brockallen commented 8 years ago

I guess I don't know enough about how EF and MySql work together to help.

xiongtec commented 8 years ago

hopefully anyone who is using your awesome framework and MySQL this will help them.

brockallen commented 8 years ago

And so do you have a solution to the problem?

xiongtec commented 8 years ago

Key renamed to TokenKey.

brockallen commented 8 years ago

Ah ok, now I understand -- you had to change the column mapping for the Key property. Did you do this by forking the code and doing a custom build, or did you introduce a custom DbContext and override the mapping behavior?

xiongtec commented 8 years ago

took source here https://github.com/Nicholi/IdentityServer3.EntityFramework.MySql and changed the key property because I was also having the timestamp issue earlier the week to.

brockallen commented 8 years ago

Ok, thanks for the info.