public DataConnection CreateVrConnection()
{
var dataConnection = new DataConnection(
SqlServerTools.GetDataProvider(SqlServerVersion.v2012),
_connectionStringSettings.GetConnectionString(ValidationRulesConnectionStringIdentity.Instance, _tenantProvider.Current));
// Schema.Facts needed for Facts.EntityName table
dataConnection.AddMappingSchema(Schema.Facts);
dataConnection.AddMappingSchema(Schema.Messages);
return(dataConnection);
}
public void CreateAllTypes([IncludeDataSources(TestProvName.AllInformix)] string context)
{
using (var db = new DataConnection(context))
{
var ms = new MappingSchema();
db.AddMappingSchema(ms);
ms.GetFluentMappingBuilder()
.Entity <AllType>()
.HasTableName("AllTypeCreateTest");
try
{
db.DropTable <AllType>();
}
catch
{
}
var table = db.CreateTable <AllType>();
table.ToList();
db.DropTable <AllType>();
}
}
private LinqToDBDomainContext CreateDomainContext(StorageMappingDescriptor storageMappingDescriptor)
{
var linqToDbModel = _linqToDbModelFactory.Create(storageMappingDescriptor.EntityContainerName);
var connections = Connections.GetOrAdd(
storageMappingDescriptor.ConnectionStringIdentity,
connectionStringIdentity =>
{
var dataProvider = new SQLiteDataProvider();
var connectionString = _connectionStringSettings.GetConnectionString(connectionStringIdentity);
var connection = (SQLiteConnection)dataProvider.CreateConnection(connectionString);
connection.Open();
var dataConnection = new DataConnection(dataProvider, connection)
{
CommandTimeout = linqToDbModel.QueryExecutionTimeout,
IsMarsEnabled = false
};
dataConnection.AddMappingSchema(linqToDbModel.MappingSchema);
return(Tuple.Create(connection, TuneConnection(dataConnection)));
});
return(new LinqToDBDomainContext(connections.Item1,
connections.Item2,
new ManagedConnectionStateScopeFactory(),
new WritingStrategyFactory(),
linqToDbModel.TransactionOptions,
new NullPendingChangesHandlingStrategy()));
}
public DataConnection CreateDataConnection(string context)
{
var connection = new DataConnection(context);
connection.AddMappingSchema(_schema);
connection.BeginTransaction(System.Data.IsolationLevel.Snapshot);
return(connection);
}
public DataConnection CreateErmConnection()
{
var dataConnection = new DataConnection(
SqlServerTools.GetDataProvider(SqlServerVersion.v2012),
_connectionStringSettings.GetConnectionString(ErmConnectionStringIdentity.Instance, _tenantProvider.Current));
dataConnection.AddMappingSchema(Schema.Erm);
return(dataConnection);
}
public DataConnection CreateDataConnection()
{
var connection = new DataConnection("ValidationRules");
connection
// Schema.Facts needed for Facts.EntityName table
.AddMappingSchema(Schema.Facts)
.AddMappingSchema(Schema.Messages);
return(connection);
}
/// <summary>
/// Creates the database connection
/// </summary>
/// <param name="dataProvider">Data provider</param>
/// <returns>Database connection</returns>
protected virtual DataConnection CreateDataConnection(IDataProvider dataProvider)
{
if (dataProvider is null)
{
throw new ArgumentNullException(nameof(dataProvider));
}
var dataContext = new DataConnection(dataProvider, CreateDbConnection());
dataContext.AddMappingSchema(AdditionalSchema);
return(dataContext);
}
public DataConnection CreateDataConnection(string configurationString)
{
if (!Schemas.TryGetValue(configurationString, out var schema))
{
throw new ArgumentException(nameof(configurationString));
}
var connection = new DataConnection(configurationString);
connection.AddMappingSchema(schema);
//connection.BeginTransaction(System.Data.IsolationLevel.Snapshot);
return(connection);
}
public void BulkCopyLinqTypes(string context)
{
foreach (var bulkCopyType in new[] { BulkCopyType.MultipleRows, BulkCopyType.ProviderSpecific })
{
using (var db = new DataConnection(context))
{
if (bulkCopyType == BulkCopyType.ProviderSpecific)
{
var ms = new MappingSchema();
ms.GetFluentMappingBuilder()
.Entity <LinqDataTypes>()
.Property(e => e.GuidValue)
.IsNotColumn()
;
db.AddMappingSchema(ms);
}
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);
}
}
}
