LinqConnect Professional Version 4.2.229 (18-Apr-2013) - incorrect SQL for SQLite
Posted: Fri 26 Apr 2013 09:15
I have a Linq query:
which will be generated SQL:
If to use such query:
it will return incorrect SQL (datetime(t1.DT, '+-1 day') instead of datetime(t1.DT, '-1 day')):
Code: Select all
from v in Values
where v.DT > DateTime.Parse("2013-04-10") &&
v.DT < DateTime.Parse("2013-04-11")
select new
{
dt = v.DT.AddDays(+1),
v.Val
}
Code: Select all
SELECT datetime(t1.DT, '+1 day') AS C1, t1.Val AS Val
FROM "Values" t1
WHERE (t1.DT > :p0) AND (t1.DT < :p1)
Code: Select all
from v in Values
where v.DT > DateTime.Parse("2013-04-10") &&
v.DT < DateTime.Parse("2013-04-11")
select new
{
dt = v.DT.AddDays(-1),
v.Val
}
it will return incorrect SQL (datetime(t1.DT, '+-1 day') instead of datetime(t1.DT, '-1 day')):
Code: Select all
SELECT datetime(t1.DT, '+-1 day') AS C1, t1.Val AS Val
FROM "Values" t1
WHERE (t1.DT > :p0) AND (t1.DT < :p1)