private static void PersistChildren(Show show, SqlConnection conn) { foreach (var showGenre in show.ShowGenres) { showGenre.ShowId = show.Id; ShowGenreHelper.Persist(showGenre, conn); } foreach (var credit in show.Credits) { credit.ShowId = show.Id; CreditHelper.Persist(credit, conn); } }
private static void PersistChildren(Person Person, SqlConnection conn) { foreach (var credit in Person.Credits) { credit.PersonId = Person.Id; CreditHelper.Persist(credit, conn); } foreach (var attachment in Person.PersonAttachments) { attachment.PersonId = Person.Id; PersonAttachmentHelper.Persist(attachment, conn); } }
internal static void DeleteEntity(Person item, SqlConnection conn) { // Cascade delete Credits foreach (var credit in item.Credits) { CreditHelper.DeleteEntity(credit, conn); } using (SqlCommand cmd = conn.CreateCommand()) { cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = "delete Person where Id = @Id"; cmd.Parameters.AddWithValue("@Id", item.Id); cmd.ExecuteNonQuery(); } }