{"id":61,"date":"2016-02-11T15:31:51","date_gmt":"2016-02-11T15:31:51","guid":{"rendered":"https:\/\/ibex.tech\/csharp\/?p=61"},"modified":"2022-02-17T06:24:15","modified_gmt":"2022-02-17T06:24:15","slug":"adding-sqlite-to-a-project","status":"publish","type":"post","link":"https:\/\/ibex.tech\/csharp\/c-sharp\/databases\/sqlite\/adding-sqlite-to-a-project","title":{"rendered":"Adding SQLite to a project"},"content":{"rendered":"

\n\tGet the latest set of files from system.data.sqlite.org<\/a>\n<\/p>\n

\n\tBinary packages are intended to be used for development and deployment of their applications onto customer machines.  Ensure you select the correct version for the .NET Framework version and Windows 32\/64bit version your applicaiton targets.  Select the version without 'mixed-mode assembly' bundle.\n<\/p>\n

\n\t(Setup packages are intended for developer machines if the design-time components for Visual Studio are required).\n<\/p>\n

\n\tSo this is what we do, we want the distribution binaries and we want them statically linked with the visual C++ runtime library in case the user doesn't already have it on their machine.  So this is what we would choose for example:\n<\/p>\n

\n\tPrecompiled Statically-Linked Binaries for 32-bit Windows (.NET Framework 4.0)\n<\/p>\n

\n\tsqlite-netFx40-static-binary-Win32-2010-1.0.94.0.zip\n<\/p>\n

\n\tPrecompiled Statically-Linked Binaries for 64-bit Windows (.NET Framework 4.0)\n<\/p>\n

\n\tsqlite-netFx40-static-binary-x64-2010-1.0.94.0.zip\n<\/p>\n

\n\tFrom the zip copy 'System.Data.SQLite.dll' into your project directory and then add it as a reference (Menu > Project > Add reference > Browse to it)\n<\/p>\n

\n\tCopy the following files \/ directories to your executables directory (debug and release).  These don’t need to be added as a reference in your project:\n<\/p>\n

\n\t\\System.Data.SQLite.dll (required, managed-only core assembly, from either zip)
\n\t\\System.Data.SQLite.Linq.dll (optional, managed-only LINQ assembly)
\n\t\\System.Data.SQLite.EF6.dll (optional, managed-only EF6 assembly)
\n\t\\x86\\SQLite.Interop.dll (required, x86 native interop assembly)
\n\t\\x64\\SQLite.Interop.dll (required, x64 native interop assembly) \n<\/p>\n

\n\tSet the projects .Net framework to match that used and ensure your distribution package \/ installer is set to install it as a prequesit if necessary.\n<\/p>\n

\n\tThats it!  \n<\/p>\n

\n\t32bit vs 64bit
\n<\/h4>\n

\n\tYour project needs to be set to the same platform architecture as that being used for the sqlite dll's.  For C# developers this means not selectecting 'Any CPU' (Project Properties > Build > Platform target). This means if your main executible will need to be created as 32bit and 64bit and deployed according to the target machine architecture.  Yes sucks, but sqlite uses unmanaged code in its dll so tough!\n<\/p>\n

\n\tThe x86 and x64 directories will likely solve development issues but if not see the "Using Native Library Pre-Loading" notes here<\/a> for an important note about managed code applications and 64 vs 32 bit development.\n<\/p>\n

\n\tDistributing Your Application
\n<\/h4>\n

\n\tThese files from your projects release output folder need to be copied into the applications executable when installed on a users PC:\n<\/p>\n

\n\t\\System.Data.SQLite.dll (required, managed-only core assembly)
\n\t\\System.Data.SQLite.Linq.dll (optional, managed-only LINQ assembly)
\n\t\\System.Data.SQLite.EF6.dll (optional, managed-only EF6 assembly)
\n\t\\x86\\SQLite.Interop.dll (required, x86 native interop assembly)
\n\t\\x64\\SQLite.Interop.dll (required, x64 native interop assembly) \n<\/p>\n

\n\tEnsure the relevant .Net framework is used.\n<\/p>\n

\n\tIssues
\n<\/h4>\n

\n\tC# application targetting 'Any CPU' (Project Properties > Build > Platform target) may cause errors and need to be changed to the same 32\/64 bit version as that downloaded.<\/p>\n","protected":false},"excerpt":{"rendered":"

Get the latest set of files from system.data.sqlite.org Binary packages are intended to be used for development and deployment of their applications onto customer machines.  Ensure you select the correct version for the .NET Framework version and Windows 32\/64bit version your applicaiton targets.  Select the version without 'mixed-mode assembly' bundle. (Setup packages are intended for developer machines if […]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[17],"tags":[],"class_list":["post-61","post","type-post","status-publish","format-standard","hentry","category-sqlite"],"_links":{"self":[{"href":"https:\/\/ibex.tech\/csharp\/wp-json\/wp\/v2\/posts\/61","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ibex.tech\/csharp\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ibex.tech\/csharp\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ibex.tech\/csharp\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/ibex.tech\/csharp\/wp-json\/wp\/v2\/comments?post=61"}],"version-history":[{"count":1,"href":"https:\/\/ibex.tech\/csharp\/wp-json\/wp\/v2\/posts\/61\/revisions"}],"predecessor-version":[{"id":62,"href":"https:\/\/ibex.tech\/csharp\/wp-json\/wp\/v2\/posts\/61\/revisions\/62"}],"wp:attachment":[{"href":"https:\/\/ibex.tech\/csharp\/wp-json\/wp\/v2\/media?parent=61"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ibex.tech\/csharp\/wp-json\/wp\/v2\/categories?post=61"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ibex.tech\/csharp\/wp-json\/wp\/v2\/tags?post=61"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}