static void ShowLondonAndewFullerSubtree()
{
Console.WriteLine("\nShowLondonAndewFullerSubtree\n");
// Andrew Fuller EmployeeId is 2
// SELECT FirstName, LastName
// FROM GetEmployeeSubTree(2)
// WHERE City = 'London'
// ORDER BY FirstName, LastName
IQueryLite <Employee> query = new FunctionQueryLite <Employee>(ds, "dbo.GetEmployeeSubTree", 2)
.Fields(EmployeeFields.FirstName, EmployeeFields.LastName)
.Where(EmployeeFields.City, "London")
.OrderBy(EmployeeFields.FirstName, EmployeeFields.LastName);
foreach (var emp in query.ToEnumerable())
{
Console.WriteLine("FirstName: {0}, LastName: {1}", emp.FirstName, emp.LastName);
}
}
static void ShowLondonAndewFullerSubtree()
{
Console.WriteLine("\nShowLondonAndewFullerSubtree\n");
// Andrew Fuller EmployeeId is 2
// SELECT FirstName, LastName
// FROM GetEmployeeSubTree(2)
// WHERE City = 'London'
// ORDER BY FirstName, LastName
IQueryLite<Employee> query = new FunctionQueryLite<Employee>(ds, "dbo.GetEmployeeSubTree", 2)
.Fields(EmployeeFields.FirstName, EmployeeFields.LastName)
.Where(EmployeeFields.City, "London")
.OrderBy(EmployeeFields.FirstName, EmployeeFields.LastName);
foreach (var emp in query.ToEnumerable())
{
Console.WriteLine("FirstName: {0}, LastName: {1}", emp.FirstName, emp.LastName);
}
}
