Best way to detect unique index violation?

[Kjell Rilbe]

Hi,

In our EF Core application code we would like to detect violations of unique index or primary key.

In the thrown DbUpdateException (or some inner exception), what should we check?

Mvh,
Kjell

Kjell Rilbe
Telefon: 0733-44 24 64

Marknadsinformation i Sverige AB
Sundbybergs Torg 1 H 7 tr
172 67 Sundbyberg, Sweden
www.marknadsinformation.se
08-514 905 90

Företagskontakt.se Personkontakt.se  

[Jiří Činčura]

Hi, I suppose you're talking about `violation of PRIMARY or UNIQUE KEY constraint "XXX" on table "XXX"`. If so the best way is to check inner exception of FbException and check the error code for `335544665`.

--
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/

[Kjell Rilbe]

Den 2022-05-18 kl. 09:31, skrev Jiří Činčura:
> Hi, I suppose you're talking about `violation of PRIMARY or UNIQUE KEY constraint "XXX" on table "XXX"`. If so the best way is to check inner exception of FbException and check the error code for `335544665`.

Yes, that would be the one. :-) Thanks!

Kjell