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