I'm trying to add migrations to a project that uses Fluent NHibernate to call the database. The problem is that I wanted to do it in a Entity Framework style, adding the migrations, or aplying them, from the Package Manager Console.
For that, I used FluentMigrator, and FluentMigrator.NHibernate, and after porting the second one to .Net Standard, and checked that all was going well, I started to work on the Powershell script that would launch the "Add-Migration" from the package manager console.
The problem is that, when the program tries to build a NHibernate configuration, it throws a TypeInitializationException for NHibernate.NHibernateLogger. And the InnerException says:
System.TypeInitializationException: The type initializer for 'NHibernate.Cfg.Environment' threw an exception.
---> System.TypeInitializationException: The type initializer for 'NHibernate.NHibernateLogger' threw an exception.
---> System.Configuration.ConfigurationErrorsException: Configuration system failed to initialize
---> System.PlatformNotSupportedException: Operation is not supported on this platform.
at System.Configuration.ClientConfigPaths..ctor(String exePath, Boolean includeUserConfig)
at System.Configuration.ClientConfigPaths.GetPaths(String exePath, Boolean includeUserConfig)
at System.Configuration.ClientConfigurationHost.get_ConfigPaths()
at System.Configuration.ClientConfigurationHost.GetStreamName(String configPath)
at System.Configuration.ClientConfigurationHost.get_IsAppConfigHttp()
at System.Configuration.Internal.DelegatingConfigHost.get_IsAppConfigHttp()
at System.Configuration.ClientConfigurationSystem..ctor()
at System.Configuration.ConfigurationManager.EnsureConfigurationSystem()
--- End of inner exception stack trace ---
at System.Configuration.ConfigurationManager.EnsureConfigurationSystem()
at System.Configuration.ConfigurationManager.PrepareConfigSystem()
at System.Configuration.ConfigurationManager.GetSection(String sectionName)
at System.Configuration.ConfigurationManager.get_AppSettings()
at NHibernate.NHibernateLogger.GetNhibernateLoggerClass()
at NHibernate.NHibernateLogger..cctor()
--- End of inner exception stack trace ---
at NHibernate.NHibernateLogger.For(Type type)
at NHibernate.Cfg.Environment..cctor()
--- End of inner exception stack trace ---
at NHibernate.Cfg.Configuration.Reset()
at NHibernate.Cfg.Configuration..ctor(SettingsFactory settingsFactory)
at NHibernate.Cfg.Configuration..ctor()
at JobsEngine.Migrations.BaseConfig.MigrationsConfiguration.GetConfiguration()
This is caused when creating a configuration using NHibernate, like this:
protected override Configuration GetConfiguration()
{
Configuration config = new Configuration(); //this is what throws the exception
config = Fluently.Configure()
.Database(MsSqlConfiguration.MsSql2012.Dialect<MsSql2012Dialect>())
.Mappings(x => x.FluentMappings.AddFromAssembly(MigrationAssembly))
.BuildConfiguration();
return config;
}
And looking for information for that "Operation is not supported in this platform" exception, it seems that what throws it is this portion of code:
exeAssembly = Assembly.GetEntryAssembly();
if (exeAssembly == null)
throw new PlatformNotSupportedException();
I understand that it doesn't work because I launch it from a Powershell script, getting the assembly and so, so there is not an "entry assembly"(GetEntryAssembly returns null). If I launch from a console project, or a unit test, it works perfect. Is there a workaround or a solution to this? I would like to keep having the ability of launching it from the powershell script.
I have to say that all libraries referenced here are using(or should be using) .Net standard.
EDIT: Relevant part of the powershell script used to launch this:
$migration = [FluentMigrator.NHibernate.PSEntryPoint]::Generate($targetPath, $MigrationName)
Where $MigrationName is a string, and targetPath is the path of the assembly that has the migrations, after it has been built using EnvDTE:
$configuration = $DTE.Solution.SolutionBuild.ActiveConfiguration.Name
$DTE.Solution.SolutionBuild.BuildProject($configuration, $project.UniqueName, $true)
Where PSEntryPoint:
public static class PSEntryPoint
{
public static object Generate(string targetPath, string migrationName)
{
MigrationConfigurationBase migrationConfiguration = GetMigrationConfigFromAssembly(targetPath);
return migrationConfiguration.Generate(migrationName, targetPath);
}
private static MigrationConfigurationBase GetMigrationConfigFromAssembly(string assemblyName)
{
var assembly = Assembly.LoadFrom(assemblyName);
var migrationConfigTypes = assembly.GetTypes().Where(x => x != null && x.IsClass && !x.IsAbstract
&& typeof(MigrationConfigurationBase).IsAssignableFrom(x)).ToList();
var migrationConfig = Activator.CreateInstance(migrationConfigTypes.First()) as MigrationConfigurationBase;
return migrationConfig;
}
This in general works, it creates an instance of the migrationconfiguration, it starts the "Generate", but when it gets to the new Configuration from NHibernate, it throws the Platform not supported.