Timestamp / rowversion data type support?

Timestamp / rowversion data type support?

Postby nhc1987 » Wed 14 Mar 2012 03:24

Hi,

Is TIMESTAMP (rowversion) data type supported in dotConnect for MySQL?

We have a table with a timestamp column. Everything goes well with MS SQL but we got problem when switching to MySQL with Devart dotConnect.

We are using Entity Framework 4.2 code first and Devart dotConnect 6.7. We also tried the free Connect/NET from Oracle and got the same problem.

The detailed exception is as below

Schema specified is not valid. Errors:
(94,6) : error 0040: The Type rowversion is not qualified with a namespace or alias. Only primitive types can be used without qualification.
(155,6) : error 0040: The Type rowversion is not qualified with a namespace or alias. Only primitive types can be used without qualification.
(165,6) : error 0040: The Type rowversion is not qualified with a namespace or alias. Only primitive types can be used without qualification.


Could you guys please advice?

Regards,
Michael
Last edited by nhc1987 on Fri 16 Mar 2012 04:20, edited 2 times in total.
nhc1987
 
Posts: 2
Joined: Wed 14 Mar 2012 02:49

Postby Shalex » Thu 15 Mar 2012 15:39

The .IsRowVersion() call itself for binary property sets the data type to "rowversion" if the correct database-specific data type was not set before using .HasColumnType(string).
This optimization was made for SQL Server and it is not suitable for other RDBMS because other servers do not have the "rowversion" data type. We recommend to call .IsRowVersion() only in case when .HasColumnType(string) was invoked before.
Shalex
Devart Team
 
Posts: 7839
Joined: Thu 14 Aug 2008 12:44

Postby nhc1987 » Mon 19 Mar 2012 08:04

Thanks Shalex. We will try to find another way to deal with this limitation.
nhc1987
 
Posts: 2
Joined: Wed 14 Mar 2012 02:49

Re: Timestamp / rowversion data type support?

Postby Shalex » Thu 05 Mar 2015 12:27

The capability to create an automatically updated timestamp column via either the Timestamp attribute or the .IsTimestamp() method of Code-First fluent mapping is supported in dotConnect for MySQL starting from the 8.3.359 (26-Feb-15) build.
Shalex
Devart Team
 
Posts: 7839
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for MySQL