protected PostgreSQLDataProvider(string name, MappingSchema mappingSchema)
: base(name, mappingSchema)
{
SqlProviderFlags.IsInsertOrUpdateSupported = false;
SetCharField("bpchar", (r,i) => r.GetString(i).TrimEnd());
_sqlOptimizer = new PostgreSQLSqlOptimizer(SqlProviderFlags);
}
protected FirebirdDataProvider(string name, MappingSchema mappingSchema)
: base(name, mappingSchema)
{
SqlProviderFlags.IsIdentityParameterRequired = true;
SetCharField("CHAR", (r,i) => r.GetString(i).TrimEnd());
SetProviderField<IDataReader,TimeSpan,DateTime>((r,i) => r.GetDateTime(i) - new DateTime(1970, 1, 1));
SetProviderField<IDataReader,DateTime,DateTime>((r,i) => GetDateTime(r, i));
_sqlOptimizer = new FirebirdSqlOptimizer(SqlProviderFlags);
}
protected SQLiteDataProvider(string name, MappingSchema mappingSchema)
: base(name, mappingSchema)
{
SqlProviderFlags.IsSkipSupported = false;
SqlProviderFlags.IsSkipSupportedIfTake = true;
SqlProviderFlags.IsInsertOrUpdateSupported = false;
SetCharField("char", (r,i) => r.GetString(i).TrimEnd());
SetCharField("nchar", (r,i) => r.GetString(i).TrimEnd());
_sqlOptimizer = new SQLiteSqlOptimizer(SqlProviderFlags);
}
protected SqlCeDataProvider(string name, MappingSchema mappingSchema)
: base(name, mappingSchema)
{
SqlProviderFlags.IsSubQueryColumnSupported = false;
SqlProviderFlags.IsCountSubQuerySupported = false;
SqlProviderFlags.IsApplyJoinSupported = true;
SqlProviderFlags.IsInsertOrUpdateSupported = false;
SetCharField("NChar", (r,i) => r.GetString(i).TrimEnd());
_sqlOptimizer = new SqlCeSqlOptimizer(SqlProviderFlags);
}
protected AccessDataProvider(string name, MappingSchema mappingSchema)
: base(name, mappingSchema)
{
SqlProviderFlags.AcceptsTakeAsParameter = false;
SqlProviderFlags.IsSkipSupported = false;
SqlProviderFlags.IsCountSubQuerySupported = false;
SqlProviderFlags.IsInsertOrUpdateSupported = false;
SetCharField("DBTYPE_WCHAR", (r,i) => r.GetString(i).TrimEnd());
SetProviderField<IDataReader,TimeSpan,DateTime>((r,i) => r.GetDateTime(i) - new DateTime(1899, 12, 30));
SetProviderField<IDataReader,DateTime,DateTime>((r,i) => GetDateTime(r, i));
_sqlOptimizer = new AccessSqlOptimizer(SqlProviderFlags);
}
protected SybaseDataProvider(string name, MappingSchema mappingSchema)
: base(name, mappingSchema)
{
SqlProviderFlags.AcceptsTakeAsParameter = false;
SqlProviderFlags.IsSkipSupported = false;
SqlProviderFlags.IsSubQueryTakeSupported = false;
SqlProviderFlags.IsCountSubQuerySupported = false;
SqlProviderFlags.CanCombineParameters = false;
SetCharField("char", (r,i) => r.GetString(i).TrimEnd());
SetCharField("nchar", (r,i) => r.GetString(i).TrimEnd());
SetProviderField<IDataReader,TimeSpan,DateTime>((r,i) => r.GetDateTime(i) - new DateTime(1900, 1, 1));
SetProviderField<IDataReader,DateTime,DateTime>((r,i) => GetDateTime(r, i));
_sqlOptimizer = new SybaseSqlOptimizer(SqlProviderFlags);
}
protected InformixDataProvider(string name, MappingSchema mappingSchema)
: base(name, mappingSchema)
{
SqlProviderFlags.IsParameterOrderDependent = true;
SqlProviderFlags.IsSubQueryTakeSupported = false;
SqlProviderFlags.IsInsertOrUpdateSupported = false;
SqlProviderFlags.IsGroupByExpressionSupported = false;
SetCharField("CHAR", (r,i) => r.GetString(i).TrimEnd());
SetCharField("NCHAR", (r,i) => r.GetString(i).TrimEnd());
if (!Configuration.AvoidSpecificDataProviderAPI)
{
SetProviderField<IDataReader,float, float >((r,i) => GetFloat (r, i));
SetProviderField<IDataReader,double, double >((r,i) => GetDouble (r, i));
SetProviderField<IDataReader,decimal,decimal>((r,i) => GetDecimal(r, i));
}
_sqlOptimizer = new InformixSqlOptimizer(SqlProviderFlags);
}
public FirebirdSqlBuilder(ISqlOptimizer sqlOptimizer, SqlProviderFlags sqlProviderFlags)
: base(sqlOptimizer, sqlProviderFlags)
{
}
public SqlServer2005SqlBuilder(MappingSchema mappingSchema, ISqlOptimizer sqlOptimizer, SqlProviderFlags sqlProviderFlags)
: base(null, mappingSchema, sqlOptimizer, sqlProviderFlags)
{
}
SybaseSqlBuilder(bool skipAliases, ISqlOptimizer sqlOptimizer, SqlProviderFlags sqlProviderFlags, ValueToSqlConverter valueToSqlConverter)
: base(sqlOptimizer, sqlProviderFlags, valueToSqlConverter)
{
_skipAliases = skipAliases;
}
public FirebirdDataProvider(ISqlOptimizer sqlOptimizer)
: this(ProviderName.Firebird, new FirebirdMappingSchema(), sqlOptimizer)
{
}
public DB2LUWSqlBuilder(ISqlOptimizer sqlOptimizer, SqlProviderFlags sqlProviderFlags)
: base(sqlOptimizer, sqlProviderFlags)
{
}
public SqlCeSqlBuilder(ISqlOptimizer sqlOptimizer, SqlProviderFlags sqlProviderFlags)
: base(sqlOptimizer, sqlProviderFlags)
{
}
public SapHanaSqlBuilder(ISqlOptimizer sqlOptimizer, SqlProviderFlags sqlProviderFlags, ValueToSqlConverter valueToSqlConverter)
: base(sqlOptimizer, sqlProviderFlags, valueToSqlConverter)
{
}
public DB2iSeriesSqlBuilder7_2(ISqlOptimizer sqlOptimizer, SqlProviderFlags sqlProviderFlags, ValueToSqlConverter valueToSqlConverter) : base(sqlOptimizer, sqlProviderFlags, valueToSqlConverter)
{
}
// used by linq service
public PostgreSQLSqlBuilder(ISqlOptimizer sqlOptimizer, SqlProviderFlags sqlProviderFlags, ValueToSqlConverter valueToSqlConverter)
: base(sqlOptimizer, sqlProviderFlags, valueToSqlConverter)
{
}
public PostgreSQLSqlBuilder(PostgreSQLDataProvider provider, ISqlOptimizer sqlOptimizer, SqlProviderFlags sqlProviderFlags, ValueToSqlConverter valueToSqlConverter)
: this(sqlOptimizer, sqlProviderFlags, valueToSqlConverter)
{
_provider = provider;
}
protected SqlServerSqlBuilder(ISqlOptimizer sqlOptimizer, SqlProviderFlags sqlProviderFlags, ValueToSqlConverter valueToSqlConverter)
: base(sqlOptimizer, sqlProviderFlags, valueToSqlConverter)
{
}
public SqlServer2005SqlBuilder(SqlServerDataProvider?provider, MappingSchema mappingSchema, ISqlOptimizer sqlOptimizer, SqlProviderFlags sqlProviderFlags)
: base(provider, mappingSchema, sqlOptimizer, sqlProviderFlags)
{
}
protected MySqlDataProvider(string name, MappingSchema mappingSchema)
: base(name, mappingSchema)
{
_sqlOptimizer = new MySqlSqlOptimizer(SqlProviderFlags);
}
protected SqlServerSqlBuilder(ISqlOptimizer sqlOptimizer, SqlProviderFlags sqlProviderFlags)
: base(sqlOptimizer, sqlProviderFlags)
{
}
SybaseSqlBuilder(bool skipAliases, ISqlOptimizer sqlOptimizer, SqlProviderFlags sqlProviderFlags)
: base(sqlOptimizer, sqlProviderFlags)
{
_skipAliases = skipAliases;
}
protected DB2SqlBuilderBase(ISqlOptimizer sqlOptimizer, SqlProviderFlags sqlProviderFlags)
: base(sqlOptimizer, sqlProviderFlags)
{
}
public InformixSqlBuilder(ISqlOptimizer sqlOptimizer, SqlProviderFlags sqlProviderFlags)
: base(sqlOptimizer, sqlProviderFlags)
{
}
protected SqlServerSqlBuilder(ISqlOptimizer sqlOptimizer, SqlProviderFlags sqlProviderFlags, ValueToSqlConverter valueToSqlConverter)
: base(sqlOptimizer, sqlProviderFlags, valueToSqlConverter)
{
}
public SqlCeSqlBuilder(ISqlOptimizer sqlOptimizer, SqlProviderFlags sqlProviderFlags, ValueToSqlConverter valueToSqlConverter)
: base(sqlOptimizer, sqlProviderFlags, valueToSqlConverter)
{
}
public SapHanaOdbcSqlBuilder(MappingSchema mappingSchema, ISqlOptimizer sqlOptimizer, SqlProviderFlags sqlProviderFlags)
: base(mappingSchema, sqlOptimizer, sqlProviderFlags)
{
}
SybaseSqlBuilder(bool skipAliases, ISqlOptimizer sqlOptimizer, SqlProviderFlags sqlProviderFlags, ValueToSqlConverter valueToSqlConverter)
: base(sqlOptimizer, sqlProviderFlags, valueToSqlConverter)
{
_skipAliases = skipAliases;
}
public OracleSqlBuilder(ISqlOptimizer sqlOptimizer, SqlProviderFlags sqlProviderFlags)
: base(sqlOptimizer, sqlProviderFlags)
{
}
public SqlServer2008SqlBuilder(ISqlOptimizer sqlOptimizer, SqlProviderFlags sqlProviderFlags)
: base(sqlOptimizer, sqlProviderFlags)
{
}
public PostgreSQLSqlBuilder(ISqlOptimizer sqlOptimizer, SqlProviderFlags sqlProviderFlags)
: base(sqlOptimizer, sqlProviderFlags)
{
}
SybaseSqlBuilder(SybaseDataProvider?provider, bool skipAliases, MappingSchema mappingSchema, ISqlOptimizer sqlOptimizer, SqlProviderFlags sqlProviderFlags)
: base(mappingSchema, sqlOptimizer, sqlProviderFlags)
{
_provider = provider;
_skipAliases = skipAliases;
}
public AccessSqlBuilder(ISqlOptimizer sqlOptimizer, SqlProviderFlags sqlProviderFlags)
: base(sqlOptimizer, sqlProviderFlags)
{
}
public PostgreSQLSqlBuilder(IDataProvider?provider, MappingSchema mappingSchema, ISqlOptimizer sqlOptimizer, SqlProviderFlags sqlProviderFlags)
: base(provider, mappingSchema, sqlOptimizer, sqlProviderFlags)
{
}
