From: Rand R. (JIRA) <tr...@fi...> - 2013-08-05 09:08:24
|
SQL error code = -204 --------------------- Key: DNET-514 URL: http://tracker.firebirdsql.org/browse/DNET-514 Project: .NET Data provider Issue Type: Bug Components: ADO.NET Provider, DDEX Provider, Entity Framework support Affects Versions: 3.1.0.0 Environment: Win7 x64 - .NET 4.5 - VS 2012 - EF 5.0 Reporter: Rand Random Assignee: Jiri Cincura 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 -- 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 |