Deploy Application at the customer

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for SQLite
Post Reply
caipigott
Posts: 5
Joined: Fri 10 Apr 2015 08:52

Deploy Application at the customer

Post by caipigott » Fri 10 Apr 2015 09:00

Hello,

we are now switching our Project from MSSQL to SQLite using the Entity Framework 6. Therefor we choose to use your dotConnect for SQLite.
So far we are using the Trial Version and our application is running without any Problems. We added a license file as described to the Project, but when we copy our Release to the customers Computer we get the following exception:

"Unable to find the requested .Net Framework Data Provider. It may not be installed"

After installing your Software on the customers pc, the application launched and worked.
My question is now, is it possible to make the application run without installing any additional sotftware than ours?

Many thanks in advanced,
Caipigott

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: Deploy Application at the customer

Post by Shalex » Mon 13 Apr 2015 12:15

caipigott wrote:"Unable to find the requested .Net Framework Data Provider. It may not be installed"
You should register configuration information in the DbProviderFactories section of the *.config file to inform your environment about the existence of the provider factory. The provider factory is described either in machine.config (globally), in app.config or in web.config (just for your application):

Code: Select all

<system.data>
  <DbProviderFactories>
    <remove invariant="Devart.Data.SQLite" />
    <add name="dotConnect for SQLite" invariant="Devart.Data.SQLite" description="Devart dotConnect for SQLite" type="Devart.Data.SQLite.SQLiteProviderFactory, Devart.Data.SQLite, Version=5.2.389.0, Culture=neutral, PublicKeyToken=09af7300eec23701" />
  </DbProviderFactories>
</system.data>
Replace 5.2.389.0 here with your actual version.
For more information, refer to http://www.devart.com/dotconnect/sqlite ... yment.html.
caipigott wrote:After installing your Software on the customers pc, the application launched and worked.
The provider installation puts the DbProviderFactories entry in machine.config.
caipigott wrote:we are now switching our Project from MSSQL to SQLite using the Entity Framework 6.
Please note that the revision number of provider in the entityFramework section is *.6 (5.2.389.6) but it should be *.0 (5.2.389.0) in DbProviderFactories.

caipigott
Posts: 5
Joined: Fri 10 Apr 2015 08:52

Re: Deploy Application at the customer

Post by caipigott » Mon 13 Apr 2015 14:00

Hello,

thanks a lot for your help! After adding these lines to our config.ini it worked on the customer pc without installing the software.

Best greetings,
Caipigott

Post Reply