public static StepFunctionsBuilder AddSqlWorkers(this StepFunctionsBuilder builder, IEnumerable <DatabaseConfig> databases)
        {
            builder.ServiceCollection.AddTransient <SqlServerBaseDatabase>();
            builder.ServiceCollection.AddTransient <OracleDatabase>();
            builder.ServiceCollection.AddTransient <MySqlDatabase>();
            builder.ServiceCollection.AddTransient <PostgreSqlBaseDatabase>();

            if (databases != null)
            {
                foreach (var database in databases)
                {
                    builder.ServiceCollection.AddSingleton <BaseDatabase>(x =>
                    {
                        BaseDatabase db = (BaseDatabase)x.GetService(Type.GetType(database.Type));
                        db.Config       = database;
                        return(db);
                    });
                }
            }

            builder.AddWorker <SqlQueryWorker>();
            builder.AddWorker <SqlBulkInsertWorker>();
            builder.AddWorker <SqlExportToCsvWorker>();
            return(builder);
        }
Exemple #2
0
        public static StepFunctionsBuilder AddSqlWorkers(this StepFunctionsBuilder builder, IEnumerable <DatabaseConfig> databases)
        {
            if (databases != null)
            {
                foreach (var database in databases)
                {
                    switch (database.Type)
                    {
                    case SqlDatabaseType.SqlServer:
                        builder.ServiceCollection.AddSingleton <BaseDatabase>(x =>
                                                                              new SqlServerBaseDatabase(database));
                        break;

                    case SqlDatabaseType.PostgreSql:
                        builder.ServiceCollection.AddSingleton <BaseDatabase>(x =>
                                                                              new PostgreSqlBaseDatabase(database));
                        break;

                    case SqlDatabaseType.MariaDb:
                    case SqlDatabaseType.MySql:
                        builder.ServiceCollection.AddSingleton <BaseDatabase>(x =>
                                                                              new MySqlDatabase(database));
                        break;

                    default:
                        throw new ArgumentOutOfRangeException();
                    }
                }
            }

            builder.AddWorker <SqlQueryWorker>();
            builder.AddWorker <SqlBulkInsertWorker>();
            return(builder);
        }