Ramesh  Maruthi

Ramesh Maruthi

  • NA
  • 4.2k
  • 521.1k

Delete multiple Records which has a FKkey using EF ?

Aug 4 2014 9:24 AM

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