{"id":56,"date":"2013-09-12T19:56:00","date_gmt":"2013-09-13T00:56:00","guid":{"rendered":"https:\/\/www.chrystalsander.com\/blog\/?p=56"},"modified":"2023-07-26T15:58:58","modified_gmt":"2023-07-26T20:58:58","slug":"linq-query-a-class","status":"publish","type":"post","link":"https:\/\/www.chrystalsander.com\/blog\/?p=56","title":{"rendered":"LINQ : Query A Class"},"content":{"rendered":"
\nThe
\nfollowing code creates a generic list based on a custom class and
\nthen performs a LINQ query:<\/span><\/span><\/div>\n
\n<\/div>\n
\n\/\/Declare List Object<\/span><\/div>\n
\npublic<\/span><\/span><\/span> <\/span><\/span><\/span>static<\/span><\/span><\/span> <\/span><\/span><\/span>List<\/span><\/span><\/span><<\/span><\/span><\/span>GPRider<\/span><\/span><\/span>> riderList;<\/span><\/span><\/span><\/span><\/span><\/div>\n
\n
<\/span><\/span><\/span><\/span><\/span><\/div>\n
\n\/\/Declare Class Object<\/span><\/div>\n
\npublic<\/span><\/span><\/span> <\/span><\/span><\/span>class<\/span><\/span><\/span> <\/span><\/span><\/span>GPRider<\/span><\/span><\/span><\/span><\/span><\/div>\n
\n{<\/span><\/span><\/span><\/span><\/span><\/div>\n
\n    <\/span>public<\/span><\/span><\/span> <\/span><\/span><\/span>int<\/span><\/span><\/span> Number { <\/span><\/span><\/span>get<\/span><\/span><\/span>; <\/span><\/span><\/span>set<\/span><\/span><\/span>; }<\/span><\/span><\/span><\/span><\/span><\/div>\n
\n    <\/span>public<\/span><\/span><\/span> <\/span><\/span><\/span>string<\/span><\/span><\/span> FirstName { <\/span><\/span><\/span>get<\/span><\/span><\/span>; <\/span><\/span><\/span>set<\/span><\/span><\/span>; }<\/span><\/span><\/span><\/span><\/span><\/div>\n
\n    <\/span>public<\/span><\/span><\/span> <\/span><\/span><\/span>string<\/span><\/span><\/span> LastName { <\/span><\/span><\/span>get<\/span><\/span><\/span>; <\/span><\/span><\/span>set<\/span><\/span><\/span>; }<\/span><\/span><\/span><\/span><\/span><\/div>\n
\n    <\/span>public<\/span><\/span><\/span> <\/span><\/span><\/span>string<\/span><\/span><\/span> Team { <\/span><\/span><\/span>get<\/span><\/span><\/span>; <\/span><\/span><\/span>set<\/span><\/span><\/span>; }<\/span><\/span><\/span><\/span><\/span><\/div>\n
\n    <\/span>public<\/span><\/span><\/span> <\/span><\/span><\/span>string<\/span><\/span><\/span> BikeMake { <\/span><\/span><\/span>get<\/span><\/span><\/span>; <\/span><\/span><\/span>set<\/span><\/span><\/span>; }<\/span><\/span><\/span><\/span><\/span><\/div>\n
\n    <\/span>public<\/span><\/span><\/span> <\/span><\/span><\/span>string<\/span><\/span><\/span> BikeModel { <\/span><\/span><\/span>get<\/span><\/span><\/span>; <\/span><\/span><\/span>set<\/span><\/span><\/span>; }<\/span><\/span><\/span><\/span><\/span><\/div>\n
\n}<\/span><\/span><\/span><\/span><\/span><\/div>\n
\n
<\/span><\/span><\/span><\/span><\/span><\/div>\n
\n\/\/Create Data To Be Used<\/span><\/div>\n
\npublic<\/span><\/span><\/span> <\/span><\/span><\/span>static<\/span><\/span><\/span> <\/span><\/span><\/span>void<\/span><\/span><\/span> createRiders()<\/span><\/span><\/span><\/span><\/span><\/div>\n
\n{<\/span><\/span><\/span><\/span><\/span><\/div>\n
\n    riderList = <\/span><\/span><\/span>new<\/span><\/span><\/span> <\/span><\/span><\/span>List<\/span><\/span><\/span><<\/span><\/span><\/span>GPRider<\/span><\/span><\/span>>{<\/span><\/span><\/span><\/span><\/span><\/div>\n
\n    <\/span>new<\/span><\/span><\/span> <\/span><\/span><\/span>GPRider<\/span><\/span><\/span> {Number=46, FirstName=<\/span><\/span><\/span>“Valentino”<\/span><\/span><\/span>, LastName=<\/span><\/span><\/span>“Rossi”<\/span><\/span><\/span>, <\/span><\/span><\/span><\/span><\/span><\/div>\n
\n        Team=<\/span><\/span><\/span>“Factory Yamaha”<\/span><\/span><\/span>, BikeMake=<\/span><\/span><\/span>“Yamaha”<\/span><\/span><\/span>, BikeModel=<\/span><\/span><\/span>“M1”<\/span><\/span><\/span>},<\/span><\/span><\/span><\/span><\/span><\/div>\n
\n    <\/span>new<\/span><\/span><\/span> <\/span><\/span><\/span>GPRider<\/span><\/span><\/span> {Number=99, FirstName=<\/span><\/span><\/span>“Jorge”<\/span><\/span><\/span>, LastName=<\/span><\/span><\/span>“Lorenzo”<\/span><\/span><\/span>, <\/span><\/span><\/span><\/span><\/span><\/div>\n
\n        Team=<\/span><\/span><\/span>“Factory Yamaha”<\/span><\/span><\/span>, BikeMake=<\/span><\/span><\/span>“Yamaha”<\/span><\/span><\/span>, BikeModel=<\/span><\/span><\/span>“M1”<\/span><\/span><\/span>},<\/span><\/span><\/span><\/span><\/span><\/div>\n
\n    <\/span>new<\/span><\/span><\/span> <\/span><\/span><\/span>GPRider<\/span><\/span><\/span> {Number=69, FirstName=<\/span><\/span><\/span>“Nicky”<\/span><\/span><\/span>, LastName=<\/span><\/span><\/span>“Hayden”<\/span><\/span><\/span>, <\/span><\/span><\/span><\/span><\/span><\/div>\n
\n        Team=<\/span><\/span><\/span>“Factory Ducati”<\/span><\/span><\/span>, BikeMake=<\/span><\/span><\/span>“Ducati”<\/span><\/span><\/span>, BikeModel=<\/span><\/span><\/span>“DesmoGP13”<\/span><\/span><\/span>},<\/span><\/span><\/span><\/span><\/span><\/div>\n
\n    <\/span>new<\/span><\/span><\/span> <\/span><\/span><\/span>GPRider<\/span><\/span><\/span> {Number=35, FirstName =<\/span><\/span><\/span>“Cal”<\/span><\/span><\/span>, LastName=<\/span><\/span><\/span>“Crutchlow”<\/span><\/span><\/span>, <\/span><\/span><\/span><\/span><\/span><\/div>\n
\n        Team=<\/span><\/span><\/span>“Tech 3”<\/span><\/span><\/span>, BikeMake=<\/span><\/span><\/span>“Yamaha”<\/span><\/span><\/span>, BikeModel=<\/span><\/span><\/span>“M1”<\/span><\/span><\/span>}<\/span><\/span><\/span><\/span><\/span><\/div>\n
\n    };<\/span><\/span><\/span><\/span><\/span><\/div>\n
\n}<\/span><\/span><\/span><\/span><\/span><\/div>\n
\n<\/span><\/div>\n
\n<\/div>\n
\n<\/div>\n
\n\/\/Finally, LINQ Query Example For Generic List<\/span><\/span><\/span><\/span><\/span><\/div>\n
\npublic<\/span><\/span><\/span> <\/span><\/span><\/span>static<\/span><\/span><\/span> <\/span><\/span><\/span>void<\/span><\/span><\/span> RiderQuery()<\/span><\/span><\/span><\/span><\/span><\/div>\n
\n{<\/span><\/span><\/span><\/span><\/span><\/div>\n
\n    <\/span>\/\/populate the Generic List<\/span><\/span><\/span><\/span><\/span><\/div>\n
\n    createRiders();<\/span><\/span><\/span><\/span><\/span><\/div>\n
\n
<\/span><\/span><\/span><\/span><\/span><\/div>\n
\n <\/span>\n<\/div>\n
\n    <\/span>\/\/create the LINQ query<\/span><\/span><\/span><\/span><\/span><\/div>\n
\n    <\/span>var<\/span><\/span><\/span> linqQuery =<\/span><\/span><\/span><\/span><\/span><\/div>\n
\n        <\/span>from<\/span><\/span><\/span> r <\/span><\/span><\/span>in<\/span><\/span><\/span> riderList<\/span><\/span><\/span><\/span><\/span><\/div>\n
\n        <\/span>select<\/span><\/span><\/span> <\/span><\/span><\/span>new<\/span><\/span><\/span> { r.FirstName, r.LastName, r.Number, r.Team, <\/span><\/span><\/span><\/span><\/span><\/div>\n
\n            r.BikeMake, r.BikeModel };<\/span><\/span><\/span><\/span><\/span><\/div>\n
\n
<\/span><\/span><\/span><\/span><\/span><\/div>\n
\n <\/span>\n<\/div>\n
\n    <\/span>\/\/Loop through LINQ query results<\/span><\/span><\/span><\/span><\/span><\/div>\n
\n    <\/span>foreach<\/span><\/span><\/span> (<\/span><\/span><\/span>var<\/span><\/span><\/span> rider <\/span><\/span><\/span>in<\/span><\/span><\/span> linqQuery)<\/span><\/span><\/span><\/span><\/span><\/div>\n
\n    {<\/span><\/span><\/span><\/span><\/span><\/div>\n
\n        <\/span>Console<\/span><\/span><\/span>.WriteLine(<\/span><\/span><\/span>“{0} {1}, #{2}, rides a {3} {4}, for the {5} team.”<\/span><\/span><\/span>, <\/span><\/span><\/span><\/span><\/span><\/div>\n
\n            rider.FirstName, rider.LastName, rider.Number, rider.BikeMake, <\/span><\/span><\/span><\/span><\/span><\/div>\n
\n            rider.BikeModel, rider.Team);<\/span><\/span><\/span><\/span><\/span><\/div>\n
\n    }<\/span><\/span><\/span><\/span><\/span><\/div>\n
\n
<\/span><\/span><\/span><\/span><\/span><\/div>\n
\n <\/span>\n<\/div>\n
\n    <\/span>Console<\/span><\/span><\/span>.ReadLine();<\/span><\/span><\/span><\/span><\/span><\/div>\n
\n
<\/span><\/span><\/span><\/span><\/span><\/div>\n
\n}<\/span><\/span><\/span><\/span><\/span><\/div>\n
\n<\/div>\n
\n<\/div>\n

<\/p>\n

\n<\/div>\n","protected":false},"excerpt":{"rendered":"

The following code creates a generic list based on a custom class and then performs a LINQ query: \/\/Declare List Object public static List<GPRider> riderList; \/\/Declare Class Object public class GPRider {     public int Number { get; set; }     public string FirstName { get; set; }     public string LastName { get; set; }     public string Team { get; set; }     public string BikeMake { get; set; }     public string BikeModel { get; set; } } \/\/Create Data To Be Used public static void createRiders() {     riderList = new List<GPRider>{     new GPRider {Number=46, FirstName=“Valentino”, LastName=“Rossi”,          Team=“Factory Yamaha”, BikeMake=“Yamaha”, BikeModel=“M1”},     new GPRider {Number=99, FirstName=“Jorge”, LastName=“Lorenzo”,          Team=“Factory Yamaha”, BikeMake=“Yamaha”, BikeModel=“M1”},     new GPRider {Number=69, FirstName=“Nicky”, LastName=“Hayden”,          Team=“Factory Ducati”, BikeMake=“Ducati”, BikeModel=“DesmoGP13”},     new GPRider {Number=35, FirstName =“Cal”, LastName=“Crutchlow”,          Team=“Tech 3”, BikeMake=“Yamaha”, BikeModel=“M1”}     }; } \/\/Finally, LINQ Query Example For Generic List public static void RiderQuery() … Continue reading “LINQ : Query A Class”<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[33],"tags":[83],"_links":{"self":[{"href":"https:\/\/www.chrystalsander.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/56"}],"collection":[{"href":"https:\/\/www.chrystalsander.com\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.chrystalsander.com\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.chrystalsander.com\/blog\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.chrystalsander.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=56"}],"version-history":[{"count":1,"href":"https:\/\/www.chrystalsander.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/56\/revisions"}],"predecessor-version":[{"id":245,"href":"https:\/\/www.chrystalsander.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/56\/revisions\/245"}],"wp:attachment":[{"href":"https:\/\/www.chrystalsander.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=56"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.chrystalsander.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=56"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.chrystalsander.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=56"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}