I have 2 projects (in question)
DataAccessLayer
Tests
I am using Fluent nHibernate, and setting up a SQLite database.
I have referenced System.Data.SQLite in DataAccessLayer project (with CopyLocal = true) but when I run the configuration in the Tests project, nHibernate cannot find the SQLite provider assembly.
Now I have added the SQLite reference to Tests project and it runs without a problem.
But I would like to leave the assembly reference in my DataAccessLayer project, as that is where there the data access layer (what database to use) is.
Why does my Tests project not see the SQLite assembly reference from the DataAccessLayer project?
DataAccessLayer is referenced in Tests project.
Edit - Connection String in app.config
<connectionStrings>
<add name="SQLiteLocal" connectionString="Data Source=SQLite.db;" providerName="System.Data.SQLite" />
</connectionStrings>
Edit - Exception
----> NHibernate.HibernateException : Could not create the driver from
NHibernate.Driver.SQLite20Driver, NHibernate, Version=3.3.1.4000,
Culture=neutral, PublicKeyToken=aa95f207798dfdb4.
----> System.Reflection.TargetInvocationException : Exception has been thrown
by the target of an invocation.
----> System.ArgumentException : Unable to find the requested .Net Framework
Data Provider. It may not be installed.