static void Main(string[] args)
{
var endsInA = from s in students
where s.Last.EndsWith("a")
select s;
foreach (var student in endsInA)
{
Console.WriteLine(student.First + " " + student.Last);
}
Console.ReadLine();
var groups = from s in students
group s by s.team into studentGroup
select new
{
Team = studentGroup.Key,
IdSum = studentGroup.Sum(x => x.ID),
ScoreSum = studentGroup.Sum(x => x.Scores.Sum())
};
foreach (var g in groups)
{
Console.WriteLine("Team: " + g.Team + " ID SUM: " + g.IdSum + " ScoreSum: " + g.ScoreSum);
}
Console.ReadLine();
using (MssqlDataContext dc = new MssqlDataContext())
{
var customers = from c in dc.Customers
where c.LastName == "Vessa" select c;
foreach (var c in customers)
{
Console.WriteLine("Name: " + c.FirstName + " " + c.LastName);
c.FirstName = "Bob";
}
dc.SubmitChanges();
}
Console.ReadLine();
}
public CustomerRepository(MssqlDataContext context)
{
_context = context;
}
