SQLite Forum

System.Data.SQLite.EF6.dll Issues

System.Data.SQLite.EF6.dll Issues

(1) By Vladimir (I-Vladimir) on 2021-08-30 15:03:02 [source]

Hi All, Checking canonical function implementation I figured some issues in SqlGenerator:

  1. Not all canonical functions implemented.

  2. Some DateTime canonical function implementations have issues adding fragments to SqlBuilder with string.format. For example

String.Format("(({0} - 621355968000000000) / 10000000.0)", e.Arguments[1].Accept(sqlgen))

e.Arguments[1].Accept(sqlgen) returns class name instead of actual SQL string to add to the builder.

  1. A possible issue, DateTime.Now converted with no 'localtime' modifier causing date time string returned as UTC