Section 4.4 LINQ – Microsoft Language-Integrated Query

Learning Objectives

After you have completed this section, you should be able to

• explain the fundamental concepts of LINQ.
• prepare to use databases in ASP.NET with C# or VB web applications.

Activities

• Carefully read the learning objectives.
• Watch the related section of the presentation for Chapter 18;
• Read sections 18.6, Microsoft Language Integrate Query (LINQ)through18.9, Dynamically Binding LINQ to SQL Query Results of Chapter 18.
• Find answers to the study questions below.
• Try to work through the Figure 18.36 example in Deitel, especially if you choose to do Assignment 3A.

Study Questions

1. What is LINQ?
2. What are the differences between SQL and LINQ?
3. What can you do using LINQ to SQL classes?
4. With LINQ, how do you query an array of int values?
5. In a LINQ query, what does the FROM clause do?
6. In a LINQ query, what does the WHERE clause do?
7. In a LINQ query, what does the SELECT clause do?
8. In LINQ, how do you iterate through the results of a LINQ query with a foreach statement?
9. In a LINQ query, what does the ORDERBY clause do ?
10. What are implicitly typed local variables?
11. With LINQ, how do you query an array of objects?
12. In LINQ, how do you sort of the result of a LINQ query?
13. With LINQ, how do you query a generic collection?
14. What is “LINQ to SQL”?
15. How do you use LINQ to access data in SQL server databases?
16. How do you query a database with LINQ?
17. How do bind data between (web) controls and the LINQ to SQL classes?
18. How do you bind (web) controls to LINQ to SQL query results dynamically?

Summary

Read the Chapter 18 summary.