how to solve this problem could not load file or assembly system.data.Sqlite

Question

0.00/5 (No votes)

See more:

i created c#.net windows applications in vs 2013, when i build the solutions it will runs good but when i try to deploy this applications to other machine it gives the error
could not load file or assembly system.data.Sqlite

System.IO.FileNotFoundException: Could not load file or assembly 'System.Data.SQLite, Version=1.0.94.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139' or one of its dependencies. The system cannot find the file specified.
File name: 'System.Data.SQLite, Version=1.0.94.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139'

Posted 6-Jan-15 2:11am

Srikanth59

Add a Solution

Comments

Arjsrya 6-Jan-15 7:16am

Did you check the framework version on both ends?Did you check whether the dll is present on the deployed area?

Praveen Kumar Upadhyay 6-Jan-15 8:19am

If it is a Console or Windows Application, then you need to copy the sqlite dll to the targeted exe.

Srikanth59 8-Jan-15 0:40am

it is windows application every time i need to copy the sqlite dll to the targeted exe, can you tell me how should i solve this problem

Praveen Kumar Upadhyay 8-Jan-15 1:17am

As per my best of knowledge,
It is a separate dll than your project you are creating. You have to understand that you can not code it. You have to have keep it with your project. One thing you can do, create installer(setup) and add this dll to that installer.

Srikanth59 8-Jan-15 3:40am

okay if i create installer and add sqlite.dll to other installer , it will work on the other system

Praveen Kumar Upadhyay 8-Jan-15 4:54am

Yes.

2 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Richard MacCutchan · Answer 1 · 2015-01-06T02:21:00

Solution 1

SQLite is not part of .NET, it is obtained from http://system.data.sqlite.org/index.html/doc/trunk/www/index.wiki[^]. You will need to add it to your deployment to install it on every system that uses your application.

Posted 6-Jan-15 2:21am

Richard MacCutchan

mexrod · Answer 2 · 2015-04-16T12:38:00

Solution 2

the real solution is here :
https://social.msdn.microsoft.com/Forums/vstudio/en-US/689cae98-192f-4cda-b5b8-430f4c0fc9a9/error-in-sqlite?forum=visualstudiogeneral[^]

Posted 16-Apr-15 12:38pm

mexrod

how to solve this problem could not load file or assembly system.data.Sqlite

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

how to solve this problem could not load file or assembly system.data.Sqlite

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us