Options for using System.Data.SQLite in a 32bit and 64bit C# world

by

This is an elaboration of the answer from Springy76. Do this:

public class AssemblyResolver
{
    public static void HandleUnresovledAssemblies()
    {
        AppDomain currentDomain = AppDomain.CurrentDomain;
        currentDomain.AssemblyResolve += currentDomain_AssemblyResolve;
    }

    private static Assembly currentDomain_AssemblyResolve(object sender, ResolveEventArgs args)
    {
        if (args.Name == "System.Data.SQLite")
        {
            var path = Path.Combine(pathToWhereYourNativeFolderLives, "Native");

            if (IntPtr.Size == 8) // or for .NET4 use Environment.Is64BitProcess
            {
                path = Path.Combine(path, "64");
            }
            else
            {
                path = Path.Combine(path, "32");
            }

            path = Path.Combine(path, "System.Data.SQLite.DLL");

            Assembly assembly = Assembly.LoadFrom(path);
            return assembly;
        }

        return null;
    }
}

Make sure the paths generated point to the correct locations for either your 32 bit or 64 bit SQLite Dlls. Personally I’ve had good results with those in this NuGet package: http://www.nuget.org/packages/SQLitex64

(You only need to use the NuGet package to get hold of the compiled SQLite Dlls. Once you’ve got them, remove the reference to SQLite in your project created by NuGet and the NuGet package itself. Indeed, leaving the reference in place can interfere with this solution as SQLite will never be recognised as an unresolved assembly.)

Call ‘HandleUnresolvedAssemblies()’ as early as possible, preferably during any Bootstrapping.

More Related Contents:

  1. What ‘additional configuration’ is necessary to reference a .NET 2.0 mixed mode assembly in a .NET 4.0 project?
  2. Is there a .NET/C# wrapper for SQLite? [closed]
  3. Microsoft.Jet.OLEDB.4.0′ provider is not registered on the local machine
  4. SQLite Database Locked exception
  5. File getting copied to SysWOW64 instead of System32
  6. Using a 32bit or 64bit dll in C# DllImport
  7. Problems using Entity Framework 6 and SQLite
  8. SQLite .NET performance, how to speed up things?
  9. Encrypt SQLite database in C#
  10. Why does Math.Exp give different results between 32-bit and 64-bit, with same input, same hardware
  11. How to loop through all enum values in C#? [duplicate]
  12. Unable to load DLL ‘SQLite.Interop.dll’
  13. Why is a Dictionary “not ordered”?
  14. Best way to read a large file into a byte array in C#?
  15. Return StreamReader to Beginning
  16. Why use the C# class System.Random at all instead of System.Security.Cryptography.RandomNumberGenerator?
  17. When is optimization premature? [closed]
  18. Class with indexer and property named “Item”
  19. Can the C# interactive window interact with my code?
  20. How to suppress a dialog box displayed by code that I can’t change?
  21. Serializing null in JSON.NET
  22. i have to access/commit/update SVN repository in WPF application using SVN API or libraries [closed]
  23. How can I clear event subscriptions in C#?
  24. How to declare a local variable in Razor?
  25. LINQ performance FAQ
  26. Condition Variables C#/.NET
  27. Accessing a Dictionary.Keys Key through a numeric index
  28. Can I import a static class as a namespace to call its methods without specifying the class name in C#?
  29. C# OpenFileDialog Lock To Directory
  30. How to set text to a control from resource file in design time?

Leave a Comment