protected SapHanaOdbcDataProvider(string name, MappingSchema mappingSchema)
: base(name, mappingSchema, OdbcProviderAdapter.GetInstance())
{
//supported flags
SqlProviderFlags.IsParameterOrderDependent = true;
//supported flags
SqlProviderFlags.IsCountSubQuerySupported = true;
//Exception: Sap.Data.Hana.HanaException
//Message: single-row query returns more than one row
//when expression returns more than 1 row
//mark this as supported, it's better to throw exception
//then replace with left join, in which case returns incorrect data
SqlProviderFlags.IsSubQueryColumnSupported = true;
SqlProviderFlags.IsTakeSupported = true;
SqlProviderFlags.IsDistinctOrderBySupported = false;
//not supported flags
SqlProviderFlags.IsSubQueryTakeSupported = false;
SqlProviderFlags.IsApplyJoinSupported = false;
SqlProviderFlags.IsInsertOrUpdateSupported = false;
SqlProviderFlags.AcceptsOuterExpressionInAggregate = false;
_sqlOptimizer = new SapHanaSqlOptimizer(SqlProviderFlags);
}
protected SapHanaDataProvider(string name, MappingSchema mappingSchema)
: base(name, mappingSchema)
{
//supported flags
SqlProviderFlags.IsCountSubQuerySupported = true;
//Exception: Sap.Data.Hana.HanaException
//Message: single-row query returns more than one row
//when expression returns more than 1 row
//mark this as supported, it's better to throw exception
//instead of replace with left join, in which case returns incorrect data
SqlProviderFlags.IsSubQueryColumnSupported = true;
SqlProviderFlags.IsTakeSupported = true;
SqlProviderFlags.IsDistinctOrderBySupported = false;
//testing
//not supported flags
SqlProviderFlags.IsSubQueryTakeSupported = false;
SqlProviderFlags.IsApplyJoinSupported = false;
SqlProviderFlags.IsInsertOrUpdateSupported = false;
_sqlOptimizer = new SapHanaSqlOptimizer(SqlProviderFlags);
}
protected SapHanaOdbcDataProvider(string name, MappingSchema mappingSchema)
: base(name, mappingSchema)
{
//supported flags
SqlProviderFlags.IsCountSubQuerySupported = true;
//Exception: Sap.Data.Hana.HanaException
//Message: single-row query returns more than one row
//when expression returns more than 1 row
//mark this as supported, it's better to throw exception
//then replace with left join, in which case returns incorrect data
SqlProviderFlags.IsSubQueryColumnSupported = true;
SqlProviderFlags.IsTakeSupported = true;
//testing
//not supported flags
SqlProviderFlags.IsSubQueryTakeSupported = false;
SqlProviderFlags.IsApplyJoinSupported = false;
SqlProviderFlags.IsInsertOrUpdateSupported = false;
_sqlOptimizer = new SapHanaSqlOptimizer(SqlProviderFlags);
}