From: Mr. J. <mr_...@ya...> - 2017-08-25 17:32:41
|
HiI'm using FB 2.5,EF Firebird 5.9.1,Asp MVC 5 with VS 2017 on a table I have a trigger to generate ID: CREATE OR ALTER TRIGGER TRIG_MYTABLE_BI FOR MYTABLE ACTIVE BEFORE INSERT POSITION 0 AS BEGIN IF ((NEW.ID IS NULL) OR (NEW.ID=0)) THEN NEW.ID=NEXT VALUE FOR GEN_MYTABLE_ID; END in my code I insert data like this: myTableEnt newRec= new myTableEnt() { NAME='MYNAME', .... }; db.myTableEnt.Add(newRec); db.SaveChanges(); return ToJson(new { msg = newRec.ID.ToString() }); newRec.ID is returned always 0,but in database value is generatedwhat I've done wrongthanks |