System.IndexOutOfRangeException thrown when executing sql
-
Key: DNET-361
URL: http://tracker.firebirdsql.org/browse/DNET-361
Project: .NET Data provider
Issue Type: Bug
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)
On Wed, Dec 29, 2010 at 13:59, Stan sphinx...@yahoo.com wrote:
After context.SaveChanges() has performed I'm getting the id = 0 in my
database table
and the generator doesn't change its value. The second call raise an
exception, because
I'm trying to insert id as 0 and it is already stored in
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: