That's what I have in the database:
CREATE GENERATOR GEN_STUDENTS_ID;
CREATE TABLE STUDENTS (
ID INTEGER NOT NULL,
FIRSTNAME VARCHAR(50)
);
ALTER TABLE STUDENTS ADD CONSTRAINT PK_STUDENTS PRIMARY KEY (ID);
CREATE TRIGGER STUDENTS_BI FOR STUDENTS
ACTIVE BEFORE INSERT POSITION 0
as
begin
if (new.id is null) then
new.id = gen_id(gen_students_id,1);
end
And the trigger fires in case with an sql query, but doesn't using Entity
Framework in Visual Studio.
Maybe I have to make this autoincrement implementation in some different
way?
Does that sql code look ok?
--
View this message in context:
http://firebird.1100200.n4.nabble.com/Entity-Framework-autoincrement-problem-tp3167085p3167974.html
Sent from the firebird-net-provider mailing list archive at Nabble.com.
------------------------------------------------------------------------------
Learn how Oracle Real Application Clusters (RAC) One Node allows customers
to consolidate database storage, standardize their database environment, and,
should the need arise, upgrade to a full multi-node Oracle RAC database
without downtime or disruption
http://p.sf.net/sfu/oracle-sfdevnl
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
