Devart Forums

Hi,

This query works:

var q = from o in dbContext.OrderDetails
let c = o.Customer
let cc = c.CustomerCat
select new
{
cc.Description
};

var res = q.ToList();

and generates the SQL:

SELECT t3.Description AS Description
FROM "OrderDetail" t1
INNER JOIN "Customer" t2 ON t1.CustomerId = t2.Id
INNER JOIN "CustomerCat" t3 ON t2.CustomerCatId = t3.Id

However, this query fails:

var q = from o in dbContext.OrderDetails
select new
{
o.Customer.CustomerCat.Description
};

It generates the SQL:

SELECT t3.Description AS Description
FROM "OrderDetail" t1
INNER JOIN ("Customer" t2
INNER JOIN "CustomerCat" t3 ON t2.CustomerCatId = t3.Id) ON t1.CustomerId = t2.Id

which fails with

Devart.Data.SQLite.SQLiteException
HResult=-2146233088
Message=SQLite error
no such column: t3.Description

Thank you for the report on this. We have reproduced this issue. We will investigate it and inform you about the results as soon as possible.

The bug with silent/verysilent uninstall with the NOFEEDBACK option is fixed.

______________________
https://littlelioness.net/
click here
https://littlelioness.net/2020/10/30/office-christmas-party/

MariiaI wrote:Thank you for the report on this. We have reproduced this issue. We will investigate it and inform you about the results as soon as possible.

Have you made any progress on this?

This is a bug in the CSharpSQLite engine, which cannot execute the SQL generated by LinqConnect for Metro. The fix for the issue will take some time, because we will contact the developers of the CSharpSQLite engine and wait for a reply from them. We will contact you when any results are available.

As a workaround, please use JOINs explicitly, e.g.: Or as you have written in your first post: