SqlServerDbTypeNameToClientTypeResolver

This IResolver<string, Type> implementation converts a SQL Server column data type name — as returned by INFORMATION_SCHEMA.COLUMNS.DATA_TYPE — into its equivalent .NET CLR type (e.g. varchar/nvarchar → string, int → int, uniqueidentifier → Guid, binary/varbinary/timestamp → byte[]). sql_variant resolves to the library’s own SqlVariant marker type. It is the default DbTypeResolver used by SqlServerDbHelper.

Usability

var resolver = new SqlServerDbTypeNameToClientTypeResolver();
var clrType = resolver.Resolve("varchar"); // typeof(string)