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
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider