public void GetCanadianProvinces()
{
IEnumerable <StateProvince> stateProvinces = StateProvinces.GetAll();
List <string> canadianProvinces =
stateProvinces
.Where(x => x.Country == "CA")
.Select(x => x.Name)
.ToList();
Assert.AreEqual(13, canadianProvinces.Count());
Assert.Contains("Saskatchewan", canadianProvinces);
}
public void JoinToGetBritishEmployees()
{
var employees = Employees.GetAll();
var stateProvinces = StateProvinces.GetAll();
var britishStateProvinces = stateProvinces.Where(x => x.Country == "GB");
var joinedData =
employees.Join(britishStateProvinces,
e => e.StateProvinceID,
sp => sp.StateProvinceID,
(employee, stateProvince) => employee);
IEnumerable <string> brits = joinedData
.Select(x => x.FirstName + " " + x.LastName);
}
