private bool IsStringType(SqlTypes.SqlType propertyType)
{
switch (propertyType.DbType)
{
case System.Data.DbType.AnsiString:
return(true);
case System.Data.DbType.AnsiStringFixedLength:
return(true);
case System.Data.DbType.String:
return(true);
case System.Data.DbType.StringFixedLength:
return(true);
default:
return(false);
}
}
protected override void InitializeParameter(DbParameter dbParam, string name, SqlTypes.SqlType sqlType)
{
base.InitializeParameter(dbParam, name, sqlType);
// Since the .NET currency type has 4 decimal places, we use a decimal type in PostgreSQL instead of its native 2 decimal currency type.
if (sqlType.DbType == DbType.Currency)
{
dbParam.DbType = DbType.Decimal;
}
}
protected override void InitializeParameter(DbParameter dbParam, string name, SqlTypes.SqlType sqlType)
{
base.InitializeParameter(dbParam, name, sqlType);
if (sqlType.DbType == DbType.Time)
{
((SqlParameter)dbParam).SqlDbType = SqlDbType.Time;
}
}
protected override void InitializeParameter(DbParameter dbParam, string name, SqlTypes.SqlType sqlType)
{
base.InitializeParameter(dbParam, name, sqlType);
switch (sqlType.DbType)
{
case DbType.Time:
((SqlParameter)dbParam).SqlDbType = SqlDbType.Time;
break;
case DbType.Date:
((SqlParameter)dbParam).SqlDbType = SqlDbType.Date;
break;
}
}
protected override void InitializeParameter(DbParameter dbParam, string name, SqlTypes.SqlType sqlType)
{
base.InitializeParameter(dbParam, name, sqlType);
switch (sqlType.DbType)
{
case DbType.Time:
SetSqlDbType(dbParam, SqlDbType.Time);
dbParam.Size = MaxTime;
break;
case DbType.Date:
SetSqlDbType(dbParam, SqlDbType.Date);
break;
}
}
protected override void InitializeParameter(IDbDataParameter dbParam, string name, SqlTypes.SqlType sqlType)
{
base.InitializeParameter(dbParam, name, sqlType);
if (sqlType.DbType == DbType.Currency)
{
dbParam.DbType = DbType.Decimal;
}
}
