Hi,
I'm trying to support different DB vendors with our software. In the next version we like to add the Oracle db, additionally to the existing MS SQL db.
Ok, I know how setup the LLBLGen Pro projects.
The problem here are the small differences between this dbs.
Most of them I've solved writing my own TypeConverter.
But I've no glue is how to solve the following:
In the MS Sql I use TimeStamp for concurrency purposes. The problem here is that Oracle and Microsoft have different opinions what a timestamp should be.
Now, for Microsoft, the timestamp is mapped to a byte-array and the db itself takes care of updating this timestamp. Writing entities with timestamp don't allow to set this field.
On the other side is Oracle. Timestamp is a datetime. And I have to update this field manually.
So what's the best way to handle concurrency no matter what db is used to store the entities?
Thanx and best regards
Christoph
