SdsSqLiteDbTypeNameToClientTypeResolver

This IResolver<string, Type> implementation converts a SQLite column data type name into its equivalent .NET CLR type, specifically for the System.Data.SQLite.Core driver (“Sds”). It is not wired up automatically by SqliteBootstrap — that class defaults to MdsSqLiteDbTypeNameToClientTypeResolver for Microsoft.Data.Sqlite. Supply this resolver explicitly when your application connects through System.Data.SQLite.Core instead.

Reflecting how System.Data.SQLite.Core reads back SQLite columns with stronger typing, date/datetime/time resolve to DateTime, boolean resolves to long, and decimal/numeric resolve to decimal — all different from MdsSqLiteDbTypeNameToClientTypeResolver’s mappings for those same type names.

Usability

var dbSetting = new SqLiteDbSetting();
var dbHelper = new SqLiteDbHelper(dbSetting, new SdsSqLiteDbTypeNameToClientTypeResolver());
DbHelperMapper.Add<SqliteConnection>(dbHelper, true);