EntityFramework & Oracle - How to get inserted Id?

Question

I am using generic entity framework repository pattern for my oracle database.

public int Add(TEntity entity)
{
      var addedEntity = _context.Entry(entity);
      addedEntity.State = EntityState.Added;
      return _context.SaveChanges();
}

Simply, how can I get my entity Id after that is inserted to database with generated id.

Edit: I am using oracle 11g. So there is no 'identity' keyword. I created sequences for getting max ref and trigger it before inserting. So, the entity which is I send to EF not updating after SaveChanges();

Thanks...

For Oracle you will need to get the next sequence value and use that as the Id. — Rosdi Kasim, Mar 30 '18 at 06:12
@RosdiKasim Can you explain it a little bit more or can I get a resource link ? — cpzz, Mar 30 '18 at 06:22
@RosdiKasim Is there any way to get rid of raw sql ? Is EF support to call squence with a method ? — cpzz, Mar 30 '18 at 06:45

score 1 · Answer 1 · edited Oct 14 '18 at 19:06

1

For your identity-Column you have to set the property <storeGeneratedPattern> to <Identity> in the EF Model-Browser.

Go to your entity in the Model Browser
Set property

This will get the current, new value for your ID-Column after your identity has been saved.

Works for me with ORACLE, EF-Framework 6

edited Oct 14 '18 at 19:06

Mr Lister

44,061
15
107
146

answered Oct 13 '18 at 09:40

Karl

2,971
3
19
24

EntityFramework & Oracle - How to get inserted Id?

1 Answers1