wrong data model
----------------

                 Key: DNET-438
                 URL: http://tracker.firebirdsql.org/browse/DNET-438
             Project: .NET Data provider
          Issue Type: Bug
          Components: Entity Framework support
    Affects Versions: 2.7.7
         Environment: Windows 7 64
            Reporter: Felix Gonzalez
            Assignee: Jiri Cincura



When I generate a model, if column it´s not defined as not null a get an error 
about primary key can´t be null.
If I define all columns as not null, model is generated but all columns are 
marked as primary key.

With this table I get error

CREATE TABLE ARTICULOS (
    CODIGO       VARCHAR(30) NOT NULL,
    DESCRIPCION  VARCHAR(80),
    TARIFA       NUMERIC(15,2) DEFAULT 0 NOT NULL
);
ALTER TABLE ARTICULOS ADD CONSTRAINT PK_ARTICULOS PRIMARY KEY (CODIGO);

And with this:

CREATE TABLE ARTICULOS1 (
    CODIGO       VARCHAR(30) NOT NULL,
    DESCRIPCION  VARCHAR(80) not null,
    TARIFA       NUMERIC(15,2) DEFAULT 0 NOT NULL
);
ALTER TABLE ARTICULOS1 ADD CONSTRAINT PK_ARTICULOS1 PRIMARY KEY (CODIGO);

The model are generated but or column marked as "key"


-- 
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

       

------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and 
threat landscape has changed and how IT managers can respond. Discussions 
will include endpoint security, mobile security and the latest in malware 
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Reply via email to