SQLite Forum

Canonical Function use with EF62 .NET

Canonical Function use with EF62 .NET

(1) By Vladimir (I-Vladimir) on 2021-08-22 22:57:21 [source]

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.