Loading

Code First Duplicate Insert values?

swap swap

Hi,

I am using Entity Framework Code First,

I have created combined index on two columns , now I want to make it as Ignore Duplicate values in sql through code First.

how Can i do this?

Thanks.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

swap swap9y ago
I want to create it through only code first with migration,so that it automatically creates the Ignore duplicate key true.
Abhinav Abhishek9y ago
create unique non clustered index on table for those columns

CREATE UNIQUE NONCLUSTERED INDEX [IX_DupIndex]
ON [dbo].[TableName]
(
[Field1] ASC,
[Field2] ASC
) WITH (IGNORE_DUP_KEY = ON) ON PRIMARY