public void BulkCopyLinqTypes([IncludeDataSources(CurrentProvider)] string context)
{
InformixTools.ResolveInformix(typeof(IBM.Data.Informix.IfxConnection).Assembly);
foreach (var bulkCopyType in new[] { BulkCopyType.MultipleRows, BulkCopyType.ProviderSpecific })
{
using (var db = new DataConnection(context))
{
db.BulkCopy(
new BulkCopyOptions {
BulkCopyType = bulkCopyType
},
Enumerable.Range(0, 10).Select(n =>
new LinqDataTypes
{
ID = 4000 + n,
MoneyValue = 1000m + n,
DateTimeValue = new DateTime(2001, 1, 11, 1, 11, 21, 100),
BoolValue = true,
GuidValue = Guid.NewGuid(),
SmallIntValue = (short)n
}
));
db.GetTable <LinqDataTypes>().Delete(p => p.ID >= 4000);
}
}
}
/// <summary>
/// Configure connection to use specific Informix provider and connection string.
/// </summary>
/// <param name="builder">Instance of <see cref="LinqToDbConnectionOptionsBuilder"/>.</param>
/// <param name="connectionString">Informix connection string.</param>
/// <param name="useDB2Provider">if <c>true</c>, <c>IBM.Data.DB2</c> provider will be used; othwerwise <c>IBM.Data.Informix</c>.</param>
/// <returns>The builder instance so calls can be chained.</returns>
public static LinqToDbConnectionOptionsBuilder UseInformix(this LinqToDbConnectionOptionsBuilder builder, string connectionString, bool useDB2Provider)
{
return(builder.UseConnectionString(
InformixTools.GetDataProvider(useDB2Provider ? ProviderName.InformixDB2 : ProviderName.Informix),
connectionString));
}
