How to use LINQ to query results

This article mainly introduces how to use LINQ query results, has a certain reference value, interested friends can refer to, I hope you can learn a lot after reading this article, the following let the editor take you to understand it.

Query results using LINQ

If the query results are strongly typed, such as string [], List, etc., you can use the appropriate IEnumerable or IEnumerable type instead of the var type (because IEnumerable also extends IEnumerable).

Class Program {static void Main (string [] args) {Console.WriteLine ("* LINQ Transformations *" n "); IEnumerable subset = GetStringSubset (); foreach (string item in subset) {Console.WriteLine (item);} Console.ReadLine ();} static IEnumerable GetStringSubset () {string [] currentVideoGames = {" Morrowind "," BioShock "," Half Life 2: Episode 1 "," The Darkness "," Daxter "," System Shock 2 "} / / Note subset is an IEnumerable compatible object. IEnumerable subset = from g in currentVideoGames where g.Length > 6 orderby g select g; return subset;}}

Paging processing of query results using LINQ:

Var custTotalOrders = from c in db.D_WorkCenter / / join oin db.Orders / / on c.CustomerID equals o.CustomerID into custOrders / / from oin custOrders select new {WorkCenterID = c.WorkCenterID, WorkCenterName = c.WorkCenterName / / OrderTotal = o.Order_Details.Sum (d = > d.UnitPrice * d.Quantity)} Thank you for reading this article carefully. I hope the article "how to use LINQ query results" shared by the editor will be helpful to you. At the same time, I also hope that you will support and pay attention to the industry information channel, and more related knowledge is waiting for you to learn!