Yes I can do that thing but I want to return a currently generated id
in order to use it in my entity class, and it is still 0.
I mean the schema insert - select seems not working in my code using
firebird database.
In case with mssql it returns the proper value,
so maybe I have to do something
I read that article before but the thing that the property Identity is
disappering
makes me think that I have another problem (I didn't have it disappeared).
Now I noticed that the comment in the column on the database side causes
the StoreGeneratedPattern property in the SSDL content section of
Hi,
I have a problem with Identity store generation pattern.
It seems doesn't work or maybe I'm doing something wrong.
I've made the table students and the fields id and name as the key
field as well as
the generator. The simple insert sql statement - insert into students(name)
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
It seems that the firebird server performs
insert into students(id, firstname) values(0, 'asdf')
instead of
insert into students(firstname) values('asdf')
select id ...
--
View this message in context: