public static IDbKeeperNetBuilder UseMysql(this IDbKeeperNetBuilder configuration, IConnectionStringProvider connectionStringProvider) { configuration.Services .AddTransient(c => connectionStringProvider) .AddScoped <IDatabaseService, MysqlDatabaseService>() .AddTransient(c => (IDatabaseService <MySqlConnection>)c.GetService <IDatabaseService>()) .AddScoped <IDatabaseServiceTransactionProvider, DatabaseServiceTransactionProvider <MySqlTransaction> >() .AddTransient(c => (IDatabaseServiceTransactionProvider <MySqlTransaction>)c.GetService <IDatabaseServiceTransactionProvider>()) .AddTransient <IDatabaseLock, MySqlDatabaseLock>() .AddTransient <IDatabaseServiceInstaller, MysqlDatabaseServiceInstaller>() .AddTransient <IDatabaseServiceIndexChecker, MySqlDatabaseServiceIndexChecker>() .AddTransient <IDatabaseServiceCommandHandler, GenericDatabaseServiceCommandHandler>() .AddTransient <IUpdateStepExecutedChecker, MySqlUpdateStepExecutedChecker>() .AddTransient <IUpdateStepExecutedMarker, MySqlUpdateStepExecutedMarker>() .AddTransient <IDatabaseServiceForeignKeyChecker, MySqlDatabaseServiceForeignKeyChecker>() .AddTransient <IDatabaseServicePrimaryKeyChecker, MySqlDatabaseServicePrimaryKeyChecker>() .AddTransient <IDatabaseServiceIndexChecker, MySqlDatabaseServiceIndexChecker>() .AddTransient <IDatabaseServiceStoredProcedureChecker, ExistsStoredProcedureChecker>() .AddTransient <IDatabaseServiceTableChecker, MySqlDatabaseServiceTableChecker>() .AddTransient <IDatabaseServiceViewChecker, MySqlDatabaseServiceViewChecker>() .AddTransient <IDatabaseServiceTriggerChecker, ExistsTriggerChecker>() ; return(configuration); }
public static IDbKeeperNetBuilder UseSqlServer(this IDbKeeperNetBuilder builder, string connectionString) { builder.Services .AddScoped <IDatabaseService>(d => new MicrosoftSqlDatabaseService(connectionString, d.GetService <ILogger <MicrosoftSqlDatabaseService> >())) .AddTransient(c => (IDatabaseService <SqlConnection>)c.GetService <IDatabaseService>()) .AddTransient <IDatabaseServiceInstaller, MicrosoftSqlDatabaseServiceInstaller>() .AddScoped <IDatabaseServiceTransactionProvider, DatabaseServiceTransactionProvider <SqlTransaction> >() .AddTransient(c => (IDatabaseServiceTransactionProvider <SqlTransaction>)c.GetService <IDatabaseServiceTransactionProvider>()) .AddTransient <IDatabaseLock, MicrosoftSqlDatabaseLock>() .AddTransient <IDatabaseServiceCommandHandler, GenericDatabaseServiceCommandHandler>() .AddTransient <IDatabaseServiceForeignKeyChecker, MicrosoftSqlDatabaseServiceForeignKeyChecker>() .AddTransient <IDatabaseServicePrimaryKeyChecker, MicrosoftSqlDatabaseServiceIndexChecker>() .AddTransient <IDatabaseServiceIndexChecker, MicrosoftSqlDatabaseServiceIndexChecker>() .AddTransient <IDatabaseServiceStoredProcedureChecker, MicrosoftSqlDatabaseServiceStoredProcedureChecker>() .AddTransient <IDatabaseServiceTableChecker, MicrosoftSqlDatabaseServiceTableChecker>() .AddTransient <IDatabaseServiceViewChecker, MicrosoftSqlDatabaseServiceViewChecker>() .AddTransient <IUpdateStepExecutedChecker, MicrosoftSqlDatabaseServiceUpdateStepExecutedChecker>() .AddTransient <IUpdateStepExecutedMarker, MicrosoftSqlDatabaseUpdateStepExecutedMarker>() .AddTransient <IDatabaseServiceTriggerChecker, ExistsTriggerChecker>() ; return(builder); }
protected override void Configure(IDbKeeperNetBuilder configurationBuilder) { configurationBuilder .UseSQLite(ConnectionString) ; configurationBuilder.Services.AddLogging(c => { c.AddConsole(); }); }
protected override void Configure(IDbKeeperNetBuilder configurationBuilder) { configurationBuilder .UseFirebird(ConnectionStrings.TestDatabase) ; configurationBuilder.Services.AddLogging(c => { c.AddConsole(); }); }
protected override void Configure(IDbKeeperNetBuilder configurationBuilder) { configurationBuilder .UseSQLite("Data Source=endtoend.db3") ; configurationBuilder.Services.AddLogging(c => { c.AddConsole(); }); }
public static IDbKeeperNetBuilder UseSqlServerMembershipAndRoleSetupScript( this IDbKeeperNetBuilder configuration) { configuration .AddEmbeddedResourceScript("DbKeeperNet.Extensions.MsSqlMembershipAndRolesSetup.Setup.xml, DbKeeperNet.Extensions.MsSqlMembershipAndRolesSetup") ; return(configuration); }
protected override void Configure(IDbKeeperNetBuilder configurationBuilder) { configurationBuilder .UseMysql(ConnectionStrings.TestDatabase) .AddEmbeddedResourceScript( "DbKeeperNet.Extensions.Mysql.Tests.MysqlEndToEndTest.xml,DbKeeperNet.Extensions.Mysql.Tests") ; configurationBuilder.Services.AddLogging(c => { c.AddConsole(); }); }
/// <summary> /// Add a new database upgrade script contained in a disk file /// </summary> /// <param name="builder">Configuration builder</param> /// <param name="path">File path</param> /// <returns>The configuration builder for fluent syntax</returns> public static IDbKeeperNetBuilder AddDiskFileScript(this IDbKeeperNetBuilder builder, string path) { builder.AddScript(s => { var logger = s.GetService <ILogger <DiskFileUpdateScriptProvider> >(); return(new DiskFileUpdateScriptProvider(logger, path)); }); return(builder); }
protected override void Configure(IDbKeeperNetBuilder configurationBuilder) { configurationBuilder .UseSQLite("Data Source=endtoend.db3") .AddEmbeddedResourceScript( "DbKeeperNet.Extensions.SQLite.Tests.SQLiteEndToEndTest.xml,DbKeeperNet.Extensions.SQLite.Tests") ; configurationBuilder.Services.AddLogging(c => { c.AddConsole(); }); }
protected override void Configure(IDbKeeperNetBuilder configurationBuilder) { configurationBuilder .UseSqlServer(ConnectionStrings.TestDatabase) .UseAspNetRolesAndMembership() .UseSqlServerMembershipAndRoleSetup() .UseSqlServerMembershipAndRoleSetupScript() ; configurationBuilder.Services.AddLogging(c => { c.AddConsole(); }); }
protected override void Configure(IDbKeeperNetBuilder configurationBuilder) { configurationBuilder .UseSqlServer(ConnectionStrings.TestDatabase) .UseAspNetRolesAndMembership() .UseSqlServerMembershipAndRoleSetup() .UseSqlServerMembershipAndRoleSetupScript() .AddEmbeddedResourceScript("DbKeeperNet.Extensions.AspNetRolesAndMembership.Tests.AspNetMemberShipTest.xml, DbKeeperNet.Extensions.AspNetRolesAndMembership.Tests") ; configurationBuilder.Services.AddLogging(c => { c.AddConsole(); }); }
public static IDbKeeperNetBuilder UseSqlServerMembershipAndRoleSetup(this IDbKeeperNetBuilder configuration) { configuration .AddSchema(@"http://code.google.com/p/dbkeepernet/MsSqlMembershipAndRolesSetup-1.0.xsd", () => XmlReader.Create(typeof(DbKeeperNetBuilderExtensions).Assembly.GetManifestResourceStream( @"DbKeeperNet.Extensions.MsSqlMembershipAndRolesSetup.Resources.MsSqlMembershipAndRolesSetup-1.0.xsd")), typeof(MsSqlMembershipAndRolesSetupType)) ; configuration.Services .AddTransient <IUpdateStepHandler, MsSqlMembershipAndRolesSetupTypeHandlerService>() ; return(configuration); }
public static IDbKeeperNetBuilder UseAspNetRolesAndMembership(this IDbKeeperNetBuilder configuration) { configuration.Services .AddTransient <IAspNetMembershipAdapter, AspNetMembershipAdapter>() .AddTransient <IPreconditionHandler, RoleNotFound>() .AddTransient <IPreconditionHandler, UserNotFound>() .AddTransient <IUpdateStepHandler, AspNetMembershipAccountCreateUpdateStepHandlerService>() .AddTransient <IUpdateStepHandler, AspNetMembershipAccountDeleteUpdateStepHandlerService>() .AddTransient <IUpdateStepHandler, AspNetMembershipRoleCreateUpdateStepHandlerService>() .AddTransient <IUpdateStepHandler, AspNetMembershipRoleDeleteUpdateStepHandlerService>() ; configuration.AddSchema("http://code.google.com/p/dbkeepernet/UpdatesAspNetRolesAndMembership-1.0.xsd", () => XmlReader.Create(typeof(AspNetMembershipAdapter).Assembly.GetManifestResourceStream(@"DbKeeperNet.Extensions.AspNetRolesAndMembership.Resources.UpdatesAspNetRolesAndMembership-1.0.xsd")), typeof(AspNetAccountCreateUpdateStepType), typeof(AspNetAccountDeleteUpdateStepType), typeof(AspNetRoleCreateUpdateStepType), typeof(AspNetRoleDeleteUpdateStepType)); return(configuration); }
public static IDbKeeperNetBuilder UseFirebird(this IDbKeeperNetBuilder configuration, IConnectionStringProvider connectionStringProvider) { configuration.Services .AddTransient(c => connectionStringProvider) .AddScoped <IDatabaseService, FirebirdDatabaseService>() .AddTransient(c => (IDatabaseService <FbConnection>)c.GetService <IDatabaseService>()) .AddScoped <IDatabaseServiceTransactionProvider, DatabaseServiceTransactionProvider <FbTransaction> >() .AddTransient(c => (IDatabaseServiceTransactionProvider <FbTransaction>)c.GetService <IDatabaseServiceTransactionProvider>()) .AddTransient <IDatabaseServiceInstaller, FirebirdDatabaseServiceInstaller>() .AddTransient <IDatabaseServiceCommandHandler, GenericDatabaseServiceCommandHandler>() .AddTransient <IUpdateStepExecutedChecker, FirebirdUpdateStepExecutedChecker>() .AddTransient <IUpdateStepExecutedMarker, FirebirdUpdateStepExecutedMarker>() // TODO: review // .AddTransient<IDatabaseServiceForeignKeyChecker, FirebirdDatabaseServiceForeignKeyChecker>() .AddTransient <IDatabaseServiceForeignKeyChecker, ExistsForeignKeyChecker>() .AddTransient <IDatabaseServiceIndexChecker, FirebirdDatabaseServiceIndexChecker>() .AddTransient <IDatabaseServicePrimaryKeyChecker, FirebirdDatabaseServiceIndexChecker>() .AddTransient <IDatabaseServiceStoredProcedureChecker, ExistsStoredProcedureChecker>() .AddTransient <IDatabaseServiceTableChecker, FirebirdDatabaseServiceTableChecker>() .AddTransient <IDatabaseServiceViewChecker, FirebirdDatabaseServiceViewChecker>() .AddTransient <IDatabaseLock, FirebirdDatabaseLock>() .AddTransient <IDatabaseServiceTriggerChecker, FirebirdDatabaseServiceTriggerChecker>() ; configuration .AddScriptSplitter <SqlScriptSplitter>(); return(configuration); }
public static IDbKeeperNetBuilder UseMysql(this IDbKeeperNetBuilder configuration, string connectionString) { return(UseMysql(configuration, new StaticConnectionStringProvider(connectionString))); }
public static IDbKeeperNetBuilder UseFirebird(this IDbKeeperNetBuilder configuration, string connectionStringProvider) { return(UseFirebird(configuration, new StaticConnectionStringProvider(connectionStringProvider))); }
/// <summary> /// Add a new database upgrade script contained in the embedded resource /// </summary> /// <param name="builder">Configuration builder</param> /// <param name="resourceName">Resource name in form of <c>PathToResource.xml,AssemblyName</c></param> /// <returns>The configuration builder for fluent syntax</returns> public static IDbKeeperNetBuilder AddEmbeddedResourceScript(this IDbKeeperNetBuilder builder, string resourceName) { builder.AddScript(c => new EmbeddedResourceUpdateScriptProvider(resourceName)); return(builder); }
protected abstract void Configure(IDbKeeperNetBuilder configurationBuilder);