Hello I am wondering if anyone has a solution to my issue, I am using SQLite for my testing, and have run into an issue with my RowVersion column. In SQL 2005 this is a timestamp column and I have no issues issuing an update.

But when running the test on my SQLite instance, I get a locking error. My code looks something like so, I assume mostly due to not generating the timestamp, is there a way around this to be able to do my testing with sqlite.

// Select and update name.
var ins = repository.SelectById(id);
ins.Name = name;

// Update
repository.Update(ins);

The error I get is : "Row was updated or deleted by another transaction"


As I said running that update against my SQL server has no issues I
assume because the rowversion is being generated: I am mapping the
version like so using a custom type:

<version name="RowVersion" column="RowVersion"
type="NHTimestamp, Core"
generated="always" unsaved-value="null" />


Cheers