private void ResetSqlType()
{
switch (dbType) {
case DbType.String:
case DbType.AnsiString:
typeCode = SqlTypeCode.VarChar;
break;
case DbType.StringFixedLength:
case DbType.AnsiStringFixedLength:
typeCode = SqlTypeCode.Char;
break;
case DbType.Binary:
typeCode = SqlTypeCode.Binary;
break;
case DbType.Boolean:
typeCode = SqlTypeCode.Boolean;
break;
case DbType.Byte:
typeCode = SqlTypeCode.TinyInt;
break;
case DbType.Int16:
typeCode = SqlTypeCode.SmallInt;
break;
case DbType.Int32:
typeCode = SqlTypeCode.Integer;
break;
case DbType.Int64:
typeCode = SqlTypeCode.BigInt;
break;
case DbType.Single:
typeCode = SqlTypeCode.Float;
break;
case DbType.Double:
typeCode = SqlTypeCode.Double;
break;
case DbType.VarNumeric:
case DbType.Decimal:
case DbType.Currency:
typeCode = SqlTypeCode.Numeric;
break;
case DbType.Date:
case DbType.DateTime2:
typeCode = SqlTypeCode.Date;
break;
case DbType.DateTime:
case DbType.DateTimeOffset:
typeCode = SqlTypeCode.TimeStamp;
break;
case DbType.Time:
typeCode = SqlTypeCode.Time;
break;
case DbType.Object:
case DbType.Xml:
typeCode = SqlTypeCode.Type;
break;
default:
throw new NotSupportedException(String.Format("The DbType '{0}' is not supported by DeveelDB engine", dbType));
}
}