{"action":"created","issue":{"url":"https://api.github.com/repos/aspnet/Microsoft.Data.Sqlite/issues/138","labels_url":"https://api.github.com/repos/aspnet/Microsoft.Data.Sqlite/issues/138/labels{/name}","comments_url":"https://api.github.com/repos/aspnet/Microsoft.Data.Sqlite/issues/138/comments","events_url":"https://api.github.com/repos/aspnet/Microsoft.Data.Sqlite/issues/138/events","html_url":"https://github.com/aspnet/Microsoft.Data.Sqlite/issues/138","id":106673310,"number":138,"title":"Use 64-bit sqlite3.dll for win-x64","user":{"login":"natemcmaster","id":2696087,"avatar_url":"https://avatars.githubusercontent.com/u/2696087?v=3","gravatar_id":"","url":"https://api.github.com/users/natemcmaster","html_url":"https://github.com/natemcmaster","followers_url":"https://api.github.com/users/natemcmaster/followers","following_url":"https://api.github.com/users/natemcmaster/following{/other_user}","gists_url":"https://api.github.com/users/natemcmaster/gists{/gist_id}","starred_url":"https://api.github.com/users/natemcmaster/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/natemcmaster/subscriptions","organizations_url":"https://api.github.com/users/natemcmaster/orgs","repos_url":"https://api.github.com/users/natemcmaster/repos","events_url":"https://api.github.com/users/natemcmaster/events{/privacy}","received_events_url":"https://api.github.com/users/natemcmaster/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/aspnet/Microsoft.Data.Sqlite/labels/blocked","name":"blocked","color":"e11d21"},{"url":"https://api.github.com/repos/aspnet/Microsoft.Data.Sqlite/labels/task","name":"task","color":"d4c5f9"}],"state":"open","locked":false,"assignee":null,"milestone":{"url":"https://api.github.com/repos/aspnet/Microsoft.Data.Sqlite/milestones/5","html_url":"https://github.com/aspnet/Microsoft.Data.Sqlite/milestones/1.0.0","labels_url":"https://api.github.com/repos/aspnet/Microsoft.Data.Sqlite/milestones/5/labels","id":1047783,"number":5,"title":"1.0.0","description":"","creator":{"login":"bricelam","id":1226749,"avatar_url":"https://avatars.githubusercontent.com/u/1226749?v=3","gravatar_id":"","url":"https://api.github.com/users/bricelam","html_url":"https://github.com/bricelam","followers_url":"https://api.github.com/users/bricelam/followers","following_url":"https://api.github.com/users/bricelam/following{/other_user}","gists_url":"https://api.github.com/users/bricelam/gists{/gist_id}","starred_url":"https://api.github.com/users/bricelam/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/bricelam/subscriptions","organizations_url":"https://api.github.com/users/bricelam/orgs","repos_url":"https://api.github.com/users/bricelam/repos","events_url":"https://api.github.com/users/bricelam/events{/privacy}","received_events_url":"https://api.github.com/users/bricelam/received_events","type":"User","site_admin":false},"open_issues":2,"closed_issues":5,"state":"open","created_at":"2015-03-31T21:47:42Z","updated_at":"2015-09-16T17:54:43Z","due_on":null,"closed_at":null},"comments":4,"created_at":"2015-09-16T00:22:43Z","updated_at":"2015-09-16T18:02:31Z","closed_at":null,"body":"Can we use http://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki#sqlite-netFx451-static-binary-x64-2013? It contains a 64-bit version for Windows. (Rename SQLite.Interop.dll to sqlite3.dll.) In initial testing, it works for coreclr-win-x64"},"comment":{"url":"https://api.github.com/repos/aspnet/Microsoft.Data.Sqlite/issues/comments/140823192","html_url":"https://github.com/aspnet/Microsoft.Data.Sqlite/issues/138#issuecomment-140823192","issue_url":"https://api.github.com/repos/aspnet/Microsoft.Data.Sqlite/issues/138","id":140823192,"user":{"login":"natemcmaster","id":2696087,"avatar_url":"https://avatars.githubusercontent.com/u/2696087?v=3","gravatar_id":"","url":"https://api.github.com/users/natemcmaster","html_url":"https://github.com/natemcmaster","followers_url":"https://api.github.com/users/natemcmaster/followers","following_url":"https://api.github.com/users/natemcmaster/following{/other_user}","gists_url":"https://api.github.com/users/natemcmaster/gists{/gist_id}","starred_url":"https://api.github.com/users/natemcmaster/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/natemcmaster/subscriptions","organizations_url":"https://api.github.com/users/natemcmaster/orgs","repos_url":"https://api.github.com/users/natemcmaster/repos","events_url":"https://api.github.com/users/natemcmaster/events{/privacy}","received_events_url":"https://api.github.com/users/natemcmaster/received_events","type":"User","site_admin":false},"created_at":"2015-09-16T18:02:31Z","updated_at":"2015-09-16T18:02:31Z","body":"Discussed with @bricelam. We are trying to avoid redistributing sqlite3.dll at all and will defer solving this until we are unblocked by other teams.\r\n\r\nIn the meantime, there is a very simple workaround for those who need win-x64. \r\n\r\n## Workaround\r\n\r\nManually add a 64-bit version of `sqlite3.dll`.\r\n\r\n1. Find the package install location. This could be `%USERPROFILE%\\.dnx\\packages\\Microsoft.Data.Sqlite\\(version)\\` or `(your project)\\packages\\Microsoft.Data.Sqlite\\`.\r\n1. Create a 2 new folders in the package install location: `(package)\\runtimes\\win\\native\\x64\\` and `(package)\\runtimes\\win-x64\\native\\`.\r\n2. Download https://www.nuget.org/api/v2/package/System.Data.SQLite.Core/1.0.98.1/ and unzip. (Rename *.nupkg => *.zip).\r\n3. From the unzipped *.nupkg, copy `(nupkg)\\build\\net451\\x64\\SQLite.Interop.dll` into both new folders from step 2 and rename to `sqlite3.dll`"}}