private static void ImportVenus(string section, string[] categories, string keyword) { using (var dbContext = new DistrictsInTownModelContainer()) { int chunkSize = 50; int offset = 0; ForesquareVenueResult result; do { result = ExploreVenues(offset, chunkSize, "Berlin, DE", section, categories, keyword).Result; offset += chunkSize; WriteVenues(result.Venues); foreach (var venue in result.Venues) AddVenueToDatabase(dbContext, venue); try { dbContext.SaveChanges(); } catch (Exception error) { } Console.WriteLine("Total results: {0}", result.TotalResults); } while (offset < result.TotalResults); } }
/// <summary> /// Saves <see cref="Place" /> items with new zip codes. /// </summary> /// <param name="places">The <see cref="Place" /> items that should be saved.</param> public void This(IEnumerable<Place> places) { using (var container = new DistrictsInTownModelContainer()) { foreach (var place in places) { var placeToUpdate = container.Places.SingleOrDefault(p => p.Source == place.Source); if (placeToUpdate == null) { continue; } placeToUpdate.Zip = place.ZipCode; } container.SaveChanges(); } }
public void Save(Dictionary<string, List<News>> news) { decimal min = news.Min(n => n.Value.Min(m => m.RawScore)); decimal max = news.Max(n => n.Value.Max(m => m.RawScore)); using (var dbContext = new DistrictsInTownModelContainer()) { foreach (var district in news) AddArticlesToDB(dbContext, district, min, max); try { dbContext.SaveChanges(); } catch (Exception error) { Console.WriteLine(error.StackTrace); } Console.WriteLine("Total results: {0}", news.Sum(n => n.Value.Count)); } }