0
Reply

Delete multiple Records which has a FKkey using EF ?

Ramesh  Maruthi

Ramesh Maruthi

Aug 4 2014 9:24 AM
661

Hi friends,
How can I delete multiple records from a table which has FK key using entity framework Database first Approach? Other than Cascade delete please suggest me some other ideas :)
below are the table designs:
Inventory table:
InventoryId InventoryTypeId PartNumber LocationId WarehouseID MerchantID --> InventoryId is the primarykey
InventoryOrderTable
InventoryOrderID OrderID FromInventoryID ToInventoryID -->FromInventoryId and ToInventoryID is the foreignkey
I will pass an array of InventoryIDS to delete it was throwing an error delete Constraint FKKey