DateTime Column type issue in new Dotmim Version

[lv1986]

Hi,
I have found that all my DateTime Column Types from SQL Server are automatically converted to type text in SQLite database during sync. Do you have any idea why this is happening? In the previous version it is correctly converted to datetime.

I have updated the SQL Script File: https://github.com/Mimetis/LV1986

SQL Server

Sqlite Database created after first sync

[lv1986]

Hi @Mimetis ,
Just following up on this. Did you get time to check this issue?

[Mimetis]

DMS is using the Microsoft.Data.Sqlite.SqliteType to make type conversion.
SQLite internal types are basically:

 public enum SqliteType
 {
     /// <summary>
     ///     A signed integer.
     /// </summary>
     Integer = SQLITE_INTEGER,

     /// <summary>
     ///     A floating point value
     /// </summary>
     Real = SQLITE_FLOAT,

     /// <summary>
     ///     A text string.
     /// </summary>
     Text = SQLITE_TEXT,

     /// <summary>
     ///     A blob of data.
     /// </summary>
     Blob = SQLITE_BLOB
 }

You can read more here: https://learn.microsoft.com/en-us/dotnet/standard/data/sqlite/types.

That's been said, you can still create the empty client database with a Date typed columns in SQLite (which by the way will be converted to text internally, see here : https://www.sqlite.org/datatype3.html), if you prefer