ColumnSchema class had method SetParameterDbType, which set a data type for DbCommand parameter. This method was renamed to SetupParameter, because it is doing more than just setting data type. It should set Size, Precision and Scale as well.
Library name and version
Kros.KORM 3.7.x
Description
Inserting data with DbSet fails when table has some specific columns.
On SQL Server it is decimal column (at least).
On MS Access is is the long text colum.
Exception is thrown when IDbCommand.Prepare() is called. In both cases, the problem is, that command parameters does not have set every needed values: Size for text column and Precision and Scale for numeric column.
We do not support Precision and Scale in our database schema yet, so to fix this issue, we must support them.
Breaking changes
ColumnSchemaclass had methodSetParameterDbType, which set a data type forDbCommandparameter. This method was renamed toSetupParameter, because it is doing more than just setting data type. It should setSize,PrecisionandScaleas well.Library name and version
Description
Inserting data with
DbSetfails when table has some specific columns.decimalcolumn (at least).long textcolum.Exception is thrown when
IDbCommand.Prepare()is called. In both cases, the problem is, that command parameters does not have set every needed values:Sizefor text column andPrecisionandScalefor numeric column.We do not support
PrecisionandScalein our database schema yet, so to fix this issue, we must support them.Steps To Reproduce
DbSet.DbSet.CommitChanges()).Expected behavior
Inserting data should just work.
Actual behavior
Exception is thrown.