search

fsprojects / SQLProvider

A general F# SQL database erasing type provider, supporting LINQ queries, schema exploration, individuals, CRUD operations and much more besides.
https://fsprojects.github.io/SQLProvider
Other
570 stars 144 forks source link

When row is created, auto_increment column is created as UInt64 #638

Open JP3BGY opened 4 years ago

JP3BGY commented 4 years ago

Description

When row is created by Created(columnOne,columnTwo...) , object mapping to auto_increment column is made as UInt64 even if the column's type is Int.

Repro steps

  1. Create Table containing auto_increment column typed INT in MariaDB
  2. Create row by Create(columnOne,columnTwo,...)()
  3. Get the object of the column from ColumnValues and call GetType() method or call MapTo<> and get type error.

Expected behavior

Int32 or int is returned

Actual behavior

UInt64 is returned

Known workarounds

Type of row.auto_incremented_column is int. Type of the object in row gotten from query{} is also int. It occurs when row is created by Create() .

Related information