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);
}
}
internal static void DeleteEntity(Show item, SqlConnection conn)
{
// Cascade delete ShowGenres
foreach (var genre in item.ShowGenres)
{
ShowGenreHelper.DeleteEntity(genre, conn);
}
// Cascade delete Credits
foreach (var credit in item.Credits)
{
CreditHelper.DeleteEntity(credit, conn);
}
// Delete Show itself
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = "delete Show where Id = @Id";
cmd.Parameters.AddWithValue("@Id", item.Id);
cmd.ExecuteNonQuery();
}
}
