Problems with boolean properties?

31 views
Skip to first unread message

steve

unread,
Apr 30, 2020, 2:13:51 AM4/30/20
to firebird-net-provider
Hey,
i am urrently migrating our appliation from EF 6.4 to EF Core 3.1. Unfortunately I didn't manage to get Firebird working again.
When using migrations to create the DB, I get the followig exception:

SQL error code = -607
Invalid command
Specified domain or source column BOOLEAN does not exist

When I try to use an existing Database, everything works fine until I use a boolean property, for example in a where clause like this:

_dbContext.AnyTable.Where(t => t.IsEnabled);

This gives me SQL Errors.


The following example works as expected since no boolean is involved:
_dbContext.AnyTable.Where(t => t.Desc.Contains("xyz"));

Is this a bug or am I just missing something?

Jiří Činčura

unread,
Apr 30, 2020, 2:14:35 AM4/30/20
to 'Mr. John' via firebird-net-provider
Looks like you're not using at least Firebird 3.

--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/

steve

unread,
Apr 30, 2020, 3:52:47 AM4/30/20
to firebird-net-provider
Hi,
that's right. Are there any plans tu support 2.5.X. With EF6.4 it was absolutely no problem to map my boolean properties to our 2.5.9 database server.

Jiří Činčura

unread,
Apr 30, 2020, 3:56:58 AM4/30/20
to 'Mr. John' via firebird-net-provider
> that's right. Are there any plans tu support 2.5.X

I don't have such plan. But it can be community driven... ;)
Reply all
Reply to author
Forward
0 new messages