ansaurus

Question

Could not load file or assembly 'System.Data.SQLite'

Answer 1

A:

Can you delete your bin debug folder and recompile again?

Or check your project reference to the System.Data.SQLite, track down where it is located, then open the dll in reflector. If you can't open it, that means that the dll is corrupted, you might want to find a correct one or reinstall the .net framework.

Ngu Soon Hui 2009-08-14 16:49:59

I've tried adding the reference to System.Data.SQLite directly (aside from removing bin and obj) and I've got this error: Error 1 Warning as Error: Assembly generation -- Referenced assembly 'System.Data.SQLite.dll' targets a different processor MyProject

J. Pablo Fernández 2009-08-15 13:07:54

Answer 2

+11 A:

System.Data.SQLite.dll is a mixed assembly, i.e. it contains both managed code and native code. Therefore a particular System.Data.SQLite.dll is either x86 or x64, but never both.

Update (courtesy J. Pablo Fernandez): Cassini, the development web server used by Visual Studio when you press F5 or click the green «play» button, is x86 only which means that even if your workstation is x64, you'll only be able to use the x86 version of System.Data.SQLite.dll.

An alternative is not to use Cassini but IIS7 which is properly x64.

Anton Tykhyy 2009-08-15 13:27:24

I am using the x64 version on a x64 computer.

J. Pablo Fernández 2009-08-15 13:37:31

Did you try using the x86 version?

Anton Tykhyy 2009-08-15 14:32:33

Answer 3

+11 A:

Make sure that "Enable 32 - Bit Applications" is set to false for the app pool.

beckelmw 2009-09-09 15:48:34

This works if you want to use the x86 dll on 64 bit machine. In our case, our dev and production environments don't match so this was what worked best.

Rob 2010-02-12 16:36:13

This did it for me, thanks.

Jirapong 2010-03-26 06:08:42

Answer 4

+2 A:

Hi Guys, I have a 64 bit dev machine and 32 bit build server. I used this code prior to NHibernate initialisation. Works a charm on any architecture (well the 2 I have tested)

Hope this helps someone.

Guido

        private static void LoadSQLLiteAssembly()
        {
            Uri dir = new Uri(Assembly.GetExecutingAssembly().CodeBase);
            FileInfo fi = new FileInfo(dir.AbsolutePath);           
            string binFile = fi.Directory.FullName + "\\System.Data.SQLite.DLL";
            if (!File.Exists(binFile)) File.Copy(GetAppropriateSQLLiteAssembly(), binFile, false);
        }

        private static string GetAppropriateSQLLiteAssembly()
        {
            string pa = Environment.GetEnvironmentVariable("PROCESSOR_ARCHITECTURE");
            string arch = ((String.IsNullOrEmpty(pa) || String.Compare(pa, 0, "x86", 0, 3, true) == 0) ? "32" : "64");
            return GetLibsDir() + "\\NUnit\\System.Data.SQLite.x" + arch + ".DLL";
        }

gatapia 2010-05-10 23:06:43

ansaurus

tags:

views:

answers:

Could not load file or assembly 'System.Data.SQLite'

related questions