Mysql: Entity __ has database generated fields that don't contain a primary key. about fastcrud HOT 5 CLOSED

I think you're on to something here. Basically your entity has no key properties generated by the database but you do have non-key db generated columns. This looks like a missed case and does require extra code. Currently the code creates SQL that relies on LAST_INSERT_ID() to fetch the db generated columns, which in your case makes no sense.

from fastcrud.

Given the right conditional statement, could something like this work to construct the select statement?

sql += $"SELECT {databaseGeneratedColumnSelection} FROM {this.GetTableName()} WHERE" + this.ConstructKeysWhereClause(this.GetTableName())

from fastcrud.

I don't think ConstructKeysWhereClause requires an alias but other than that it looks good. Could you create a PR? We're in the middle of the beta for 2.4.0 so this one couldn't have come at a better time.

from fastcrud.

Probably should have mentioned that I already started on it tonight: #35.

from fastcrud.

Thanks for providing a fix. The existing tests all passed and a preview package is available on nuget.

from fastcrud.