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; } }