Xamarin .NET Standard 2.0.3 ConfigurationManager throws PlatformNotSupported exception in NHibernateLogger

[CSmith1111]

i have a xamarin .net standard 2.0.3 project and try to use nhibernate with sqlite but get the error "System.PlatformNotSupportedException"

The error comes within this code from a .net standard 2.0.3 project:

    var cfg = new Configuration().DataBaseIntegration(db =>
      {
        db.Driver<SQLite20Driver>();
        db.Dialect<SQLiteDialect>();
        db.ConnectionString = "Data Source=test.db;Version=3;New=True";
      });

With just a (xunit) testproject and the nhibernate project this code works fine, but not if i want to start this code within an andorid system.

[hazzik]

You'll need to write own driver for SQLite.

[CSmith1111]

So SQLite is supported for Windows, Linux, MacOS and other .NET Standard platforms but not for Xamarin?

[hazzik]

If we're talking about System.Data.SQLite (this is what SQLiteDriver uses) then it supports only Windows, MacOS and Linux. Other platforms are not supported. The SQLite ADO.NET provider which supports Xamarin Android is Mono.Data.Sqlite, which is not supported by NHibernate by default.

You can write own provider for it. Or use this one: https://stackoverflow.com/a/7645822/259946

[CSmith1111]

i tried it like you mention it, but the error got thrown even befor nhibernate wants to load the driver.
is there something special to make your linked code work? i also tried to change the nhibernate.cfg.xml but same problem.

      var cfg = new Configuration(); //here comes the error
      cfg.DataBaseIntegration(db =>
      {
        db.Driver<MonoSQLiteDriver>();
        db.Dialect<SQLiteDialect>();
        db.ConnectionString = "Data Source=test.db;Version=3;New=True";
      });

If i create a new dll with just the code from stackoverflow and add <add key="connection.driver_class" value="NHibernate.Driver.ReflectionBasedDriver, SQLDriver.dll" /> to my nhibernate.cfg.xml i get this error:

 NHibernate.HibernateException : Could not create the driver from SQLDriver.MonoSqLiteDriver, SQLDriver, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null.
---- System.Reflection.TargetInvocationException : Exception has been thrown by the target of an invocation.
-------- NHibernate.HibernateException : The DbCommand and DbConnection implementation in the assembly Mono.Data.Sqlite could not be found. Ensure that the assembly Mono.Data.Sqlite is located in the application directory or in the Global Assembly Cache. If the assembly is in the GAC, use <qualifyAssembly/> element in the application configuration file to specify the full name of the assembly.

is there any kind of tutorial for this or a fork?

also there comes this error for mono.data.sqlite if i want to use it with .net standard

Error	NU1202	Package Mono.Data.Sqlite 1.0.61 is not compatible with monoandroid90 (MonoAndroid,Version=v9.0). Package Mono.Data.Sqlite 1.0.61 supports: net40 (.NETFramework,Version=v4.0)

[bahusoid]

Try with Mono.Data.Sqlite.Portable

[CSmith1111]

Try with Mono.Data.Sqlite.Portable

gives me
System.DllNotFoundException : Unable to load DLL 'sqlite3' or one of its dependencies: cant find the module. (Exception from HRESULT: 0x8007007E)
and
Warning NU1701 Package 'Mono.Data.Sqlite.Portable 1.0.3.5' was restored using '.NETFramework,Version=v4.6.1' instead of the project target framework '.NETStandard,Version=v2.0'. This package may not be fully compatible with your project.

[hazzik]

You don't actualy need any packages. Mono.Data.Sqlite assembly is already part of Mono/Xamarin. You just need to add a reference to the project like this:

<Reference Include="Mono.Data.Sqlite" />

This needed to be included into the App project which targeds Xamarin, not netstandard2.0.

[CSmith1111]

NHibernateSQLiteTest.zip
This is my sample project, a basic cross-platform project with nhibernate and all of your hints.
I can't get it work.
Can you please take a look and say me whats the problem?

If i move the Ref to Mono.Data.SQLite from NHibernateSQLiteTest to NHibernateSQLiteTest.Android there is no diffrent

[hazzik]

Ok, this is the ConfigurationManager throws PlatformNotSupported exception (in NHibernateLogger)

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 (System.String exePath, System.Boolean includeUserConfig) [0x00050] in <0e721f564ffa49e6b1d97ad7b9fda1f2>:0 
  at System.Configuration.ClientConfigPaths.GetPaths (System.String exePath, System.Boolean includeUserConfig) [0x00018] in <0e721f564ffa49e6b1d97ad7b9fda1f2>:0 
  at System.Configuration.ClientConfigurationHost.get_ConfigPaths () [0x0000a] in <0e721f564ffa49e6b1d97ad7b9fda1f2>:0 
  at System.Configuration.ClientConfigurationHost.GetStreamName (System.String configPath) [0x0006d] in <0e721f564ffa49e6b1d97ad7b9fda1f2>:0 
  at System.Configuration.ClientConfigurationHost.get_IsAppConfigHttp () [0x00000] in <0e721f564ffa49e6b1d97ad7b9fda1f2>:0 
  at System.Configuration.Internal.DelegatingConfigHost.get_IsAppConfigHttp () [0x00006] in <0e721f564ffa49e6b1d97ad7b9fda1f2>:0 
  at System.Configuration.ClientConfigurationSystem..ctor () [0x00051] in <0e721f564ffa49e6b1d97ad7b9fda1f2>:0 
  at System.Configuration.ConfigurationManager.EnsureConfigurationSystem () [0x00024] in <0e721f564ffa49e6b1d97ad7b9fda1f2>:0 
   --- End of inner exception stack trace ---
  at System.Configuration.ConfigurationManager.EnsureConfigurationSystem () [0x00060] in <0e721f564ffa49e6b1d97ad7b9fda1f2>:0 
  at System.Configuration.ConfigurationManager.PrepareConfigSystem () [0x0000a] in <0e721f564ffa49e6b1d97ad7b9fda1f2>:0 
  at System.Configuration.ConfigurationManager.GetSection (System.String sectionName) [0x0000a] in <0e721f564ffa49e6b1d97ad7b9fda1f2>:0 
  at System.Configuration.ConfigurationManager.get_AppSettings () [0x00000] in <0e721f564ffa49e6b1d97ad7b9fda1f2>:0 
  at NHibernate.NHibernateLogger.GetNhibernateLoggerClass () [0x00000] in <6a21298c8bf24583b7926240093786b7>:0 
  at NHibernate.NHibernateLogger..cctor () [0x00000] in <6a21298c8bf24583b7926240093786b7>:0 
   --- End of inner exception stack trace ---
  at NHibernateSQLiteTest.NHibernateHelper.MakeCfg () [0x00001] in /Users/hazzik/Downloads/NHibernateSQLiteTest/NHibernateSQLiteTest/NHibernateSQLiteTest/NHibernateHelper.cs:22 
  at NHibernateSQLiteTest.NHibernateHelper.get_Configuration () [0x0000e] in /Users/hazzik/Downloads/NHibernateSQLiteTest/NHibernateSQLiteTest/NHibernateSQLiteTest/NHibernateHelper.cs:79 
  at NHibernateSQLiteTest.NHibernateHelper.get_SessionFactory () [0x0000e] in /Users/hazzik/Downloads/NHibernateSQLiteTest/NHibernateSQLiteTest/NHibernateSQLiteTest/NHibernateHelper.cs:65 
  at NHibernateSQLiteTest.NHibernateHelper.OpenSession () [0x00001] in /Users/hazzik/Downloads/NHibernateSQLiteTest/NHibernateSQLiteTest/NHibernateSQLiteTest/NHibernateHelper.cs:55 
  at NHibernateSQLiteTest.NHibernateSqLiteDummyRepository.Save (NHibernateSQLiteTest.SQLiteDummy SQLiteDummy) [0x00001] in /Users/hazzik/Downloads/NHibernateSQLiteTest/NHibernateSQLiteTest/NHibernateSQLiteTest/NHibernateSqLiteDummyRepository.cs:20 
  at NHibernateSQLiteTest.MainPage.OnClick (System.Object sender, System.EventArgs e) [0x00019] in /Users/hazzik/Downloads/NHibernateSQLiteTest/NHibernateSQLiteTest/NHibernateSQLiteTest/MainPage.xaml.cs:17 
  at Xamarin.Forms.Button.Xamarin.Forms.Internals.IButtonElement.PropagateUpClicked () [0x00000] in D:\\a\\1\\s\\Xamarin.Forms.Core\\Button.cs:166 
  at Xamarin.Forms.ButtonElement.ElementClicked (Xamarin.Forms.VisualElement visualElement, Xamarin.Forms.Internals.IButtonElement ButtonElementManager) [0x0001f] in D:\\a\\1\\s\\Xamarin.Forms.Core\\ButtonElement.cs:61 
  at Xamarin.Forms.Button.SendClicked () [0x00000] in D:\\a\\1\\s\\Xamarin.Forms.Core\\Button.cs:152 
  at Xamarin.Forms.Platform.Android.ButtonElementManager.OnClick (Xamarin.Forms.VisualElement element, Xamarin.Forms.IButtonController buttonController, Android.Views.View v) [0x00000] in D:\\a\\1\\s\\Xamarin.Forms.Platform.Android\\ButtonElementManager.cs:25 
  at Xamarin.Forms.Platform.Android.AppCompat.ButtonRenderer.Android.Views.View.IOnClickListener.OnClick (Android.Views.View v) [0x00000] in D:\\a\\1\\s\\Xamarin.Forms.Platform.Android\\AppCompat\\ButtonRenderer.cs:185 
  at Android.Views.View+IOnClickListenerInvoker.n_OnClick_Landroid_view_View_ (System.IntPtr jnienv, System.IntPtr native__this, System.IntPtr native_v) [0x00011] in <d9e99b55e96444569d54148253f9c212>:0 
  at (wrapper dynamic-method) Android.Runtime.DynamicMethodNameCounter.32(intptr,intptr,intptr)

[CSmith1111]

yes, that's the problem in this issue.
that's why i should change to mono, but as you can see, its not that easy.

any idea who i can make nhiberate to get working with mono in this kind of project?

[xp-development]

Is the ConfigurationManager not usable for Xamarin.Android?
Does that mean it's not possible to use NHibernate for Xamarin.Android?

[hazzik]

This is the root cause: https://github.com/dotnet/corefx/issues/18832

[bahusoid]

You can try to use the following binaries to make sure that ConfigurationManager is the only issue with Xamarin. See here how to install nuget local package.

And add somewhere before session factory is created:

NHibernate.Cfg.Settings.ConfigurationManager = null;

[CSmith1111]

@bahusoid , looks good to me.
We also changed the SQLite driver to Microsoft.Data.Sqlite.Core coz thats what EntityFrameworkCore is using. Maybe that would be a good default sqlite driver?

Testproject: NHibernateSQLiteTest.zip