SQLite exception: "no such function: BigCount" when using "count" calling OData service with EntityFramework provider
I also encountered the error SQL logic error or missing database\r\nno such function: BigCount and here are the detailed step-by-step instructions I used to update the code to resolve the issue on a Windows operating system:
Download fossil and extract fossil.exe to your
<working>directoryOpen a normal command prompt
Run
cd <working>Run
fossil clone https://system.data.sqlite.org/ sds.fossilRun
fossil open sds.fossilRun
fossil update <release-tag>For example,
fossil update release-1.0.105.2Update
.\System.Data.SQLite.Linq\SQL Generation\SqlGenerator.cs:
a. un-comment lines 1978 - 1983
b. replace line 1982 with the following line:aggregateResult.Append("COUNT");Run
cd SetupRun
set_YYYY.batFor example, to build the net451 binaries, run
set_2013.batRun
build.bat ReleaseManagedOnlyRemove the references to
System.Data.SQLite.LinqandSystem.Data.SQLite.EF6from the ASP.NET Web projectAdd references to the new
System.Data.SQLite.Linq.dllandSystem.Data.SQLite.EF6.dllfrom<working>\bin\2013\Release\binin the ASP.NET Web project
Sources:
System.Data.SQLite Source Code
System.Data.SQLite Build Procedures
System.Data.SQLite Ticket UUID 76c2eaadc0297696b2c5fb10d41a22325f56f9b9