search

ralmsdeveloper / EntityFrameworkCore.FirebirdSQL

FirebirdSQL database provider for Entity Framework Core.
Other
44 stars 26 forks source link

Use Any() #21

Closed marek1972 closed 6 years ago

marek1972 commented 6 years ago

The issue

Use of Any()

Steps to reproduce

if (context.Students.Any()){}

Error details

InnerException = {Dynamic SQL Error SQL error code = -206 Column unknown TRUE At line 5, column 15}

Exception message:
Stack trace:
SELECT CASE
    WHEN EXISTS (
        SELECT 1
        FROM "Student" AS "s")
    THEN TRUE ELSE FALSE
END FROM RDB$DATABASE

FirebirdSql.Data.FirebirdClient.FbException (0x80004005): Dynamic SQL Error
SQL error code = -206
Column unknown
TRUE
At line 5, column 15 ---> Dynamic SQL Error

Further technical details

Firebird version: 2.5 EntityFrameworkCore.FirebirdSql version: 2.0.11.3

Other details about my project setup:

ralmsdeveloper commented 6 years ago

Actually this was not implemented for version 2.5, only 3.x, for the reason that boolean type support. I was planning to implement this for 2.1, because we will support the conversion, but I will try to implement this soon for FB 2.5

marek1972 commented 6 years ago

Thanks.

ralmsdeveloper commented 6 years ago

Fixed in version 2.0.11.4, available in nuget!

marek1972 commented 6 years ago

Any() works properly. Thanks a lot.