Re: [Firebird-net-provider] EF - last inserted ID is 0

2017-08-29 Thread Mr. John via Firebird-net-provider
HiI've tried your second suggestion setting PK description to #PK_GEN# and not workingthanks From: Jiří Činčura To: "firebird-net-provider@lists.sourceforge.net" Sent: Tuesday, August 29, 2017, 10:40:52 AM GMT+3Subject: Re: [Firebird-net-provider] EF - last inserted ID is 0 Wi

Re: [Firebird-net-provider] EF - last inserted ID is 0

2017-08-29 Thread Jiří Činčura
7, > 2:48:44 PM GMT+3Subject: Re: [Firebird-net-provider] EF - last > inserted ID is 0 > Why so complex. Just use > https://msdn.microsoft.com/en-us/library/system.data.entity.modelconfiguration.configuration.primitivepropertyconfiguration.hasdatabasegeneratedoption(v=vs.113).aspx&g

Re: [Firebird-net-provider] EF - last inserted ID is 0

2017-08-28 Thread Mr. John via Firebird-net-provider
Hi.I'm using Db first and as I found that is about code firstIf I'm wrong please someone give me some tips about using thatthanks. From: Jiří Činčura To: "firebird-net-provider@lists.sourceforge.net" Sent: Monday, August 28, 2017, 2:48:44 PM GMT+3Subject: Re: [Firebird-net

Re: [Firebird-net-provider] EF - last inserted ID is 0

2017-08-28 Thread Jiří Činčura
Why so complex. Just use https://msdn.microsoft.com/en-us/library/system.data.entity.modelconfiguration.configuration.primitivepropertyconfiguration.hasdatabasegeneratedoption(v=vs.113).aspx and that's it. You should consider you entities store agnostic, in fact. -- Mgr. Jiří Činčura https://www.

Re: [Firebird-net-provider] EF - last inserted ID is 0

2017-08-28 Thread Mr. John via Firebird-net-provider
sourceforge.net" Sent: Sunday, August 27, 2017, 6:16:03 PM GMT+3Subject: Re: [Firebird-net-provider] EF - last inserted ID is 0 Your myTableEnt should have Id marked as DatabaseGen…Options.Identity. Then it's fetched back automatically.  -- Mgr. Jiří Činčura https://www.tabsoverspaces.co

Re: [Firebird-net-provider] EF - last inserted ID is 0

2017-08-27 Thread Jiří Činčura
Your myTableEnt should have Id marked as DatabaseGen…Options.Identity. Then it's fetched back automatically. -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ On Fri, Aug 25, 2017, at 19:28, Mr. John via Firebird-net-provider wrote:> HiI'm using FB 2.5,EF Firebird 5.9.1,Asp MVC 5 with VS 2017

Re: [Firebird-net-provider] EF - last inserted ID is 0

2017-08-26 Thread Mr. John via Firebird-net-provider
MT+3Subject: Re: [Firebird-net-provider] EF - last inserted ID is 0 Hi, At August 26, 2017, 1:38 AM, Mr. John via Firebird-net-provider wrote: | | Hi. Thanks Paul for your answer For my first code I've followed this: https://stackoverflow.com/questions/4068084/how-to-find-an-identity-of-the-

Re: [Firebird-net-provider] EF - last inserted ID is 0

2017-08-26 Thread Daniel Rail
Title: Re: [Firebird-net-provider] EF - last inserted ID is 0 Hi, At August 26, 2017, 1:38 AM, Mr. John via Firebird-net-provider wrote: Hi. Thanks Paul for your answer For my first code I've followed this: https://stackoverflow.com/questions/4068084/how-to-find-an-identity-of-the

Re: [Firebird-net-provider] EF - last inserted ID is 0

2017-08-25 Thread Mr. John via Firebird-net-provider
c: Mr. John Sent: Friday, August 25, 2017, 11:35:11 PM GMT+3Subject: Re: [Firebird-net-provider] EF - last inserted ID is 0 The trigger from you database has nothing to do with your c# code.You can use a stored procedure to insert data and returning latest id (also you can read current sequence val

Re: [Firebird-net-provider] EF - last inserted ID is 0

2017-08-25 Thread paul.mercea
message From: "Mr. John via Firebird-net-provider" Date: 8/25/17 20:28 (GMT+02:00) To: "For Users and Developers of the Firebird .NET Providers" Cc: "Mr. John" Subject: [Firebird-net-provider] EF - last inserted ID is 0 HiI'm using FB 2.5,EF Fi

[Firebird-net-provider] EF - last inserted ID is 0

2017-08-25 Thread Mr. John via Firebird-net-provider
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.I