public async Task RunCheck(Source source, string connectionString) { var playlists = await GetSongs(source.Url); using (SqlConnection conn = new SqlConnection(connectionString)) { conn.Open(); using (SqlCommand cmd = new SqlCommand(mergeSql, conn)) { foreach (var playlist in playlists.OrderBy(t => t.Key)) { cmd.Parameters.Clear(); cmd.Parameters.AddWithValue("Station", playlist.Value.Station); cmd.Parameters.AddWithValue("Title", playlist.Value.Title); cmd.Parameters.AddWithValue("Artist", playlist.Value.Artist); await cmd.ExecuteNonQueryAsync(); } } } }
partial void DeleteSource(Source instance);
partial void UpdateSource(Source instance);
partial void InsertSource(Source instance);
private void detach_Sources(Source entity) { this.SendPropertyChanging(); entity.Station1 = null; }
private void attach_Sources(Source entity) { this.SendPropertyChanging(); entity.Station1 = this; }