How to run Firebird embedded database with ASP.NET 5?

1.4k Views Asked by At

I am trying to run firebird embedded database from my MVC 6 application. I am using Fluent Nhibernate. The configuration is shown below:

var firebird = new FirebirdConfiguration();

var cs = @"User=SYSDBA;Password=masterkey;Database=SampleDatabase.fdb;DataSource=localhost;
Port = 3050; Dialect = 3; Charset = NONE; Role =; Connection lifetime = 15; Pooling = true;
            MinPoolSize = 0; MaxPoolSize = 50; Packet Size = 8192; ServerType = 1; ";

SessionFactory = Fluently.Configure()
                .Mappings(m => m.FluentMappings.AddFromAssembly(Assembly.GetExecutingAssembly()))
                .Database(firebird.ConnectionString(cs)).BuildConfiguration()
                .BuildSessionFactory();

I have also installed the nuget package FirebirdSql.Data.FirebirdClient

However I am getting the error:

Unable to load DLL 'fbembed': The specified module could not be found.

I am trying to include this dll in my reference but then I am getting the build error saying this reference cannot be restored.

enter image description here

enter image description here

What do I need to do to get this running ?

P.S: I have also failed to use SQLite due to a similar situation/error.

1

There are 1 best solutions below

0
On

You might need to add fbembed.dll to the bin folder in your asp.net application also the icu* files (from Embedded Firebird ZIP package) into the bin folder.