Linq
Linq概述
列表和实体
Racer
public class Racer : IComparable<Racer>, IFormattable { public Racer(string firstName, string lastName, string country, int starts, int wins, IEnumerable<int> years, IEnumerable<string> cars) { FirstName = firstName; LastName = lastName; Country = country; Starts = starts; Wins = wins; Years = years != null ? new List<int>(years) : new List<int>(); Cars = cars != null ? new List<string>(cars) : new List<string>(); } public Racer(string firstName, string lastName, string country, int starts, int wins) : this(firstName, lastName, country, starts, wins, null, null) { } public string FirstName { get; set; } public string LastName { get; set; } public string Country { get; set; } public int Wins { get; set; } public int Starts { get; set; } public IEnumerable<string> Cars { get; } public IEnumerable<int> Years { get; } public override string ToString() => $"{FirstName} {LastName}"; public int CompareTo(Racer other) => LastName.CompareTo(other?.LastName); public string ToString(string format) => ToString(format, null); public string ToString(string format, IFormatProvider formatProvider) { switch (format) { case null: case "N": return ToString(); case "F": return FirstName; case "L": return LastName; case "C": return Country; cas "S":
return Starts.ToString();
case "W":
return Wins.ToString();
case "A":
return $"{FirstName} {LastName}, country: {Country}; starts: {Starts}, wins: {Wins}";
default:
throw new FormatException($"Format {format} not supported");
}
}
}Team
public class Team
{
public Team(string name, params int[] years)
{
Name = name;
Years = years != null ? new List<int>(years) : new List<int>();
}
public string Name { get; }
public IEnumerable<int> Years { get; }
}Formulal
public static class Formula1
{
private static List<Racer> _racers;
public static IList<Racer> GetChampions()
{
if (_racers == null)
{
_racers = new List<Racer>(40);
_racers.Add(new Racer("Nino", "Farina", "Italy", 33, 5, new int[] { 1950 }, new string[] { "Alfa Romeo" }));
_racers.Add(new Racer("Alberto", "Ascari", "Italy", 32, 10, new int[] { 1952, 1953 }, new string[] { "Ferrari" }));
_racers.Add(new Racer("Juan Manuel", "Fangio", "Argentina", 51, 24, new int[] { 1951, 1954, 1955, 1956, 1957 }, new string[] { "Alfa Romeo", "Maserati", "Mercedes", "Ferrari" }));
_racers.Add(new Racer("Mike", "Hawthorn", "UK", 45, 3, new int[] { 1958 }, new string[] { "Ferrari" }));
_racers.Add(new Racer("Phil", "Hill", "USA", 48, 3, new int[] { 1961 }, new string[] { "Ferrari" }));
_racers.Add(new Racer("John", "Surtees", "UK", 111, 6, new int[] { 1964 }, new string[] { "Ferrari" }));
_racers.Add(new Racer("Jim", "Clark", "UK", 72, 25, new int[] { 1963, 1965 }, new string[] { "Lotus" }));
_racers.Add(new Racer("Jack", "Brabham", "Australia", 125, 14, new int[] { 1959, 1960, 1966 }, new string[] { "Cooper", "Brabham" }));
_racers.Add(new Racer("Denny", "Hulme", "New Zealand", 112, 8, new int[] { 1967 }, new string[] { "Brabham" }));
_racers.Add(new Racer("Graham", "Hill", "UK", 176, 14, new int[] { 1962, 1968 }, new string[] { "BRM", "Lotus" }));
_racers.Add(new Racer("Jochen", "Rindt", "Austria", 60, 6, new int[] { 1970 }, new string[] { "Lotus" }));
_racers.Add(new Racer("Jackie", "Stewart", "UK", 99, 27, new int[] { 1969, 1971, 1973 }, new string[] { "Matra", "Tyrrell" }));
_racers.Add(new Racer("Emerson", "Fittipaldi", "Brazil", 143, 14, new int[] { 1972, 1974 }, new string[] { "Lotus", "McLaren" }));
_racers.Add(new Racer("James", "Hunt", "UK", 91, 10, new int[] { 1976 }, new string[] { "McLaren" }));
_racers.Add(new Racer("Mario", "Andretti", "USA", 128, 12, new int[] { 1978 }, new string[] { "Lotus" }));
_racers.Add(new Racer("Jody", "Scheckter", "South Africa", 112, 10, new int[] { 1979 }, new string[] { "Ferrari" }));
_racers.Add(new Racer("Alan", "Jones", "Australia", 115, 12, new int[] { 1980 }, new string[] { "Williams" }));
_racers.Add(new Racer("Keke", "Rosberg", "Finland", 114, 5, new int[] { 1982 }, new string[] { "Williams" }));
_racers.Add(new Racer("Niki", "Lauda", "Austria", 173, 25, new int[] { 1975, 1977, 1984 }, new string[] { "Ferrari", "McLaren" }));
_racers.Add(new Racer("Nelson", "Piquet", "Brazil", 204, 23, new int[] { 1981, 1983, 1987 }, new string[] { "Brabham", "Williams" }));
_racers.Add(new Racer("Ayrton", "Senna", "Brazil", 161, 41, new int[] { 1988, 1990, 1991 }, new string[] { "McLaren" }));
_racers.Add(new Racer("Nigel", "Mansell", "UK", 187, 31, new int[] { 1992 }, new string[] { "Williams" }));
_racers.Add(new Racer("Alain", "Prost", "France", 197, 51, new int[] { 1985, 1986, 1989, 1993 }, new string[] { "McLaren", "Williams" }));
_racers.Add(new Racer("Damon", "Hill", "UK", 114, 22, new int[] { 1996 }, new string[] { "Williams" }));
_racers.Add(new Racer("Jacques", "Villeneuve", "Canada", 165, 11, new int[] { 1997 }, new string[] { "Williams" }));
_racers.Add(new Racer("Mika", "Hakkinen", "Finland", 160, 20, new int[] { 1998, 1999 }, new string[] { "McLaren" }));
_racers.Add(new Racer("Michael", "Schumacher", "Germany", 287, 91, new int[] { 1994, 1995, 2000, 2001, 2002, 2003, 2004 }, new string[] { "Benetton", "Ferrari" }));
_racers.Add(new Racer("Fernando", "Alonso", "Spain", 273, 33, new int[] { 2005, 2006 }, new string[] { "Renault" }));
_racers.Add(new Racer("Kimi", "Räikkönen", "Finland", 253, 20, new int[] { 2007 }, new string[] { "Ferrari" }));
_racers.Add(new Racer("Lewis", "Hamilton", "UK", 189, 53, new int[] { 2008, 2014, 2015 }, new string[] { "McLaren", "Mercedes" }));
_racers.Add(new Racer("Jenson", "Button", "UK", 306, 16, new int[] { 2009 }, new string[] { "Brawn GP" }));
_racers.Add(new Racer("Sebastian", "Vettel", "Germany", 179, 42, new int[] { 2010, 2011, 2012, 2013 }, new string[] { "Red Bull Racing" }));
_racers.Add(new Racer("Nico", "Rosberg", "Germany", 207, 24, new int[] { 2016 }, new string[] { "Mercedes" }));
}
return _racers;
}
private static List<Team> _teams;
public static IList<Team> GetConstructorChampions()
{
if (_teams == null)
{
_teams = new List<Team>()
{
new Team("Vanwall", 1958),
new Team("Cooper", 1959, 1960),
new Team("Ferrari", 1961, 1964, 1975, 1976, 1977, 1979, 1982, 1983, 1999, 2000, 2001, 2002, 2003, 2004, 2007, 2008),
new Team("BRM", 1962),
new Team("Lotus", 1963, 1965, 1968, 1970, 1972, 1973, 1978),
new Team("Brabham", 1966, 1967),
new Team("Matra", 1969),
new Team("Tyrrell", 1971),
new Team("McLaren", 1974, 1984, 1985, 1988, 1989, 1990, 1991, 1998),
new Team("Williams", 1980, 1981, 1986, 1987, 1992, 1993, 1994, 1996, 1997),
new Team("Benetton", 1995),
new Team("Renault", 2005, 2006 ),
new Team("Brawn GP", 2009),
new Team("Red Bull Racing", 2010, 2011, 2012, 2013),
new Team("Mercedes", 2014, 2015, 2016)
};
}
return _teams;
}
private static List<Championship> _championships;
public static IEnumerable<Championship> GetChampionships()
{
if (_championships == null)
{
_championships = new List<Championship>();
_championships.Add(new Championship
{
Year = 1950,
First = "Nino Farina",
Second = "Juan Manuel Fangio",
Third = "Luigi Fagioli"
});
_championships.Add(new Championship
{
Year = 1951,
First = "Juan Manuel Fangio",
Second = "Alberto Ascari",
Third = "Froilan Gonzalez"
});
_championships.Add(new Championship
{
Year = 1952,
First = "Alberto Ascari",
Second = "Nino Farina",
Third = "Piero Taruffi"
});
_championships.Add(new Championship
{
Year = 1953,
First = "Alberto Ascari",
Second = "Juan Manuel Fangio",
Third = "Nino Farina"
});
_championships.Add(new Championship
{
Year = 1954,
First = "Juan Manuel Fangio",
Second = "Froilan Gonzalez",
Third = "Mike Hawthorn"
});
_championships.Add(new Championship
{
Year = 1955,
First = "Juan Manuel Fangio",
Second = "Stirling Moss",
Third = "Eugenio Castellotti"
});
_championships.Add(new Championship
{
Year = 1956,
First = "Juan Manuel Fangio",
Second = "Stirling Moss",
Third = "Peter Collins"
});
_championships.Add(new Championship
{
Year = 1957,
First = "Juan Manuel Fangio",
Second = "Stirling Moss",
Third = "Luigi Musso"
});
_championships.Add(new Championship
{
Year = 1958,
First = "Mike Hawthorn",
Second = "Stirling Moss",
Third = "Tony Brooks"
});
_championships.Add(new Championship
{
Year = 1959,
First = "Jack Brabham",
Second = "Tony Brooks",
Third = "Stirling Moss"
});
_championships.Add(new Championship
{
Year = 1960,
First = "Jack Brabham",
Second = "Bruce McLaren",
Third = "Stirling Moss"
});
_championships.Add(new Championship
{
Year = 1961,
First = "Phil Hill",
Second = "Wolfgang von Trips",
Third = "Stirling Moss"
});
_championships.Add(new Championship
{
Year = 1962,
First = "Graham Hill",
Second = "Jim Clark",
Third = "Bruce McLaren"
});
_championships.Add(new Championship
{
Year = 1963,
First = "Jim Clark",
Second = "Graham Hill",
Third = "Richie Ginther"
});
_championships.Add(new Championship
{
Year = 1964,
First = "John Surtees",
Second = "Graham Hill",
Third = "Jim Clark"
});
_championships.Add(new Championship
{
Year = 1965,
First = "Jim Clark",
Second = "Graham Hill",
Third = "Jackie Stewart"
});
_championships.Add(new Championship
{
Year = 1966,
First = "Jack Brabham",
Second = "John Surtees",
Third = "Jochen Rindt"
});
_championships.Add(new Championship
{
Year = 1967,
First = "Dennis Hulme",
Second = "Jack Brabham",
Third = "Jim Clark"
});
_championships.Add(new Championship
{
Year = 1968,
First = "Graham Hill",
Second = "Jackie Stewart",
Third = "Dennis Hulme"
});
_championships.Add(new Championship
{
Year = 1969,
First = "Jackie Stewart",
Second = "Jackie Ickx",
Third = "Bruce McLaren"
});
_championships.Add(new Championship
{
Year = 1970,
First = "Jochen Rindt",
Second = "Jackie Ickx",
Third = "Clay Regazzoni"
});
_championships.Add(new Championship
{
Year = 1971,
First = "Jackie Stewart",
Second = "Ronnie Peterson",
Third = "Francois Cevert"
});
_championships.Add(new Championship
{
Year = 1972,
First = "Emerson Fittipaldi",
Second = "Jackie Stewart",
Third = "Dennis Hulme"
});
_championships.Add(new Championship
{
Year = 1973,
First = "Jackie Stewart",
Second = "Emerson Fittipaldi",
Third = "Ronnie Peterson"
});
_championships.Add(new Championship
{
Year = 1974,
First = "Emerson Fittipaldi",
Second = "Clay Regazzoni",
Third = "Jody Scheckter"
});
_championships.Add(new Championship
{
Year = 1975,
First = "Niki Lauda",
Second = "Emerson Fittipaldi",
Third = "Carlos Reutemann"
});
_championships.Add(new Championship
{
Year = 1976,
First = "James Hunt",
Second = "Niki Lauda",
Third = "Jody Scheckter"
});
_championships.Add(new Championship
{
Year = 1977,
First = "Niki Lauda",
Second = "Jody Scheckter",
Third = "Mario Andretti"
});
_championships.Add(new Championship
{
Year = 1978,
First = "Mario Andretti",
Second = "Ronnie Peterson",
Third = "Carlos Reutemann"
});
_championships.Add(new Championship
{
Year = 1979,
First = "Jody Scheckter",
Second = "Gilles Villeneuve",
Third = "Alan Jones"
});
_championships.Add(new Championship
{
Year = 1980,
First = "Alan Jones",
Second = "Nelson Piquet",
Third = "Carlos Reutemann"
});
_championships.Add(new Championship
{
Year = 1981,
First = "Nelson Piquet",
Second = "Carlos Reutemann",
Third = "Alan Jones"
});
_championships.Add(new Championship
{
Year = 1982,
First = "Keke Rosberg",
Second = "Didier Pironi",
Third = "John Watson"
});
_championships.Add(new Championship
{
Year = 1983,
First = "Nelson Piquet",
Second = "Alain Prost",
Third = "Rene Arnoux"
});
_championships.Add(new Championship
{
Year = 1984,
First = "Niki Lauda",
Second = "Alain Prost",
Third = "Elio de Angelis"
});
_championships.Add(new Championship
{
Year = 1985,
First = "Alain Prost",
Second = "Michele Alboreto",
Third = "Keke Rosberg"
});
_championships.Add(new Championship
{
Year = 1986,
First = "Alain Prost",
Second = "Nigel Mansell",
Third = "Nelson Piquet"
});
_championships.Add(new Championship
{
Year = 1987,
First = "Nelson Piquet",
Second = "Nigel Mansell",
Third = "Ayrton Senna"
});
_championships.Add(new Championship
{
Year = 1988,
First = "Ayrton Senna",
Second = "Alain Prost",
Third = "Gerhard Berger"
});
_championships.Add(new Championship
{
Year = 1989,
First = "Alain Prost",
Second = "Ayrton Senna",
Third = "Riccardo Patrese"
});
_championships.Add(new Championship
{
Year = 1990,
First = "Ayrton Senna",
Second = "Alain Prost",
Third = "Nelson Piquet"
});
_championships.Add(new Championship
{
Year = 1991,
First = "Ayrton Senna",
Second = "Nigel Mansell",
Third = "Riccardo Patrese"
});
_championships.Add(new Championship
{
Year = 1992,
First = "Nigel Mansell",
Second = "Riccardo Patrese",
Third = "Michael Schumacher"
});
_championships.Add(new Championship
{
Year = 1993,
First = "Alain Prost",
Second = "Ayrton Senna",
Third = "Damon Hill"
});
_championships.Add(new Championship
{
Year = 1994,
First = "Michael Schumacher",
Second = "Damon Hill",
Third = "Gerhard Berger"
});
_championships.Add(new Championship
{
Year = 1995,
First = "Michael Schumacher",
Second = "Damon Hill",
Third = "David Coulthard"
});
_championships.Add(new Championship
{
Year = 1996,
First = "Damon Hill",
Second = "Jacques Villeneuve",
Third = "Michael Schumacher"
});
_championships.Add(new Championship
{
Year = 1997,
First = "Jacques Villeneuve",
Second = "Heinz-Harald Frentzen",
Third = "David Coulthard"
});
_championships.Add(new Championship
{
Year = 1998,
First = "Mika Hakkinen",
Second = "Michael Schumacher",
Third = "David Coulthard"
});
_championships.Add(new Championship
{
Year = 1999,
First = "Mika Hakkinen",
Second = "Eddie Irvine",
Third = "Heinz-Harald Frentzen"
});
_championships.Add(new Championship
{
Year = 2000,
First = "Michael Schumacher",
Second = "Mika Hakkinen",
Third = "David Coulthard"
});
_championships.Add(new Championship
{
Year = 2001,
First = "Michael Schumacher",
Second = "David Coulthard",
Third = "Rubens Barrichello"
});
_championships.Add(new Championship
{
Year = 2002,
First = "Michael Schumacher",
Second = "Rubens Barrichello",
Third = "Juan Pablo Montoya"
});
_championships.Add(new Championship
{
Year = 2003,
First = "Michael Schumacher",
Second = "Kimi Räikkönen",
Third = "Juan Pablo Montoya"
});
_championships.Add(new Championship
{
Year = 2004,
First = "Michael Schumacher",
Second = "Rubens Barrichello",
Third = "Jenson Button"
});
_championships.Add(new Championship
{
Year = 2005,
First = "Fernando Alonso",
Second = "Kimi Räikkönen",
Third = "Michael Schumacher"
});
_championships.Add(new Championship
{
Year = 2006,
First = "Fernando Alonso",
Second = "Michael Schumacher",
Third = "Felipe Massa"
});
_championships.Add(new Championship
{
Year = 2007,
First = "Kimi Räikkönen",
Second = "Lewis Hamilton",
Third = "Fernando Alonso"
});
_championships.Add(new Championship
{
Year = 2008,
First = "Lewis Hamilton",
Second = "Felipe Massa",
Third = "Kimi Raikkonen"
});
_championships.Add(new Championship
{
Year = 2009,
First = "Jenson Button",
Second = "Sebastian Vettel",
Third = "Rubens Barrichello"
});
_championships.Add(new Championship
{
Year = 2010,
First = "Sebastian Vettel",
Second = "Fernando Alonso",
Third = "Mark Webber"
});
_championships.Add(new Championship
{
Year = 2011,
First = "Sebastian Vettel",
Second = "Jenson Button",
Third = "Mark Webber"
});
_championships.Add(new Championship
{
Year = 2012,
First = "Sebastian Vettel",
Second = "Fernando Alonso",
Third = "Kimi Raikkonen"
});
_championships.Add(new Championship
{
Year = 2013,
First = "Sebastian Vettel",
Second = "Fernando Alonso",
Third = "Mark Webber"
});
_championships.Add(new Championship
{
Year = 2014,
First = "Lewis Hamilton",
Second = "Nico Rosberg",
Third = "Daniel Ricciardo"
});
_championships.Add(new Championship
{
Year = 2015,
First = "Lewis Hamilton",
Second = "Nico Rosberg",
Third = "Sebastian Vettel"
});
_championships.Add(new Championship
{
Year = 2016,
First = "Nico Rosberg",
Second = "Lewis Hamilton",
Third = "Daniel Ricciardo"
});
}
return _championships;
}
private static IList<Racer> _moreRacers;
private static IList<Racer> GetMoreRacers()
{
if (_moreRacers == null)
{
_moreRacers = new List<Racer>();
_moreRacers.Add(new Racer("Luigi", "Fagioli", "Italy", starts: 7, wins: 1));
_moreRacers.Add(new Racer("Jose Froilan", "Gonzalez", "Argentina", starts: 26, wins: 2));
_moreRacers.Add(new Racer("Piero", "Taruffi", "Italy", starts: 18, wins: 1));
_moreRacers.Add(new Racer("Stirling", "Moss", "UK", starts: 66, wins: 16));
_moreRacers.Add(new Racer("Eugenio", "Castellotti", "Italy", starts: 14, wins: 0));
_moreRacers.Add(new Racer("Peter", "Collins", "UK", starts: 32, wins: 3));
_moreRacers.Add(new Racer("Luigi", "Musso", "Italy", starts: 24, wins: 1));
_moreRacers.Add(new Racer("Tony", "Brooks", "UK", starts: 38, wins: 6));
_moreRacers.Add(new Racer("Bruce", "McLaren", "New Zealand", starts: 100, wins: 4));
_moreRacers.Add(new Racer("Wolfgang von", "Trips", "Germany", starts: 27, wins: 2));
_moreRacers.Add(new Racer("Richie", "Ginther", "USA", starts: 52, wins: 1));
_moreRacers.Add(new Racer("Jackie", "Ickx", "Belgium", starts: 116, wins: 8));
_moreRacers.Add(new Racer("Clay", "Regazzoni", "Switzerland", starts: 132, wins: 5));
_moreRacers.Add(new Racer("Ronnie", "Peterson", "Sweden", starts: 123, wins: 10));
_moreRacers.Add(new Racer("Francois", "Cevert", "France", starts: 46, wins: 1));
_moreRacers.Add(new Racer("Carlos", "Reutemann", "Argentina", starts: 146, wins: 12));
_moreRacers.Add(new Racer("Gilles", "Villeneuve", "Canada", starts: 67, wins: 6));
_moreRacers.Add(new Racer("Didier", "Pironi", "France", starts: 70, wins: 3));
_moreRacers.Add(new Racer("John", "Watson", "UK", starts: 152, wins: 5));
_moreRacers.Add(new Racer("Rene", "Arnoux", "France", starts: 149, wins: 7));
_moreRacers.Add(new Racer("Elio", "de Angelis", "Italy", starts: 108, wins: 2));
_moreRacers.Add(new Racer("Michele", "Alboreto", "Italy", starts: 194, wins: 5));
_moreRacers.Add(new Racer("Gerhard", "Berger", "Austria", starts: 210, wins: 10));
_moreRacers.Add(new Racer("Riccardo", "Patrese", "Italy", starts: 256, wins: 6));
_moreRacers.Add(new Racer("David", "Coulthard", "UK", starts: 246, wins: 13));
_moreRacers.Add(new Racer("Heinz-Harald", "Frentzen", "Germany", starts: 156, wins: 3));
_moreRacers.Add(new Racer("Eddie", "Irvine", "UK", starts: 147, wins: 4));
_moreRacers.Add(new Racer("Rubens", "Barrichello", "Brazil", starts: 322, wins: 11));
_moreRacers.Add(new Racer("Juan Pablo", "Montoya", "Columbia", starts: 94, wins: 7));
_moreRacers.Add(new Racer("Felipe", "Massa", "Brazil", starts: 251, wins: 11));
_moreRacers.Add(new Racer("Mark", "Webber", "Australia", starts: 215, wins: 9));
_moreRacers.Add(new Racer("Daniel", "Ricciardo", "Australia", starts: 109, wins: 4));
}
return _moreRacers;
}
}Linq查询
static void LINQQuery()
{
var query = from r in Formula1.GetChampions()
where r.Country == "Brazil"
orderby r.Wins descending
select r;
foreach (var r in query)
{
WriteLine($"{r:A}");
}
WriteLine();
}输出结果
Ayrton senna, Brazil; starts: 161, wins: 41 Nelson Piquet, Brazil; starts: 204, wins: 23 Emerson Fittipaldi, Brazil; starts: 143, wins: 14扩展方法
public static class StringExtension
{
public static void Foo(this string s)
{
WriteLine($"Foo invoked for {s}");
}
}可以这样写
string s = "Hello";
s.Foo();也可以这样写
string s = "Hello";
StringExtension.Foo(s);Linq 的 where
public static IEnumerable<TSource> Where<TSource>(this IEnumerable<TSource> source,Func<TSource,boll> predicate)
{
foreach(TSource item in source)
if(predicate(item))
yield return item;
}使用定义委托的匿名方法
static void ExtensionMethods()
{
var champions = new List<Racer>(Formula1.GetChampions());
IEnumerable<Racer> brazilChampions =
champions.Where(r => r.Country == "Brazil").
OrderByDescending(r => r.Wins).
Select(r => r);
foreach (Racer r in brazilChampions)
{
WriteLine($"{r:A}");
}
WriteLine();
}推迟查询的执行
在运行期间定义查询表达式时，查询就不会运行。查询会在迭代数据项时运行。