public static void OutputManagerEmployeesAndFilter(int managerId)
{
AdventureWorksDataContext context = new AdventureWorksDataContext();
var fred = context.uspGetManagerEmployees(managerId);
var mark = context.uspGetManagerEmployees(managerId)
.Where(emp => emp.FirstName == "Mark")
.First();
Console.WriteLine(mark.LastName);
}
public static void Delete()
{
AdventureWorksDataContext context = new AdventureWorksDataContext();
var peanuts = context.Currencies
.Where(currency => currency.CurrencyCode == "PNT")
.Single();
context.Currencies.DeleteOnSubmit(peanuts);
context.SubmitChanges();
}
public static void Update()
{
AdventureWorksDataContext context = new AdventureWorksDataContext();
var peanuts = context.Currencies
.Where(currency => currency.CurrencyCode == "PNT")
.Single();
peanuts.Name = "Roasted Peanuts";
context.SubmitChanges();
}
public static void PersonExample()
{
AdventureWorksDataContext context = new AdventureWorksDataContext();
var employeeLastNames = context.Persons
.Where(person => person.PersonType == "EM")
.Select(person => person.LastName);
foreach (var lastName in employeeLastNames)
{
Console.WriteLine(lastName);
}
}
public static void Insert()
{
AdventureWorksDataContext context = new AdventureWorksDataContext();
Currency currency = new Currency();
currency.CurrencyCode = "PNT";
currency.Name = "Peanuts";
currency.ModifiedDate = DateTime.Now;
context.Currencies.InsertOnSubmit(currency);
context.SubmitChanges();
}
public static void OutputManagerEmployees(int managerId)
{
AdventureWorksDataContext context = new AdventureWorksDataContext();
var employees = context.uspGetManagerEmployees(managerId);
foreach (var employee in employees)
{
Console.WriteLine(employee.FirstName);
}
var mark = employees.Where(emp => emp.FirstName == "Mark").First();
Console.WriteLine(mark.LastName);
}
public static void PersonExampleSqlSyntax()
{
AdventureWorksDataContext context = new AdventureWorksDataContext();
var employeeLastNames =
from person in context.Persons
where person.PersonType == "EM"
select person.LastName;
Console.WriteLine(context.GetCommand(employeeLastNames).CommandText);
foreach (var lastName in employeeLastNames)
{
Console.WriteLine(lastName);
}
}
static void LinqTest2()
{
AdventureWorksDataContext context = new AdventureWorksDataContext();
var lastNames =
context.Persons
.OrderByDescending(person => person.LastName)
.Select(person => person.LastName);
lastNames =
from person in context.Persons
orderby person.LastName descending
select person.LastName;
foreach (string lastName in lastNames)
{
Console.WriteLine(lastName);
}
}
public static void JoinExampleSqlSyntax()
{
AdventureWorksDataContext context = new AdventureWorksDataContext();
var salesByPerson =
from person in context.Persons
join salesPerson in context.SalesPersons
on person.BusinessEntityID equals salesPerson.BusinessEntityID
select new
{
FirstName = person.FirstName,
SalesLastYear = salesPerson.SalesLastYear
};
foreach (var value in salesByPerson)
{
Console.WriteLine("{0}: {1}", value.FirstName, value.SalesLastYear);
}
}
public static void JoinExample()
{
AdventureWorksDataContext context = new AdventureWorksDataContext();
var salesByPerson =
context.Persons.Join(context.SalesPersons,
person => person.BusinessEntityID,
salesPerson => salesPerson.BusinessEntityID,
(person, salesPerson) => new
{
FirstName = person.FirstName,
SalesLastYear = salesPerson.SalesLastYear
});
foreach (var value in salesByPerson)
{
Console.WriteLine("{0}: {1}", value.FirstName, value.SalesLastYear);
}
}
