Ticket Hash: | d3d0e0e5e0619716262f5842cdfd5565a703bedc | |||
Title: | Support SQL Server "rowversion" data type | |||
Status: | Deferred | Type: | Feature_Request | |
Severity: | Important | Priority: | Medium | |
Subsystem: | Db_Type_Conversion | Resolution: | Need_More_Info | |
Last Modified: | 2020-03-05 01:02:40 | |||
Version Found In: | Nuget System.Data.SQLite.Core 1.0.112 | |||
User Comments: | ||||
anonymous added on 2019-12-04 15:16:25:
I have a table with a "rowversion" sql data type. These columns should be NOT NULL and are managed by SQL Server. When our ORM (NHibernate) tries to create a record when pointing towards SQLite, I get an issue where it can't insert null into my row version column. Also, "rowversion" columns don't allow for default values and can't have it set by the INSERT or UPDATE. SQLite should update the rowversion columns anytime there is an update to the data in the row and should be generated on insert mistachkin added on 2019-12-08 19:10:04: I don't quite understand the problem being described as it pertains to SQLite or System.Data.SQLite. Perhaps you could post the portion of the schema and/or C# code that demonstrates the problem? |