in my program.cs class:
List<WebApi.Models.Transaction> transactionsCSV = new();
and in my dbContext class:
public DbSet<WebApi.Models.Transaction>? Transactions { get; set; }
The list is populated with rows from a CSV. The idea is that all these will get added to the database. However, it should ignore any rows already in the dbset (Transactions table).
So I need to I need to delete any rows in the transactionsCSV List which exist in the Transactions dbset and it should match it by two proprties transaction.description and transaction.date.
How would I accomplish this?