I am facing an issue with Interbase connectivity using Entity Framework Core, following the guidelines provided in this documentation: https://docwiki.embarcadero.com/InterBase/2020/en/Entity_Framework. The problem arises in the following code snippet:
using (var db = new myContext())
{
var iqryble = db.Userlists.Select(d => d.USRID);
var result = iqryble.ToList();
}
The generated SQL code includes double quotes around table and column names, which is not valid in the Interbase database. The error received is:
Error at line 1
Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, char 11
.
SQL - SELECT "u"."USRID"
FROM "USERLIST" AS "u"
This issue is due to the double quotes. How can I fix this problem?"