static void Main(string[] args)
{
List<SampleHarness> harnesses = new List<SampleHarness>();
LinqSamples linqHarness = new LinqSamples();
harnesses.Add(linqHarness);
Application.EnableVisualStyles();
using (SampleForm form = new SampleForm("HomeWork - Mihail Romanov", harnesses))
{
form.ShowDialog();
}
}
static void Main(string[] args)
{
List <SampleHarness> harnesses = new List <SampleHarness>();
LinqSamples linqHarness = new LinqSamples();
harnesses.Add(linqHarness);
LinqToSqlSamples linqToSqlHarness = new LinqToSqlSamples();
harnesses.Add(linqToSqlHarness);
Application.EnableVisualStyles();
using (SampleForm form = new SampleForm("HomeWork", harnesses))
{
form.ShowDialog();
}
}
public void Linq003()
{
int[] arr = { 100, 1000, 10000, 100000 };
foreach (var x in arr)
{
ObjectDumper.Write("");
ObjectDumper.Write("");
ObjectDumper.Write($"x is {x}");
ObjectDumper.Write("");
ObjectDumper.Write("");
var result = this.dataSource.Customers
.Where(cust => cust.Orders.Any(order => order.Total > x))
.Select(cust => $"Customer {cust.CompanyName} have order with {cust.Orders.First(order => order.Total > x).Total} total");
LinqSamples.Show(result);
}
}
public void Linq008()
{
const int min = 10;
const int max = 100;
var dict = new Dictionary <string, uint>
{
{ "Low", 0 },
{ "Middle", 1 },
{ "High", 2 },
};
var result = this.dataSource.Products
.GroupBy(product => LinqSamples.GetRange(product, min, max),
product => $"Name = {product.ProductName}, price is {product.UnitPrice.ToString(".##")}")
.OrderBy(kvp => dict[kvp.Key]);
LinqSamples.Show(result);
}
public void LinqQuery07()
{
decimal lowPrice = 30;
decimal highPrice = 80;
var products = new LinqSamples().GetProductList();
var GroupProd = products.GroupBy(
p =>
{
if (p.UnitPrice > highPrice)
{
return("High");
}
if (p.UnitPrice > lowPrice)
{
return("Middle");
}
return("Low");
});
ObjectDumper.Write(GroupProd, 5);
}
public void Linq009()
{
var profitability = from customer in this.dataSource.Customers
group customer by customer.City
into groupped
select
new KeyValuePair <string, decimal>(groupped.Key,
groupped.SelectMany(c => c.Orders).Average(o => o.Total));
LinqSamples.WriteHeader("Profitability");
LinqSamples.Show(profitability);
var intensity = from customer in this.dataSource.Customers
group customer by customer.City
into groupped
select
new KeyValuePair <string, double>(groupped.Key, groupped.Average(customer => customer.Orders.Length));
LinqSamples.WriteHeader("Intensity");
LinqSamples.Show(intensity);
}
static void Main(string[] args)
{
List<SampleHarness> harnesses = new List<SampleHarness>();
// LinqSamples:
LinqSamples linqHarness = new LinqSamples();
harnesses.Add(linqHarness);
// Linq To SQL Samples:
LinqToSqlSamples linqToSqlHarness = new LinqToSqlSamples();
harnesses.Add(linqToSqlHarness);
// LinqToXmlSamples:
LinqToXmlSamples linqToXmlHarness = new LinqToXmlSamples();
harnesses.Add(linqToXmlHarness);
// DataSetLinqSamples:
DataSetLinqSamples dsLinqSamples = new DataSetLinqSamples();
harnesses.Add(dsLinqSamples);
// XQueryUseCases:
XQueryUseCases xqueryHarness = new XQueryUseCases();
harnesses.Add(xqueryHarness);
if (args.Length >= 1 && args[0] == "/runall") {
foreach (SampleHarness harness in harnesses)
{
harness.RunAllSamples();
}
}
else {
Application.EnableVisualStyles();
using (SampleForm form = new SampleForm("LINQ Project Sample Query Explorer", harnesses))
{
form.ShowDialog();
}
}
}
public void LinqQuery09()
{
var customers = new LinqSamples().GetCustomerList();
var res = from c in customers
group c by c.CustomerID into custID
select new
{
Customer = custID.Key,
custID =
from y in custID
from o in y.Orders
group o by o.OrderDate.Year into oYear
select new
{
Year = oYear.Key,
oYear =
from m in oYear
group m by m.OrderDate.Month into oMonth
select new { Month = oMonth.Key, Sum = oMonth.Sum(order => order.Total) }
}
};
ObjectDumper.Write(res, 5);
}