public override DbType GetDbColumnType(string providerDbType)
{
switch (providerDbType.ToLower())
{
case "bigint":
return DbType.Int64;
case "binary":
case "image":
case "timestamp":
case "varbinary":
case "rowversion":
return DbType.Binary;
case "bit":
return DbType.Boolean;
case "char":
return DbType.AnsiStringFixedLength;
case "datetime":
case "smalldatetime":
return DbType.DateTime;
case "decimal":
return DbType.Decimal;
case "float":
return DbType.Double;
case "int":
return DbType.Int32;
case "money":
case "smallmoney":
return DbType.Currency;
case "nchar":
return DbType.StringFixedLength;
case "ntext":
case "nvarchar":
return DbType.String;
case "real":
return DbType.Single;
case "uniqueidentifier":
return DbType.Guid;
case "smallint":
return DbType.Int16;
case "text":
case "varchar":
return DbType.AnsiString;
case "tinyint":
return DbType.Byte;
default:
return DbType.AnsiString;
}
}