System.Data.SQLite

Exception Running Mono on OSX when LINQ to entities translates String.StartsWith()
eg:

	return !context.Data.Any(e => e.ShortDescription.StartsWith(s));

Exception info: {
    ManagedException = "System.Data.SQLite.SQLiteException: SQL logic error or missing database\nno such function: IndexOf\n  at System.Data.SQLite.SQLite3.Prepare (System.Data.SQLite.SQLiteConnection cnn, System.String strSql, System.Data.SQLite.SQLiteStatement previous, UInt32 timeoutMS, System.String& strRemain) [0x00000] in <filename unknown>:0 \n  at System.Data.SQLite.SQLiteCommand.BuildNextCommand () [0x00000] in <filename unknown>:0 ";
    Message = "SQL logic error or missing database\nno such function: IndexOf";
    Source = "System.Data.SQLite";
    StackTrace = "  at System.Data.SQLite.SQLite3.Prepare (System.Data.SQLite.SQLiteConnection cnn, System.String strSql, System.Data.SQLite.SQLiteStatement previous, UInt32 timeoutMS, System.String& strRemain) [0x00000] in <filename unknown>:0 \n  at System.Data.SQLite.SQLiteCommand.BuildNextCommand () [0x00000] in <filename unknown>:0 ";
    Type = "System.Data.SQLite.SQLiteException";
}

I think this can be traced back to SqlGenerator.cs

#if USE_INTEROP_DLL && INTEROP_EXTENSION_FUNCTIONS
      functionHandlers.Add("IndexOf", HandleCanonicalFunctionIndexOf);
#endif

We are on OS X so USE_INTEROP_DLL won't be defined.
I don't know why conditional compilation is required in this ase.

We build our own version of 1.0.99 like so.
The project supplied build_mono.bat didn't work for me but this did.
The YEARS var targets the Visual Studio version.

SET BUILD_CONFIGURATIONS=ReleaseManagedOnly
SET PLATFORMS="Any CPU"
SET YEARS=2013
SET NOUSER=1
SET MSBUILD_ARGS=/property:UseInteropDll=false
SET MSBUILD_ARGS=%MSBUILD_ARGS% /property:UseSqliteStandard=true

build.bat ReleaseManagedOnly

The underlying CHARINDEX function from the interop assembly is used to perform
the IndexOf LINQ function, hence the #ifdef.