SQLite Forum

Canonical Function use with EF62 .NET
Hi All,
Where can I find an example using canonical functions?
I tried using System.Data.Entity.DiffDays but it doesn't have a handler in SQLite SqlBuilder. Would be good to have such mapping to all System.Data.Entity functions at least to understand what is supported.
I found DateDiff function handler in SqlBuilder but have no clue how using it.

Is there a way how to get any function definition to the model? My database models supposed to support both SQL Server and SQLite, need to find the best way for interoperability.