static void Main(string[] args)
{
// メソッド構文
{
var products = NorthwindObjects.GetProducts();
var result = products.OrderBy(p => p.UnitPrice)
.Take(10);
foreach (var p in result)
{
Console.WriteLine("{0} : {1}", p.ProductName, p.UnitPrice);
}
}
Console.WriteLine();
// クエリ構文
{
var products = NorthwindObjects.GetProducts();
var query = (from p in products
orderby p.UnitPrice
select new { p.ProductName, p.UnitPrice }
).Take(10);
foreach (var p in query)
{
Console.WriteLine("{0} : {1}", p.ProductName, p.UnitPrice);
}
}
Console.ReadLine();
}
static void Main(string[] args)
{
var products = NorthwindObjects.GetProducts();
bool b = products.Any(p => p.UnitsInStock == 0);
Console.WriteLine(b);
Console.ReadLine();
}
static void Main(string[] args)
{
var products = NorthwindObjects.GetProducts();
var result = products.OrderBy(p => p.UnitPrice)
.SkipWhile(p => p.UnitPrice < 50);
foreach (var p in result)
{
Console.WriteLine("{0} : {1}", p.ProductName, p.UnitPrice);
}
Console.ReadLine();
}
static void Main(string[] args)
{
var orders = NorthwindObjects.GetOrders();
var query = orders.Where(o => o.OrderDate.Year >= 1988)
.Select(o => o.CustomerID)
.OrderBy(id => id)
.Distinct();
foreach (var o in query)
{
Console.WriteLine(o.ToString());
}
Console.ReadLine();
}
static void Main(string[] args)
{
var products = NorthwindObjects.GetProducts();
var query = (from p in products
where p.UnitPrice < 20
select new { p.ProductName, p.UnitPrice }
).TakeWhile(p => p.UnitPrice < 20);
foreach (var p in query)
{
Console.WriteLine("{0} : {1}", p.ProductName, p.UnitPrice);
}
Console.ReadLine();
}
