public int Run(AddMigrationParams migrationParams) { if (!File.Exists(migrationParams.AssemblyFileName)) { return(ExitCode.CanNotFindFile); } var context = DbContextFactory.CreateContextInstance(migrationParams.AssemblyFileName, migrationParams.DbContextTypeFullName); var serviceCollection = new ServiceCollection(); serviceCollection .AddEntityFrameworkDesignTimeServices() .AddDbContextDesignTimeServices(context); var designTimeServices = new SqlServerDesignTimeServices(); designTimeServices.ConfigureDesignTimeServices(serviceCollection); var serviceProvider = serviceCollection.BuildServiceProvider(); var migrationScaffolder = serviceProvider.GetService <IMigrationsScaffolder>(); var migration = migrationScaffolder.ScaffoldMigration( migrationName: migrationParams.MigrationName, rootNamespace: migrationParams.ContextNamespace, subNamespace: migrationParams.SubNamespace, language: Constants.ProgrammingLanguage); var files = migrationScaffolder.Save(migrationParams.ProjectDir, migration, migrationParams.OutputDir); return(ExitCode.Success); }
public static ServiceProvider Build(DatabaseType databaseType) { // Add base services for scaffolding var serviceCollection = new ServiceCollection(); serviceCollection .AddEntityFrameworkDesignTimeServices() .AddSingleton <IOperationReporter, OperationReporter>() .AddSingleton <IOperationReportHandler, OperationReportHandler>(); // Add database provider services switch (databaseType) { case DatabaseType.SQLServer: var provider = new SqlServerDesignTimeServices(); provider.ConfigureDesignTimeServices(serviceCollection); serviceCollection.AddSqlServerStoredProcedureDesignTimeServices(); break; case DatabaseType.SQLServerDacpac: var dacpacProvider = new SqlServerDesignTimeServices(); dacpacProvider.ConfigureDesignTimeServices(serviceCollection); serviceCollection.AddSingleton <IDatabaseModelFactory, SqlServerDacpacDatabaseModelFactory>(); serviceCollection.AddSqlServerDacpacStoredProcedureDesignTimeServices(); break; case DatabaseType.Npgsql: var npgsqlProvider = new NpgsqlDesignTimeServices(); npgsqlProvider.ConfigureDesignTimeServices(serviceCollection); break; case DatabaseType.SQLite: var sqliteProvider = new SqliteDesignTimeServices(); sqliteProvider.ConfigureDesignTimeServices(serviceCollection); break; case DatabaseType.Mysql: var mysqlProvider = new MySqlDesignTimeServices(); mysqlProvider.ConfigureDesignTimeServices(serviceCollection); break; #if CORE50 #else case DatabaseType.Oracle: var oracleProvider = new OracleDesignTimeServices(); oracleProvider.ConfigureDesignTimeServices(serviceCollection); break; #endif default: throw new ArgumentOutOfRangeException(); } return(serviceCollection.BuildServiceProvider()); }
public void GetDatabaseModel() { //SETUP var serviceProvider = new SqlServerDesignTimeServices().GetDesignTimeProvider(); var factory = serviceProvider.GetService <IDatabaseModelFactory>(); //ATTEMPT var model = factory.Create(_connectionString, new string[] { }, new string[] { }); //VERIFY model.ShouldNotBeNull(); }
public void GetIScaffoldingModelFactory() { //SETUP var serviceProvider = new SqlServerDesignTimeServices().GetDesignTimeProvider(); //ATTEMPT var factory = serviceProvider.GetService <IScaffoldingModelFactory>(); //VERIFY factory.ShouldNotBeNull(); factory.ShouldBeType <RelationalScaffoldingModelFactory>(); }
public Stage1ComparerMyEntityDiff(ITestOutputHelper output) { _output = output; _options = this .CreateUniqueClassOptions <MyEntityDbContext>(); var serviceProvider = new SqlServerDesignTimeServices().GetDesignTimeProvider(); var factory = serviceProvider.GetService <IDatabaseModelFactory>(); using (var context = new MyEntityDbContext(_options)) { _connectionString = context.Database.GetDbConnection().ConnectionString; context.Database.EnsureCreated(); _databaseModel = factory.Create(_connectionString, new string[] { }, new string[] { }); } }
public Stage1ComparerMyEntityDiff(ITestOutputHelper output) { _output = output; var serviceProvider = new SqlServerDesignTimeServices().GetDesignTimeProvider(); var factory = serviceProvider.GetService <IDatabaseModelFactory>(); var options = this.CreateUniqueClassOptions <MyEntityDbContext>( builder => builder.ReplaceService <IModelCacheKeyFactory, MyEntityModelCacheKeyFactory>()); using (var context = new MyEntityDbContext(options, MyEntityDbContext.Configs.NormalTable)) { context.Database.EnsureClean(); var connectionString = context.Database.GetDbConnection().ConnectionString; databaseModel = factory.Create(connectionString, new DatabaseModelFactoryOptions(new string[] { }, new string[] { })); } }
public bool ScaffoldDatabase(ScaffoldingExecutorParams scaffoldingParams) { try { var serviceCollection = new ServiceCollection(); serviceCollection.AddEntityFrameworkDesignTimeServices(); var designTimeServices = new SqlServerDesignTimeServices(); designTimeServices.ConfigureDesignTimeServices(serviceCollection); var serviceProvider = serviceCollection.BuildServiceProvider(); var scaffolder = serviceProvider.GetService <IReverseEngineerScaffolder>(); var scaffoldingModel = scaffolder.ScaffoldModel( language: Constants.ProgrammingLanguage, connectionString: scaffoldingParams.ConnectionString, tables: scaffoldingParams.Tables, schemas: new List <string>(), @namespace: scaffoldingParams.DbContextNamespace, contextName: scaffoldingParams.DbContextClassName, codeOptions: new ModelCodeGenerationOptions { SuppressConnectionStringWarning = false, UseDataAnnotations = scaffoldingParams.UseDataAnnotations }, modelOptions: new ModelReverseEngineerOptions { UseDatabaseNames = scaffoldingParams.UseDatabaseNames }, contextDir: scaffoldingParams.OutputFolder); var saveResult = scaffolder.Save( scaffoldingModel, outputDir: scaffoldingParams.OutputFolder, overwriteFiles: true); return(true); } catch (Exception ex) { return(false); } }
public Stage2ComparerMyEntityDiff(ITestOutputHelper output) { _output = output; var options = this .CreateUniqueClassOptions <MyEntityDbContext>(); var serviceProvider = new SqlServerDesignTimeServices().GetDesignTimeProvider(); var factory = serviceProvider.GetService <IDatabaseModelFactory>(); using (var context = new MyEntityDbContext(options)) { var connectionString = context.Database.GetDbConnection().ConnectionString; context.Database.EnsureCreated(); #if NETCOREAPP2_1 _databaseModel = factory.Create(connectionString, new string[] { }, new string[] { }); #elif NETCOREAPP3_0 _databaseModel = factory.Create(connectionString, new DatabaseModelFactoryOptions(new string[] { }, new string[] { })); #endif } }
public void GetBookContextDatabaseModel() { //SETUP var options = this.CreateUniqueClassOptions <BookContext>(); using var context = new BookContext(options); context.Database.EnsureClean(); var serviceProvider = new SqlServerDesignTimeServices().GetDesignTimeProvider(); var factory = serviceProvider.GetService <IDatabaseModelFactory>(); //ATTEMPT var model = factory.Create(context.Database.GetConnectionString(), new DatabaseModelFactoryOptions(new string[] { }, new string[] { })); //VERIFY model.ShouldNotBeNull(); model.Tables.Select(x => x.Name).OrderBy(x => x).ToArray() .ShouldEqual(new [] { "Authors", "BookAuthor", "Books", "BookTag", "PriceOffers", "Review", "Tags" }); model.DefaultSchema.ShouldEqual("dbo"); }
public int Run(ScriptMigrationParams migrationParams) { if (!File.Exists(migrationParams.AssemblyFileName)) { return(ExitCode.CanNotFindFile); } var context = DbContextFactory.CreateContextInstance(migrationParams.AssemblyFileName, migrationParams.DbContextFullName); var serviceCollection = new ServiceCollection(); serviceCollection .AddEntityFrameworkDesignTimeServices() .AddDbContextDesignTimeServices(context); var designTimeServices = new SqlServerDesignTimeServices(); designTimeServices.ConfigureDesignTimeServices(serviceCollection); var serviceProvider = serviceCollection.BuildServiceProvider(); var migrator = serviceProvider.GetService <IMigrator>(); if (!Directory.Exists(migrationParams.OutputPath)) { Directory.CreateDirectory(migrationParams.OutputPath); } foreach (var item in migrationParams.Migrations) { var migrationNames = item.Split(ScriptMigrationParams.MigrationNamesSplitter); var migrationSql = migrator.GenerateScript( fromMigration: migrationNames[0], toMigration: migrationNames[1], idempotent: true); File.WriteAllText(Path.Combine(migrationParams.OutputPath, $"{migrationNames[1]}.sql"), migrationSql); } return(ExitCode.Success); }
public void GetBookContextDatabaseModelWithView() { //SETUP var options = this.CreateUniqueClassOptions <BookContext>(); using var context = new BookContext(options); context.Database.EnsureClean(); var filepath = TestData.GetFilePath("AddViewToBookContext.sql"); context.ExecuteScriptFileInTransaction(filepath); var serviceProvider = new SqlServerDesignTimeServices().GetDesignTimeProvider(); var factory = serviceProvider.GetService <IDatabaseModelFactory>(); //ATTEMPT var model = factory.Create(context.Database.GetConnectionString(), new DatabaseModelFactoryOptions(new string[] { }, new string[] { })); //VERIFY model.ShouldNotBeNull(); model.Tables.Select(x => x.Name).OrderBy(x => x).ToArray() .ShouldEqual(new[] { "Authors", "BookAuthor", "Books", "BookTag", "MyView", "PriceOffers", "Review", "Tags" }); }
static void Main(string[] args) { // Add base services for scaffolding var serviceCollection = new ServiceCollection() .AddScaffolding() .AddLogging(); // Add database provider services var provider = new SqlServerDesignTimeServices(); provider.ConfigureDesignTimeServices(serviceCollection); var serviceProvider = serviceCollection.BuildServiceProvider(); var generator = serviceProvider.GetService <ReverseEngineeringGenerator>(); var options = new ReverseEngineeringConfiguration { ConnectionString = @"Data Source=WIN-DTLAIS5TR8U\LOCALHOST;Integrated Security=True;Initial Catalog=SharedLibrary;MultipleActiveResultSets=True;App=EntityFramework", ProjectPath = @"C:\temp\", ProjectRootNamespace = "My.Namespace" }; generator.GenerateAsync(options).Wait(); }
public EfCoreReverseEngineerResult GenerateFiles(ReverseEngineerOptions reverseEngineerOptions) { var errors = new List <string>(); var warnings = new List <string>(); var reporter = new OperationReporter( new OperationReportHandler( m => errors.Add(m), m => warnings.Add(m))); // Add base services for scaffolding var serviceCollection = new ServiceCollection(); serviceCollection .AddEntityFrameworkDesignTimeServices() .AddSingleton <IOperationReporter, OperationReporter>() .AddSingleton <IOperationReportHandler, OperationReportHandler>(); if (reverseEngineerOptions.UseHandleBars) { //TODO Consider being selective based on SelectedToBeGenerated serviceCollection.AddHandlebarsScaffolding(); serviceCollection.AddSingleton <ITemplateFileService>(provider => new CustomTemplateFileService(reverseEngineerOptions.ProjectPath)); } if (reverseEngineerOptions.CustomReplacers != null) { serviceCollection.AddSingleton <ICandidateNamingService>(provider => new ReplacingCandidateNamingService(reverseEngineerOptions.CustomReplacers)); } if (reverseEngineerOptions.UseInflector) { serviceCollection.AddSingleton <IPluralizer, InflectorPluralizer>(); } // Add database provider services switch (reverseEngineerOptions.DatabaseType) { case DatabaseType.SQLCE35: throw new NotImplementedException(); case DatabaseType.SQLCE40: var sqlCeProvider = new SqlCeDesignTimeServices(); sqlCeProvider.ConfigureDesignTimeServices(serviceCollection); break; case DatabaseType.SQLServer: var provider = new SqlServerDesignTimeServices(); provider.ConfigureDesignTimeServices(serviceCollection); var spatial = new SqlServerNetTopologySuiteDesignTimeServices(); spatial.ConfigureDesignTimeServices(serviceCollection); if (!string.IsNullOrEmpty(reverseEngineerOptions.Dacpac)) { serviceCollection.AddSingleton <IDatabaseModelFactory, SqlServerDacpacDatabaseModelFactory>(); } break; case DatabaseType.Npgsql: var npgsqlProvider = new NpgsqlDesignTimeServices(); npgsqlProvider.ConfigureDesignTimeServices(serviceCollection); break; case DatabaseType.Mysql: var mysqlProvider = new MySqlDesignTimeServices(); mysqlProvider.ConfigureDesignTimeServices(serviceCollection); break; case DatabaseType.SQLite: var sqliteProvider = new SqliteDesignTimeServices(); sqliteProvider.ConfigureDesignTimeServices(serviceCollection); break; default: throw new ArgumentOutOfRangeException(); } var serviceProvider = serviceCollection.BuildServiceProvider(); var scaffolder = serviceProvider.GetService <IReverseEngineerScaffolder>(); var schemas = new List <string>(); if (reverseEngineerOptions.DefaultDacpacSchema != null) { schemas.Add(reverseEngineerOptions.DefaultDacpacSchema); } var @namespace = reverseEngineerOptions.ProjectRootNamespace; if (!string.IsNullOrEmpty(reverseEngineerOptions.OutputPath)) { @namespace += "." + reverseEngineerOptions.OutputPath.Replace(Path.DirectorySeparatorChar, '.').Replace(Path.AltDirectorySeparatorChar, '.'); } var modelOptions = new ModelReverseEngineerOptions { UseDatabaseNames = reverseEngineerOptions.UseDatabaseNames }; var codeOptions = new ModelCodeGenerationOptions { UseDataAnnotations = !reverseEngineerOptions.UseFluentApiOnly }; var scaffoldedModel = scaffolder.ScaffoldModel( reverseEngineerOptions.Dacpac != null ? reverseEngineerOptions.Dacpac : reverseEngineerOptions.ConnectionString, reverseEngineerOptions.Tables.Select(m => m.Name).ToArray(), schemas, @namespace, "C#", null, reverseEngineerOptions.ContextClassName, modelOptions, codeOptions); var filePaths = scaffolder.Save( scaffoldedModel, Path.Combine(reverseEngineerOptions.ProjectPath, reverseEngineerOptions.OutputPath ?? string.Empty), overwriteFiles: true); PostProcessContext(filePaths.ContextFile, reverseEngineerOptions); foreach (var file in filePaths.AdditionalFiles) { PostProcess(file, reverseEngineerOptions.IdReplace); } PostProcess(filePaths.ContextFile, reverseEngineerOptions.IdReplace); var result = new EfCoreReverseEngineerResult { EntityErrors = errors, EntityWarnings = warnings, EntityTypeFilePaths = filePaths.AdditionalFiles, ContextFilePath = filePaths.ContextFile, }; return(result); }
public static ServiceProvider Build(ReverseEngineerCommandOptions options) { // Add base services for scaffolding var serviceCollection = new ServiceCollection(); serviceCollection .AddEntityFrameworkDesignTimeServices() #if CORE50 .AddSingleton <ICSharpEntityTypeGenerator>(provider => new CommentCSharpEntityTypeGenerator( provider.GetService <IAnnotationCodeGenerator>(), provider.GetService <ICSharpHelper>(), options.UseNullableReferences, options.UseNoConstructor)) #else .AddSingleton <ICSharpEntityTypeGenerator>(provider => new CommentCSharpEntityTypeGenerator( provider.GetService <ICSharpHelper>(), options.UseNullableReferences, options.UseNoConstructor)) #endif .AddSingleton <IOperationReporter, OperationReporter>() .AddSingleton <IOperationReportHandler, OperationReportHandler>() .AddSingleton <IScaffoldingModelFactory>(provider => new ColumnRemovingScaffoldingModelFactory( provider.GetService <IOperationReporter>(), provider.GetService <ICandidateNamingService>(), provider.GetService <IPluralizer>(), provider.GetService <ICSharpUtilities>(), provider.GetService <IScaffoldingTypeMapper>(), provider.GetService <LoggingDefinitions>(), options.Tables, options.DatabaseType )); if (options.CustomReplacers != null) { serviceCollection.AddSingleton <ICandidateNamingService>(provider => new ReplacingCandidateNamingService(options.CustomReplacers)); } if (options.UseHandleBars) { serviceCollection.AddHandlebarsScaffolding(hbOptions => { hbOptions.ReverseEngineerOptions = ReverseEngineerOptions.DbContextAndEntities; hbOptions.LanguageOptions = (LanguageOptions)options.SelectedHandlebarsLanguage; }); serviceCollection.AddSingleton <ITemplateFileService>(provider => new CustomTemplateFileService(options.ProjectPath)); } if (options.UseInflector || options.UseLegacyPluralizer) { if (options.UseLegacyPluralizer) { serviceCollection.AddSingleton <IPluralizer, LegacyPluralizer>(); } #if CORE50 #else else { serviceCollection.AddSingleton <IPluralizer, HumanizerPluralizer>(); } #endif } // Add database provider services switch (options.DatabaseType) { case DatabaseType.SQLServer: var provider = new SqlServerDesignTimeServices(); provider.ConfigureDesignTimeServices(serviceCollection); serviceCollection.AddSqlServerStoredProcedureDesignTimeServices(); if (options.UseSpatial) { var spatial = new SqlServerNetTopologySuiteDesignTimeServices(); spatial.ConfigureDesignTimeServices(serviceCollection); } var builder = new SqlConnectionStringBuilder(options.ConnectionString) { CommandTimeout = 300 }; options.ConnectionString = builder.ConnectionString; break; case DatabaseType.SQLServerDacpac: var dacProvider = new SqlServerDesignTimeServices(); dacProvider.ConfigureDesignTimeServices(serviceCollection); serviceCollection.AddSingleton <IDatabaseModelFactory, SqlServerDacpacDatabaseModelFactory>(); serviceCollection.AddSqlServerDacpacStoredProcedureDesignTimeServices(); if (options.UseSpatial) { var spatial = new SqlServerNetTopologySuiteDesignTimeServices(); spatial.ConfigureDesignTimeServices(serviceCollection); } break; case DatabaseType.Npgsql: var npgsqlProvider = new NpgsqlDesignTimeServices(); npgsqlProvider.ConfigureDesignTimeServices(serviceCollection); if (options.UseNodaTime) { var nodaTime = new NpgsqlNodaTimeDesignTimeServices(); nodaTime.ConfigureDesignTimeServices(serviceCollection); } if (options.UseSpatial) { var spatial = new NpgsqlNetTopologySuiteDesignTimeServices(); spatial.ConfigureDesignTimeServices(serviceCollection); } break; case DatabaseType.Mysql: var mysqlProvider = new MySqlDesignTimeServices(); mysqlProvider.ConfigureDesignTimeServices(serviceCollection); if (options.UseSpatial) { var spatial = new MySqlNetTopologySuiteDesignTimeServices(); spatial.ConfigureDesignTimeServices(serviceCollection); } break; #if CORE50 #else case DatabaseType.Oracle: var oracleProvider = new OracleDesignTimeServices(); oracleProvider.ConfigureDesignTimeServices(serviceCollection); break; #endif case DatabaseType.SQLite: var sqliteProvider = new SqliteDesignTimeServices(); sqliteProvider.ConfigureDesignTimeServices(serviceCollection); break; default: throw new ArgumentOutOfRangeException(); } return(serviceCollection.BuildServiceProvider()); }
public static ServiceProvider Build(ReverseEngineerCommandOptions options) { // Add base services for scaffolding var serviceCollection = new ServiceCollection(); serviceCollection .AddEntityFrameworkDesignTimeServices() .AddSingleton <ICSharpEntityTypeGenerator, CommentCSharpEntityTypeGenerator>() .AddSingleton <IOperationReporter, OperationReporter>() .AddSingleton <IOperationReportHandler, OperationReportHandler>(); if (options.CustomReplacers != null) { serviceCollection.AddSingleton <ICandidateNamingService>(provider => new ReplacingCandidateNamingService(options.CustomReplacers)); } if (options.UseHandleBars) { //TODO Consider being selective based on SelectedToBeGenerated var selected = ReverseEngineerOptions.DbContextAndEntities; var language = (LanguageOptions)options.SelectedHandlebarsLanguage; serviceCollection.AddHandlebarsScaffolding(selected, language); serviceCollection.AddSingleton <ITemplateFileService>(provider => new CustomTemplateFileService(options.ProjectPath)); } if (options.UseLegacyPluralizer) { serviceCollection.AddSingleton <IPluralizer, LegacyPluralizer>(); } // Add database provider services switch (options.DatabaseType) { case DatabaseType.SQLServer: var provider = new SqlServerDesignTimeServices(); provider.ConfigureDesignTimeServices(serviceCollection); if (!string.IsNullOrEmpty(options.Dacpac)) { serviceCollection.AddSingleton <IDatabaseModelFactory, SqlServerDacpacDatabaseModelFactory>(); } else { serviceCollection.AddSingleton <IDatabaseModelFactory, SqlServerFasterDatabaseModelFactory>(); } if (options.UseSpatial) { var spatial = new SqlServerNetTopologySuiteDesignTimeServices(); spatial.ConfigureDesignTimeServices(serviceCollection); } if (string.IsNullOrEmpty(options.Dacpac)) { serviceCollection.AddSqlServerStoredProcedureDesignTimeServices(); } break; case DatabaseType.Npgsql: var npgsqlProvider = new NpgsqlDesignTimeServices(); npgsqlProvider.ConfigureDesignTimeServices(serviceCollection); if (options.UseNodaTime) { var nodaTime = new NpgsqlNodaTimeDesignTimeServices(); nodaTime.ConfigureDesignTimeServices(serviceCollection); } if (options.UseSpatial) { var spatial = new NpgsqlNetTopologySuiteDesignTimeServices(); spatial.ConfigureDesignTimeServices(serviceCollection); } break; case DatabaseType.SQLite: var sqliteProvider = new SqliteDesignTimeServices(); sqliteProvider.ConfigureDesignTimeServices(serviceCollection); break; default: throw new ArgumentOutOfRangeException(); } return(serviceCollection.BuildServiceProvider()); }
public EfCoreReverseEngineerResult GenerateFiles(ReverseEngineerOptions reverseEngineerOptions) { var errors = new List <string>(); var warnings = new List <string>(); var reporter = new OperationReporter( new OperationReportHandler( m => errors.Add(m), m => warnings.Add(m))); // Add base services for scaffolding var serviceCollection = new ServiceCollection(); serviceCollection .AddEntityFrameworkDesignTimeServices() .AddSingleton <IOperationReporter, OperationReporter>() .AddSingleton <IOperationReportHandler, OperationReportHandler>(); //TODO await update to 2.1 //if (reverseEngineerOptions.UseHandleBars) //{ // serviceCollection.AddHandlebarsScaffolding(reverseEngineerOptions.ProjectPath); //} if (reverseEngineerOptions.UseInflector) { serviceCollection.AddSingleton <IPluralizer, InflectorPluralizer>(); } // Add database provider services switch (reverseEngineerOptions.DatabaseType) { case DatabaseType.SQLCE35: throw new NotImplementedException(); case DatabaseType.SQLCE40: var sqlCeProvider = new SqlCeDesignTimeServices(); sqlCeProvider.ConfigureDesignTimeServices(serviceCollection); break; case DatabaseType.Npgsql: var npgsqlProvider = new NpgsqlDesignTimeServices(); npgsqlProvider.ConfigureDesignTimeServices(serviceCollection); break; case DatabaseType.SQLServer: var provider = new SqlServerDesignTimeServices(); provider.ConfigureDesignTimeServices(serviceCollection); if (!string.IsNullOrEmpty(reverseEngineerOptions.Dacpac)) { serviceCollection.AddSingleton <IDatabaseModelFactory, SqlServerDacpacDatabaseModelFactory>(); } break; case DatabaseType.SQLite: var sqliteProvider = new SqliteDesignTimeServices(); sqliteProvider.ConfigureDesignTimeServices(serviceCollection); serviceCollection.AddSingleton <IDatabaseModelFactory, CustomSqliteDatabaseModelFactory>(); break; default: throw new ArgumentOutOfRangeException(); } var serviceProvider = serviceCollection.BuildServiceProvider(); var scaffolder = serviceProvider.GetService <IReverseEngineerScaffolder>(); var schemas = new List <string>(); if (reverseEngineerOptions.DefaultDacpacSchema != null) { schemas.Add(reverseEngineerOptions.DefaultDacpacSchema); } var @namespace = reverseEngineerOptions.ProjectRootNamespace; var subNamespace = SubnamespaceFromOutputPath(reverseEngineerOptions.ProjectPath, reverseEngineerOptions.OutputPath); if (!string.IsNullOrEmpty(subNamespace)) { @namespace += "." + subNamespace; } var scaffoldedModel = scaffolder.ScaffoldModel( reverseEngineerOptions.Dacpac != null ? reverseEngineerOptions.Dacpac : reverseEngineerOptions.ConnectionString, reverseEngineerOptions.Tables, schemas, @namespace, "C#", null, reverseEngineerOptions.ContextClassName, !reverseEngineerOptions.UseFluentApiOnly, useDatabaseNames: reverseEngineerOptions.UseDatabaseNames); var filePaths = scaffolder.Save( scaffoldedModel, Path.Combine(reverseEngineerOptions.ProjectPath, reverseEngineerOptions.OutputPath), overwriteFiles: true); foreach (var file in filePaths.AdditionalFiles) { PostProcess(file, reverseEngineerOptions.IdReplace); } PostProcess(filePaths.ContextFile, reverseEngineerOptions.IdReplace); PostProcessContext(filePaths.ContextFile, reverseEngineerOptions); var result = new EfCoreReverseEngineerResult { EntityErrors = errors, EntityWarnings = warnings, EntityTypeFilePaths = filePaths.AdditionalFiles, ContextFilePath = filePaths.ContextFile, }; return(result); }
public EfCoreReverseEngineerResult GenerateFiles(ReverseEngineerOptions reverseEngineerOptions) { var errors = new List <string>(); var warnings = new List <string>(); var reporter = new OperationReporter( new OperationReportHandler( m => errors.Add(m), m => warnings.Add(m))); // Add base services for scaffolding var serviceCollection = new ServiceCollection(); serviceCollection .AddScaffolding(reporter) .AddSingleton <IOperationReporter, OperationReporter>() .AddSingleton <IOperationReportHandler, OperationReportHandler>(); if (reverseEngineerOptions.UseHandleBars) { serviceCollection.AddHandlebarsScaffolding(reverseEngineerOptions.ProjectPath); } if (reverseEngineerOptions.UseInflector) { serviceCollection.AddSingleton <IPluralizer, InflectorPluralizer>(); } // Add database provider services switch (reverseEngineerOptions.DatabaseType) { case DatabaseType.SQLCE35: throw new NotImplementedException(); case DatabaseType.SQLCE40: var sqlCeProvider = new SqlCeDesignTimeServices(); sqlCeProvider.ConfigureDesignTimeServices(serviceCollection); break; case DatabaseType.SQLServer: var provider = new SqlServerDesignTimeServices(); provider.ConfigureDesignTimeServices(serviceCollection); break; case DatabaseType.SQLite: var sqliteProvider = new SqliteDesignTimeServices(); sqliteProvider.ConfigureDesignTimeServices(serviceCollection); serviceCollection.AddSingleton <IDatabaseModelFactory, CustomSqliteDatabaseModelFactory>(); break; default: throw new ArgumentOutOfRangeException(); } var serviceProvider = serviceCollection.BuildServiceProvider(); var generator = serviceProvider.GetService <IModelScaffolder>(); var filePaths = generator.Generate( reverseEngineerOptions.ConnectionString, reverseEngineerOptions.Tables, new List <string>(), reverseEngineerOptions.ProjectPath, reverseEngineerOptions.OutputPath, reverseEngineerOptions.ProjectRootNamespace, reverseEngineerOptions.ContextClassName, !reverseEngineerOptions.UseFluentApiOnly, overwriteFiles: true, useDatabaseNames: reverseEngineerOptions.UseDatabaseNames); // Explanation: Use table and column names directly from the database. foreach (var file in filePaths.EntityTypeFiles) { PostProcess(file, reverseEngineerOptions.IdReplace); } PostProcess(filePaths.ContextFile, reverseEngineerOptions.IdReplace); if (!reverseEngineerOptions.IncludeConnectionString) { PostProcessContext(filePaths.ContextFile); } var result = new EfCoreReverseEngineerResult { EntityErrors = errors, EntityWarnings = warnings, EntityTypeFilePaths = filePaths.EntityTypeFiles, ContextFilePath = filePaths.ContextFile, }; return(result); }
public static ServiceProvider Build(ReverseEngineerCommandOptions options) { // Add base services for scaffolding var serviceCollection = new ServiceCollection(); serviceCollection .AddEntityFrameworkDesignTimeServices() .AddSingleton <ICSharpEntityTypeGenerator, CommentCSharpEntityTypeGenerator>() .AddSingleton <IOperationReporter, OperationReporter>() .AddSingleton <IOperationReportHandler, OperationReportHandler>(); if (options.CustomReplacers != null) { serviceCollection.AddSingleton <ICandidateNamingService>(provider => new ReplacingCandidateNamingService(options.CustomReplacers)); } if (options.UseInflector) { if (options.UseLegacyPluralizer) { serviceCollection.AddSingleton <IPluralizer, LegacyPluralizer>(); } else { serviceCollection.AddSingleton <IPluralizer, HumanizerPluralizer>(); } } // Add database provider services switch (options.DatabaseType) { case DatabaseType.SQLServer: var provider = new SqlServerDesignTimeServices(); provider.ConfigureDesignTimeServices(serviceCollection); if (!string.IsNullOrEmpty(options.Dacpac)) { serviceCollection.AddSingleton <IDatabaseModelFactory, SqlServerDacpacDatabaseModelFactory>(); } else { serviceCollection.AddSingleton <IDatabaseModelFactory, SqlServerFasterDatabaseModelFactory>(); } if (options.UseSpatial) { var spatial = new SqlServerNetTopologySuiteDesignTimeServices(); spatial.ConfigureDesignTimeServices(serviceCollection); } if (string.IsNullOrEmpty(options.Dacpac) && options.UseStoredProcedures) { serviceCollection.AddSqlServerStoredProcedureDesignTimeServices(); } break; case DatabaseType.Npgsql: var npgsqlProvider = new NpgsqlDesignTimeServices(); npgsqlProvider.ConfigureDesignTimeServices(serviceCollection); if (options.UseNodaTime) { var nodaTime = new NpgsqlNodaTimeDesignTimeServices(); nodaTime.ConfigureDesignTimeServices(serviceCollection); } if (options.UseSpatial) { var spatial = new NpgsqlNetTopologySuiteDesignTimeServices(); spatial.ConfigureDesignTimeServices(serviceCollection); } break; case DatabaseType.SQLite: var sqliteProvider = new SqliteDesignTimeServices(); sqliteProvider.ConfigureDesignTimeServices(serviceCollection); break; default: throw new ArgumentOutOfRangeException(); } return(serviceCollection.BuildServiceProvider()); }
public static ServiceProvider Build(ReverseEngineerOptions options) { // Add base services for scaffolding var serviceCollection = new ServiceCollection(); serviceCollection .AddEntityFrameworkDesignTimeServices() .AddSingleton <IOperationReporter, OperationReporter>() .AddSingleton <IOperationReportHandler, OperationReportHandler>(); if (options.UseHandleBars) { //TODO Consider being selective based on SelectedToBeGenerated var selected = Microsoft.EntityFrameworkCore.Design.ReverseEngineerOptions.DbContextAndEntities; var language = (LanguageOptions)options.SelectedHandlebarsLanguage; serviceCollection.AddHandlebarsScaffolding(selected, language); serviceCollection.AddSingleton <ITemplateFileService>(provider => new CustomTemplateFileService(options.ProjectPath)); } if (options.CustomReplacers != null) { serviceCollection.AddSingleton <ICandidateNamingService>(provider => new ReplacingCandidateNamingService(options.CustomReplacers)); } if (options.UseInflector) { if (options.UseLegacyPluralizer) { serviceCollection.AddSingleton <IPluralizer, LegacyInflectorPluralizer>(); } else { serviceCollection.AddSingleton <IPluralizer, InflectorPluralizer>(); } } // Add database provider services switch (options.DatabaseType) { case DatabaseType.SQLCE35: throw new NotImplementedException(); case DatabaseType.SQLCE40: var sqlCeProvider = new SqlCeDesignTimeServices(); sqlCeProvider.ConfigureDesignTimeServices(serviceCollection); break; case DatabaseType.SQLServer: var provider = new SqlServerDesignTimeServices(); provider.ConfigureDesignTimeServices(serviceCollection); if (!string.IsNullOrEmpty(options.Dacpac)) { serviceCollection.AddSingleton <IDatabaseModelFactory, SqlServerDacpacDatabaseModelFactory>(); } break; case DatabaseType.Npgsql: var npgsqlProvider = new NpgsqlDesignTimeServices(); npgsqlProvider.ConfigureDesignTimeServices(serviceCollection); break; case DatabaseType.Mysql: var mysqlProvider = new MySqlDesignTimeServices(); mysqlProvider.ConfigureDesignTimeServices(serviceCollection); break; case DatabaseType.SQLite: var sqliteProvider = new SqliteDesignTimeServices(); sqliteProvider.ConfigureDesignTimeServices(serviceCollection); break; default: throw new ArgumentOutOfRangeException(); } return(serviceCollection.BuildServiceProvider()); }
public EfCoreReverseEngineerResult GenerateFiles(ReverseEngineerOptions reverseEngineerOptions) { // Add base services for scaffolding var serviceCollection = new ServiceCollection() .AddScaffolding() .AddLogging(); // Add database provider services switch (reverseEngineerOptions.DatabaseType) { case DatabaseType.SQLCE35: throw new NotImplementedException(); case DatabaseType.SQLCE40: var sqlCeProvider = new SqlCeDesignTimeServices(); sqlCeProvider.ConfigureDesignTimeServices(serviceCollection); break; case DatabaseType.SQLServer: var provider = new SqlServerDesignTimeServices(); provider.ConfigureDesignTimeServices(serviceCollection); break; case DatabaseType.SQLite: var sqliteProvider = new SqliteDesignTimeServices(); sqliteProvider.ConfigureDesignTimeServices(serviceCollection); break; default: throw new ArgumentOutOfRangeException(); } var serviceProvider = serviceCollection.BuildServiceProvider(); var generator = serviceProvider.GetService <ReverseEngineeringGenerator>(); var tableSelectionSet = reverseEngineerOptions.Tables.Count == 0 ? TableSelectionSet.All : new TableSelectionSet(reverseEngineerOptions.Tables); var options = new ReverseEngineeringConfiguration { ConnectionString = reverseEngineerOptions.ConnectionString, ProjectPath = reverseEngineerOptions.ProjectPath, OutputPath = reverseEngineerOptions.OutputPath, ProjectRootNamespace = reverseEngineerOptions.ProjectRootNamespace, OverwriteFiles = true, UseFluentApiOnly = reverseEngineerOptions.UseFluentApiOnly, ContextClassName = reverseEngineerOptions.ContextClassName, TableSelectionSet = tableSelectionSet }; var model = generator.GetMetadataModel(options); var filePaths = generator.GenerateAsync(options).GetAwaiter().GetResult(); var errors = model.Scaffolding().EntityTypeErrors; var result = new EfCoreReverseEngineerResult { EntityErrors = errors, FilePaths = filePaths.EntityTypeFiles, }; result.FilePaths.Add(filePaths.ContextFile); return(result); }