public static DB2iSeriesDataProvider GetDataProvider(
DB2iSeriesVersion version,
DB2iSeriesProviderType providerType,
DB2iSeriesMappingOptions mappingOptions)
{
return(GetDataProvider(DB2iSeriesProviderName.GetProviderName(version, providerType, mappingOptions)));
}
/// <summary>
/// Build a DB2 iSeries data provider. The name will be infered from options and will be one of the constants in the DB2iSeriesProviderName class
/// </summary>
/// <param name="providerType">Undelying Ado.Net provider type</param>
/// <param name="version">iSeries version</param>
/// <param name="mappingOptions">Mapping specific options</param>
public DB2iSeriesDataProvider(
DB2iSeriesProviderType providerType = DB2iSeriesProviderOptions.Defaults.ProviderType,
DB2iSeriesVersion version = DB2iSeriesProviderOptions.Defaults.Version,
DB2iSeriesMappingOptions mappingOptions = null)
: this(DB2iSeriesProviderName.GetProviderName(version, providerType, mappingOptions ?? DB2iSeriesMappingOptions.Default))
{
}
public static DataConnection CreateDataConnection(
string connectionString,
DB2iSeriesVersion version,
DB2iSeriesProviderType providerType,
bool mapGuidAsString)
{
return(new DataConnection(GetDataProvider(version, providerType, new DB2iSeriesMappingOptions(mapGuidAsString)), connectionString));
}
public DB2iSeriesSqlProviderFlags(
DB2iSeriesVersion version,
DB2iSeriesProviderType providerType)
: this(
supportsOffsetClause : version >= DB2iSeriesVersion.V7_3,
supportsTruncateTable : version >= DB2iSeriesVersion.V7_2,
supportsNamedParameters : providerType.IsIBM()
)
{
}
/// <summary>
/// Build a DB2 iSeries data provider.
/// </summary>
/// <param name="name">Configuration name</param>
/// <param name="providerType">Undelying Ado.Net provider type</param>
/// <param name="version">iSeries version</param>
/// <param name="mappingOptions">Mapping specific options</param>
public DB2iSeriesDataProvider(
string name,
DB2iSeriesProviderType providerType = DB2iSeriesProviderOptions.Defaults.ProviderType,
DB2iSeriesVersion version = DB2iSeriesProviderOptions.Defaults.Version,
DB2iSeriesMappingOptions mappingOptions = null)
: this(new DB2iSeriesProviderOptions(name, providerType, version)
{
MapGuidAsString = mappingOptions?.MapGuidAsString ?? DB2iSeriesProviderOptions.Defaults.MapGuidAsString
})
{
}
public DB2iSeriesSqlProviderFlags(
DB2iSeriesVersion version,
DB2iSeriesProviderType providerType)
: this(
supportsOffsetClause : version >= DB2iSeriesVersion.V7_3,
supportsTruncateTable : version >= DB2iSeriesVersion.V7_2 && !providerType.IsOdbc(),
supportsNamedParameters : providerType.IsIBM(),
supportsMergeStatement : version >= DB2iSeriesVersion.V7_1,
supportsNCharTypes : version >= DB2iSeriesVersion.V7_1
)
{
}
public static string GetProviderName(
DB2iSeriesVersion version,
DB2iSeriesProviderType providerType,
DB2iSeriesMappingOptions mappingOptions)
{
var mapGuidAsString = mappingOptions.MapGuidAsString;
return(providerType switch
{
#if NETFRAMEWORK
DB2iSeriesProviderType.AccessClient => version switch
{
DB2iSeriesVersion.V7_1 => mapGuidAsString ? DB2_AccessClient_71_GAS : DB2_AccessClient_71,
DB2iSeriesVersion.V7_2 => mapGuidAsString ? DB2_AccessClient_72_GAS : DB2_AccessClient_72,
_ => mapGuidAsString ? DB2_AccessClient_73_GAS : DB2_AccessClient_73,
},
public DB2iSeriesProviderOptions(string providerName, DB2iSeriesProviderType providerType, DB2iSeriesVersion version)
: this(providerName, providerType)
{
SupportsOffsetClause = version > DB2iSeriesVersion.V7_2;
SupportsTruncateTable = version > DB2iSeriesVersion.V7_1 && !providerType.IsOdbc();
SupportsMergeStatement = version >= DB2iSeriesVersion.V7_1;
SupportsNCharTypes = version >= DB2iSeriesVersion.V7_1;
}
public DB2iSeriesProviderOptions(string providerName, DB2iSeriesProviderType providerType, DB2iSeriesVersion version)
: this(providerName, providerType)
{
SupportsOffsetClause = version > DB2iSeriesVersion.V7_2;
SupportsTruncateTable = version > DB2iSeriesVersion.V7_1;
}
