class Run
{
public int No;
public string Name;
public TimeSpan Time;
public byte Road;
public Run(int no, string name, TimeSpan time, byte road)
{
No = no;
Name = name;
Time = time;
Road = road;
}
}
class RoadType
{
public byte Id;
public string Name;
}
static Run[] Runs = new Run[]
{
new Run(1, "櫻花馬", new TimeSpan(5,50,16), 1),
new Run(2, "櫻木花道馬", new TimeSpan(5,27,50), 1),
new Run(3, "國道馬", new TimeSpan(4,15,38), 2),
new Run(4, "鳳梨馬", new TimeSpan(5,26,03), 1),
new Run(5, "三重馬", new TimeSpan(4,47,32), 2),
new Run(6, "台北星光馬", new TimeSpan(5,30,25), 2),
new Run(7, "海山馬", new TimeSpan(5,42,18), 2),
new Run(8, "石碇馬", new TimeSpan(6,07,54), 1),
new Run(9, "五分山馬", new TimeSpan(5,13,32), 1),
new Run(10, "土地公馬", new TimeSpan(5,26,51), 1),
new Run(11, "觀音山馬", new TimeSpan(5,47,07), 1)
};
static RoadType[] RoadTypes = new RoadType[]
{
new RoadType() { Id=1, Name="山路" },
new RoadType() { Id=2, Name="平地" }
};
static void Main(string[] args)
{
var queryBySql =
from r in Runs
where r.Time.Hours < 5
orderby r.Time
select new { r.Name, r.Time };
var r1 = queryBySql.Skip(1).Single();
var queryByLambda =
Runs
.Where(o => o.Time.Hours < 5)
.OrderBy(o => o.Time)
.Select(o => new { o.Name, o.Time });
var r2 = queryByLambda.Skip(1).Single();
Console.WriteLine("Test {0} {1}", r1.Name, r2.Name);
Console.Read();
}