Entity Framework Core Interbase -quotation marks issue

44 views Asked by At

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?"

0

There are 0 answers