Videos using LINQ (Part 1) in Visual Studio orcas and ASP. NET

[Original address] video: using LINQ with ASP. NET in vs "orcas" (Part 1)
[Original article publication date] Sunday, January 28,200

One of my goals this year is to use multiple videos in my blog. In my opinion, many times, videos are better media than texts to demonstrate how something works, it can also help you avoid being dull, monotonous, and boring due to reading some of my long blog posts...

In the next few months, I will try to create a new video on various topics every other week. Many of these recordings will cover a new version of the features that come with Visual Studio orcas later this year. As for today's video, I decided to focus on LINQ, which I think is one of the most exciting features that come with orcas.

At a high level, LINQ makes the query concept a programming concept of first class in. net. By using LINQ, you can easily query relational databases, XML files, and any common. Net objects. You can also easily use your own data source abstraction in LINQ to provide a wide range of Domain Models for various data providers ). If you want to see a wonderful example, refer to the implementation of LINQ from fabrice to Amazon. This example supports the query of the Amazon data presented through web-service. As part of the release of orcas, both VB and C # provide a wide range of language-level integration with LINQ, including full intelliisense, checking during compilation, and debugging support.

Watch or download the video

The first video starts from a new project, and then demonstrates the basic knowledge of creating a simple data report webpage for a SQL database using LINQ, containing the aggregate values calculated from multiple data tables, and paging support for highly efficient server-side databases.

You can watch this video online here (the total length is 24 minutes ). Or you can download a. Zip version here if you want to save it locally. Note that it may take 30-60 seconds to cache because it is a large video. In case my server is overwhelmed by too many requests, I will update the website later this week and release it to a Microsoft Video Server.

If you want to learn more about LINQ, including my own "using LINQ to create a data-driven ASP. NET application "lecture handout And Demo code, please refer to one of my previous posts here. For other ASP. NET 2.0 tips, tips, and tutorials, check my ASP. NET Tips/TIPS summary page.

Topic details discussed in this video

The demonstration in this video illustrates several new features:

1) A brief demonstration of some features of the new wysiwyg html designer (including the split interface and a brief introduction to the new CSS Manager, I will discuss the two in detail in another video ):

2) how to use the new ORM designer from the LINQ to SQL in vs orcas to create a class for model data:

3) how to use the new LINQ intelliisense support in the vs orcas code editor to get full support for intelliisense and compilation for queries:

4) how to create a data report that combines the product entity data with the orderdetail entity associated with the product entity and the aggregate unit and income value. This data report uses the database page of the server to efficiently retrieve only 10 rows of records (in this way, no matter which page your report points to for a 100,000-row product table, you can only retrieve 10 rows of data from the database at a time ):

Future videos

In the future video, I will make some more in-depth discussions on LINQ. In this video, I just touched the surface. Other parts will include the following content:

• Type inference and keyword VAR (and why is it so cool)
• Insert, update, and delete operations are supported by using LINQ to SQL.
• Validation rules and logic in the LINQ Data Model
• Use stored procedures in LINQ to SQL
• More abundant support for join in LINQ to SQL
• From LINQ to XML and from LINQ to object
• Use the new linqdatasource control and other ASP. NET data controls to easily create a web UI

Obviously, I will also have more ASP. NET and web-related videos, including:

• New wysiwyg html designer and CSS support
• Client JavaScript intelliisense
• Javascript debugging
• Support for ASP. NET Ajax extenders (Extender)
• Database backup and upload Integration
• Unit Test
• Multi-targeting (demonstrate how to use vs orcas to build an ASP. NET 2.0 project without updating your framework and server)