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