//Use this when implement delete feature public void DeleteContributor(int id) { using (var context = new ContributionDataContext(_connectionString)) { context.ExecuteCommand("DELETE FROM Contributors WHERE Id = {0}", id); //can do with context.Delete but that requires 2 database hits } }
public void UpdateSimchaContributions(int simchaId, List <ContributionInclusion> contributors) { using (var context = new ContributionDataContext(_connectionString)) { context.ExecuteCommand("DELETE FROM Contributions WHERE SimchaId = {0}", simchaId); //can do with context.Delete but that requires 2 database hits foreach (var c in contributors) { context.Contributions.InsertOnSubmit(new Contribution { SimchaId = simchaId, ContributorId = c.ContributorId, Amount = c.Amount }); } } }