Problem with 'unsigned' columns
Posted: Fri 18 Oct 2019 12:23
Hi!
I'm have some trouble creating a db-first NHibernate model when some table contains an unsigned int column (MySQL 5.1 or MariaDB 10 + Entity Developer 6.5.823)
The generated class has correct type (UInt32, after configuring it in 'Server Options/MySQL') but the associated column has sql type 'int' and no indicator that it's actually an unsigned type:
If I don't make any change to the model, and then I try to update the database from the model, Entity Developer detects some nonexistent changes and it wants to modify the type of the column in the database:
The DDL that creates the sample table is:
Am I missing something?
Thanks!
I'm have some trouble creating a db-first NHibernate model when some table contains an unsigned int column (MySQL 5.1 or MariaDB 10 + Entity Developer 6.5.823)
The generated class has correct type (UInt32, after configuring it in 'Server Options/MySQL') but the associated column has sql type 'int' and no indicator that it's actually an unsigned type:
If I don't make any change to the model, and then I try to update the database from the model, Entity Developer detects some nonexistent changes and it wants to modify the type of the column in the database:
The DDL that creates the sample table is:
Code: Select all
CREATE TABLE Tabla (
Id int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
OtroInt int(10) UNSIGNED NOT NULL,
PRIMARY KEY (Id)
)Thanks!