Visual Basic 2015 Unleashed

Deleting Entities

Deleting entities is also a simple task. You first need to get the instance of the entity you want to remove and then invoke the DbSet(Of T).Remove method. The following code shows how to get the instance of the specified product and then to remove it first from the model and then from the database:

Click here to view code image

Sub DeleteProduct()    Try        Dim check = northwindContext.Products.                    Single(Function(p) p.                    ProductName = "Italian spaghetti")        northwindContext.Products.Remove(check)        northwindContext.SaveChanges()        'Does not exist    Catch ex As InvalidOperationException    End TryEnd Sub

Same as in previous code, we take advantage of the Single method that ...