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); } } }