.NET Tip: Where Is Your Data Coming From? Antioch CA

LINQ can be used for much more than just accessing data stored in your database. Learn how you can use the from clause with other types of data.

Local Companies

Exadel
925 602 5571
1850 Gateway Blvd.
Concord, CA
e-Zest Inc.
+1 415 806 0340
1555 Riviera Ave, #324
Walnut Creek, AK
Bennett Consulting
925-705-1812
Po Box 523
Alamo, CA
SpbCreative
925/7889315
1537 Boulevard Way
Walnut Creek, CA
Appian Analytics
510-710-9199
2000 Crow Canyon Place Suite 300
San Ramon, CA
Heinsua Computer Consulting Service
(925) 754-6453
5149 Arroyo Way
Antioch, CA
Corporate Network Planning Inc
(925) 777-0130
Antioch, CA
Computer Support Source
(925) 776-4776
2716 Lobelia Ct
Antioch, CA
Shoestring Consulting
(925) 978-7463
3025 Butternut St
Antioch, CA
C A D Services
(714) 638-4737
11922 Seacrest Dr Ste F
Garden Grove, CA

.NET Tip: Where Is Your Data Coming From?

provided by: 
Originally published at Internet.com


LINQ to Objects allows you to use LINQ queries with any object that support IEnumerable or IEnumerable(T). This means that you can use LINQ to acccess data in arrays, lists, dictionaries, and other collections. You also can use LINQ with any of your own classes that implement or inherit IEnumerable. Let me start with a very simple introduction using an array of integers. This following example uses LINQ to find all of the even integers in an array of integers: // Array of data int[] Data = { 17, 32, 51, 98, 87, 4, 63, 26, 75, 40 }; // Create the variable to store the query var EvenNumbers = from Num in Data where Num % 2 == 0 select Num; // Run the query and output the results foreach (int i in EvenNumbers) Debug.Print(i.ToString());

Data is simply an integer array. The only thing important about it is that arrays implement IEnumerable so LINQ can be used with them. The statement of interest in this example is the definition of EvenNumbers. The from clause is used to define a subset of the elements in Data. Num is called the range variable and is used to represent each element from the data source. The where clause is used here to include only those numbers that are evenly divisible by 2, eliminating all odd numbers. The select clause indicates what information about each Num should be included for each matching element. In this case, the number itself is being selected. One point to note is that at this point the query has not been executed. EvenNumbers is simply a definition of the query. The query is not actually processed until it is used in the foreach loop that follows. The piece is the foreach loop that iterates over the EvenNumbers query and prints out each included element. The result is the following: 32 98 4 26 40

I hope this whets your appetite for what LINQ can do and will help you to think about where you can use LINQ in your application. LINQ allows you to use a SQL-like syntax for working with your data outside of the database.

About the Author

Jay Miller is a Software Engineer with Electronic Tracking Systems, a company dedicated to robbery prevention, apprehension, and recovery based in Carrollton, Texas. Jay has been working with .NET since the release of the first beta and is co-author of Learn Microsoft Visual Basic.Net In a Weekend. Jay can be reached via email at jmiller@sm-ets.com.

Author: Jay Miller

Read article at Internet.com site

Featured Local Company

Exadel

925 602 5571
1850 Gateway Blvd.
Concord, CA
www.exadel.com

Related Local Events
OMG Technical Meeting
Dates: 12/8/2008 - 12/12/2008
Location: Hyatt Regency
Santa Clara CA
View Details

Macworld Conference & Expo 2009
Dates: 1/5/2009 - 1/9/2009
Location: Moscone Center
San Francisco CA
View Details

Macworld Expo
Dates: 1/5/2009 - 1/9/2009
Location:
San Francisco CA
View Details

Macworld Conference & Expo 2009
Dates: 1/5/2009 - 1/9/2009
Location: Moscone Center North
San Francisco CA
View Details

SPIE's Photonics West 2009
Dates: 1/24/2009 - 1/29/2009
Location: San Jose Convention Center
San Jose CA
View Details
Rate Article
     
Articles Insider

Rss   Delicious   Digg   Add To My Yahoo   Add To My Google   Bookmark   Search Plugin

Topics:
Advertising Engineering Home Services Retail & Consumer Services
Business Services Entertainment Industrial Goods & Services Software
Career Family Insurance Technology
Cars Financial Services Internet Telecommunications
Computer Hardware Food & Beverage Legal Transportation & Logistics
Construction Health Pets Travel
Education Home Electronics Real Estate Wedding