This thread looks to be a little on the old side and therefore may no longer be relevant. Please see if there is a newer thread on the subject and ensure you're using the most recent build of any software if your question regards a particular product.
This thread has been locked and is no longer accepting new posts, if you have a question regarding this topic please email us at support@mindscape.co.nz
|
I've posted before, but not had an adequate response. So, reposting. So I have a table of just one Id column, which is AI NN, etc. If I want to insert a value into it, I can perform the awesomely complex SQL statement: insert into entitytable values() And that'll generate me a new row. But in lightspeed: Entity entity = new Entity(); uow.Add(entity); uow.SaveChanges(); This fails using MySQL provider. I'm on lightspeed 5 and mysql 5.6: "You are trying to insert an entity of type [redacted] with no values and the provider does not support a default values syntax" Why is this such a problem? It's not a bad database design per-se. Heck, you even use the same model for your KeyTables. So why isn't this supported? Could you guys send me the source code for Lightspeed so I can patch your issue? Thanks, Soen |
|
|
|
|
We dont currently support the default values syntax for MySQL. Ill have a look at adding this in and get back to you with an update.
|
|
|
|
