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();
}
