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 upgraded a project from LS2 to LS3, but have some problems to save som different "Properties/Fields" to the database. It is working perfect with 2.2.1328.12347, but with 3.0.835.12716 not every fields it acctually updated to database (reading log file)... The fields are Nullable<int> fields, but I don't think that is the problem. It seems to me that the "sql update" is different from 2.2 to 3.0 :-) |
|
|
Hi, Could you please provide the SQL being generated and what you think should be getting generated? Do you have optimistic concurrency enabled? We made an improvement t LightSpeed with 3.0 where if optimistic concurrency was enabled then only the altered properties would be emitted as part of the UPDATE statement. Could this be related to what you are seeing? Thanks, John-Daniel Trask |
|
|
Using optimistic concurrency yes :) Before attach/savechanges i see that the entity has new state, but in the sql generated the properties/field is not used... I will try to make a test scratch solution that and try to produce the problem...if got it i will post it here... |
|
|
Is it possibly to turn this off within the context? This features is a problem in 1 project...winform hell :-) |
|
|
Hi Christian, We're open to extending how this works however I'm curious to find out why things are going wrong for you so that we can be sure there isn't a bigger problem here OR if there is a better solution than just turning off partial updates. Could you elaborate on what is actually going wrong? Kind regards, John-Daniel Trask |
|
|
When saving only few properties was commited to the sql query even when I se that the other entity properties has been changed and added/attached to the UnitOfWork... If I try to save multiples times it will be save some times... |
|
|
Hi Christian, That sounds like a serious issue and I cannot reproduce it. I would rather solve the problem by not having LightSpeed behave the way you describe and rather "just work". Are you able to provide a simple repro demonstrating this behavior so that I can roll out of a fix for you? We can still look at making this whole behavior as a configuration option but we really need to resolve the issue your seeing also. Thanks! John-Daniel |
|