Dynamic SQL Error SQL error code = -104 Token unknown AND - EF Core - Two or more *Where* parameters in LINQ to SQL --------------------------------------------------------------------------------------------------------------------
Key: DNET-926 URL: http://tracker.firebirdsql.org/browse/DNET-926 Project: .NET Data provider Issue Type: Bug Environment: FirebirdSql.Data.FirebirdClient - Firebird .NET EF Core Reporter: Ryno Assignee: Jiri Cincura List<Document> documents = new List<Document>(); var docs = (from d in db.Documents where d.DOCUMENT_DATE >= startDate & d.DOCUMENT_DATE <= endDate select d).ToList(); foreach (Document doc in docs) { documents.Add(doc); } return documents; RETURNS SELECT "d"."DOCUMENT_ID", "d"."CLIENT_REF", "d"."CONVERSION_RATIO", "d"."CUSTOMER_CODE", "d"."DELIVERY_ADDRESS", "d"."DOCUMENT_DATE", "d"."DOCUMENT_TIME", "d"."DOC_NUMBER", "d"."DOC_STATUS", "d"."DOC_TYPE", "d"."EXCL", "d"."EXL_BIN", "d"."EXL_OVERREC", "d"."EXL_SURCHARGE", "d"."EXL_TRANSPORT", "d"."FINANCAIL_PERIOD", "d"."GROSSWEIGHT", "d"."INCL", "d"."INCL_BIN", "d"."INCL_OVERREC", "d"."INCL_SURCHARGE", "d"."INCL_TRANSPORT", "d"."INSTRUCTIONS", "d"."M3_QTY", "d"."MANUAL_NUMBER", "d"."OPTIONS", "d"."ORDER_NUMBER", "d"."PRICELIST_ID", "d"."PRODUCT_CODE", "d"."PRODUCT_UNIT", "d"."QTY", "d"."SUPPLIER_CODE", "d"."SURCHARGE_QTY", "d"."TRUCKTARE", "d"."VAT", "d"."VAT_CODE", "d"."VEHICLE_REG", "d"."ZONE_CODE" FROM "DOCUMENT" AS "d" WHERE (CASE WHEN "d"."DOCUMENT_DATE" >= CAST(@__startDate_0 AS TIMESTAMP) THEN TRUE ELSE FALSE END AND CASE ---- ERROR WHEN "d"."DOCUMENT_DATE" <= CAST(@__endDate_1 AS TIMESTAMP) THEN TRUE ELSE FALSE END) = TRUE Which is invalid FB Sql -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira _______________________________________________ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider