public override void Add(string name, object value = null, DbGenericType? dbType = null, ParameterDirection? direction = null, int? size = null) { if (value is bool) value = (bool)value ? 1 : 0; //Oracle doesn't like BOOL. base.Add(name, value, dbType, direction, size); }
private static DbType ConvertGenericTypeToCustomType(DbGenericType type) { switch (type) { case DbGenericType.String: return DbType.String; case DbGenericType.Fraction: return DbType.Decimal; case DbGenericType.Number: return DbType.Int64; case DbGenericType.Bool: return DbType.Boolean; case DbGenericType.DateTime: return DbType.DateTime; case DbGenericType.LargeObject: return DbType.Object; default: return DbType.String; } }
private static DbType ConvertGenericTypeToCustomType(DbGenericType type) { switch (type) { case DbGenericType.String: return DbType.String; case DbGenericType.Fraction: return DbType.Decimal; case DbGenericType.Number: return DbType.Int64; case DbGenericType.Bool: return DbType.Int16; //Silly, I know, but Oracle doesn't support Boolean types. case DbGenericType.DateTime: return DbType.DateTime; case DbGenericType.LargeObject: return DbType.Object; default: return DbType.String; } }