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
|
Hi! I have set up the keytable in my MsSql database and if I clear it from values "delete from keytable" and add some enteties via my unitOfWork, the table isn't updated. It needs to have an initial value of at least 1. I guess this is "by design", but I also think it can lead to bugs in applications, even though they are easy to find, I dont think it's a "solid" implementation. Is it for performance reasons that you don't use coalesce or a simular check? //Daniel |
|
|
|
|
Hi Daniel, You're right that the key table needs to have an initial value of at least 1, and that this is by design. But you're also right that we ought to check for this rather than just charging ahead and causing the erroneous results you identify. Rather than coalescing, however, we have decided to just fail with an exception if the key table contains no data or a value less than 1. We appreciate that this is less convenient than quietly fixing it up, but we felt the latter option was unsafe: we don't know what other IDs might be in use in the database, so we can't determine a suitable value to which to initialise the key table. This fix will be included in the 17 June 2009 nightly build, available from about 1430 GMT. Thanks for drawing our attention to this! |
|
|
|
