description: I installed the new .NET Provider and tried to update my EDMX Model (with Database First) but I am getting the following in my output window:

Unable to generate the model because of the following exception: 'An error occurred while executing the command definition. See the inner exception for details.
Dynamic SQL Error
SQL error code = -204
Data type unknown
Implementation limit exceeded
COLUMN DSQL internal
Dynamic SQL Error
SQL error code = -204
Data type unknown
Implementation limit exceeded
COLUMN DSQL internal
'.
Loading metadata from the database took 00:00:00.4426206.
Generating the model took 00:00:07.6167923.
Added the connection string to the App.Config file.
Writing the .edmx file took 00:00:00.0012551.

I am creating the following Domain, since Firebird 2.5 and earlier is lacking support for boolean:

SET TRANSACTION;

SET TERM !! ;
EXECUTE BLOCK AS BEGIN

if (exists(select 1 from rdb$fields f, rdb$types t
where f.rdb$field_name='BOOLEAN'
and f.rdb$field_type=t.rdb$type
and t.rdb$field_name='RDB$FIELD_TYPE')) then
execute statement 'drop DOMAIN BOOLEAN;';

execute statement 'CREATE DOMAIN BOOLEAN
AS SMALLINT DEFAULT 0
CHECK (value in (0, 1));';
END!!
SET TERM ; !!

COMMIT TRANSACTION;

could this be the root of the problem, and how would I fix it?

In my Database I have

=>

I installed the new .NET Provider and tried to update my EDMX Model (with Database First) but I am getting the following in my output window:

Unable to generate the model because of the following exception: 'An error occurred while executing the command definition. See the inner exception for details.
Dynamic SQL Error
SQL error code = -204
Data type unknown
Implementation limit exceeded
COLUMN DSQL internal
Dynamic SQL Error
SQL error code = -204
Data type unknown
Implementation limit exceeded
COLUMN DSQL internal
'.
Loading metadata from the database took 00:00:00.4426206.
Generating the model took 00:00:07.6167923.
Added the connection string to the App.Config file.
Writing the .edmx file took 00:00:00.0012551.

I am creating the following Domain, since Firebird 2.5 and earlier is lacking support for boolean:

SET TRANSACTION;

SET TERM !! ;
EXECUTE BLOCK AS BEGIN

if (exists(select 1 from rdb$fields f, rdb$types t
where f.rdb$field_name='BOOLEAN'
and f.rdb$field_type=t.rdb$type
and t.rdb$field_name='RDB$FIELD_TYPE')) then
execute statement 'drop DOMAIN BOOLEAN;';

execute statement 'CREATE DOMAIN BOOLEAN
AS SMALLINT DEFAULT 0
CHECK (value in (0, 1));';
END!!
SET TERM ; !!

COMMIT TRANSACTION;

could this be the root of the problem, and how would I fix it?

Thanks in advance.

Link: This issue duplicates DNET513 [ DNET513 ]

status: Open [ 1 ] => Closed [ 6 ]

resolution: Duplicate [ 3 ]

Link: This issue relate to DNET520 [ DNET520 ]

Link: This issue relate to DNET520 [ DNET520 ] =>

Link: This issue relate to DNET518 [ DNET518 ]

Link: This issue relate to DNET518 [ DNET518 ] =>