.NET Tip: Where Is Your Data Coming From? Superior WI

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

Winter Systems Computers
(715) 394-9262
2829 Banks Ave
Superior, WI
Et Alia
(414) 342-4030
2460 W Clybourn St
Milwaukee, WI
Progressive Data Systems
(608) 836-5075
Middleton, WI
Brown Associates
(414) 764-9511
427 E Stewart St
Milwaukee, WI
Financial Data Management
(608) 588-7611
E5646 Jones Rd
Spring Green, WI
Compuware Corp
(608) 223-3800
200 River Pl Ste 100
Monona, WI
Moraine Data Consultants
(262) 338-2110
904 Mulberry Dr E
West Bend, WI
Integrated Solutions
(920) 731-1179
1430 E Wisconsin Ave
Appleton, WI
Comprehensive Computer Consulting
(608) 837-8600
1500 W Main St Ste 100
Sun Prairie, WI
Tos Computer Systems
(920) 437-9133
1270 Main St
Green Bay, WI

.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 National Company

Bell Rock Solutions

480-595-8980
8518 E. High Point Drive
Scottsdale, AZ
www.bellrocksolutions.com

Related Articles
- Attunity Stream Client/Server Platform Superior WI
Change Data Capture (CDC) platform seeks to accelerate ETL and/or data integration processes by capturing and reporting only changes in data sources. Now supports continuous (real-time) change data reporting for SQL queries.
- DB Data Generator Superior WI
- Sybase Data Integration Suite Superior WI
- Data Secure Encryption Platform Superior WI
- GURA Object Director and Data Gate Superior WI
- ADRC Data Recovery Tools Superior WI
- Purisma Data Hub Superior WI
- Downloaded Data Guard Superior WI
- Data Profiler Superior WI
Related Articles
- Attunity Stream Client/Server Platform Superior WI
Change Data Capture (CDC) platform seeks to accelerate ETL and/or data integration processes by capturing and reporting only changes in data sources. Now supports continuous (real-time) change data reporting for SQL queries.
- DB Data Generator Superior WI
- Sybase Data Integration Suite Superior WI
- Data Secure Encryption Platform Superior WI
- GURA Object Director and Data Gate Superior WI
- ADRC Data Recovery Tools Superior WI
- Purisma Data Hub Superior WI
- Downloaded Data Guard Superior WI
- Data Profiler Superior WI
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