private IEnumerable<IGrouping<int, PersonView>> GroupPersonByBirthYear() { using (var dbContext = new CinameNetworkEntities()) { var people = dbContext.Person.Select(x => new PersonView() { Name = x.FirstName + " " + x.LastName, BirthYear = x.BirthYear }).ToList<PersonView>(); IEnumerable<IGrouping<int, PersonView>> groupedByYear = people.GroupBy(x => x.BirthYear); return groupedByYear; } }
public void UploadMongToSql(string dbName, string host) { List<PersonMongo> peopleCollection = dbController.GetPersonDataCollection(dbName, host); using (var db = new CinameNetworkEntities()) { var personCollection = new List<Person>(); foreach (var person in peopleCollection) { personCollection.Add(GetPersonFromPersonMongo(person)); } db.Person.AddRange(personCollection); db.SaveChanges(); Console.WriteLine("Success!"); } Console.WriteLine("Press Enter"); Console.ReadLine(); }