Dear customers, please be informed that our shopping cart will be unavailable between August 21 and September 1, 2014, as we will be making some changes to serve you better. To minimise any possible delivery disruption, we encourage you to make your purchases before August 21. We appreciate your understanding and apologise for any inconvenience.

Wiley
Wiley.com
Print this page Share

Migrating to LINQ to SQL in TheBeerHouse and ASP.NET 2.0 Website Programming Problem Design Solution

ISBN: 978-0-470-37501-3
38 pages
March 2008
Migrating to LINQ to SQL in TheBeerHouse and ASP.NET 2.0 Website Programming Problem Design Solution (0470375019) cover image
This Wrox Blox demonstrates various LINQ to SQL techniques to use in upgrading the “Articles” portion of TheBeerHouse application. The first step is migrating TheBeerHouse project from an ASP.NET 2.0 to an ASP.NET 3.5 application. Next, create a LINQ to SQL class (DBML) mapping file that will encapsulate the entire Data Access Layer for this project. Readers will become comfortable working with Entities (Tables), navigating Associations (Relationships), and working with stored procedures from a LINQ standpoint, throughout the implementation.

LINQ to SQL has quickly become a hot topic with the release of ASP.NET 3.5, so it makes sense that the TheBeerHouse application gets an upgraded Data Access Layer leveraging this new technology!

While TheBeerHouse has been ported to Visual Basic .NET, the author uses C# throughout this Wrox Blox, so readers should have at least an intermediate level of understanding with C#.

 Table of Contents 

Getting Started 2

Setting up Your Environment 2

Migrating TheBeerHouse Application 3

The Necessary Files 5

Putting It All Together 14

Scalar Functions 17

Dynamic Queries 20

Data Manipulation via LINQ 22

Conversion of the Category and Comment Classes 26

SPROCS versus Dynamic SQL 33

LINQ to Entities 34

Summary 34

About Doug Parsons 35

  

Usage Rights for Wiley Wrox Blox

Any Wrox Blox you purchase from this site will come with certain restrictions that allow Wiley to protect the copyrights of its products. After you purchase and download this title, you: 

  • Are entitled to three downloads
  • Are entitled to make a backup copy of the file for your own use
  • Are entitled to print the Wrox Blox for your own use
  • Are entitled to make annotations and comments in the Wrox Blox file for your own use
  • May not lend, sell or give the Wrox Blox to another user
  • May not place the Wrox Blox file on a network or any file sharing service for use by anyone other than yourself or allow anyone other than yourself to access it
  • May not copy the Wrox Blox file other than as allowed above
  • May not copy, redistribute, or modify any portion of the Wrox Blox contents in any way without prior permission from Wiley

If you have any questions about these restrictions, you may contact Customer Care at (877) 762-2974 (8 a.m. - 5 p.m. EST, Monday - Friday). If you have any issues related to Technical Support, please contact us at 800-762-2974 (United States only) or 317-572-3994 (International) 8 a.m. - 8 p.m. EST, Monday - Friday).

See More
Doug Parsons has been developing Internet applications since Classic ASP 3.0 was released and since then has been an early adopter on each release of the .NET framework. He is currently employed as an Advanced Internet Programmer with a company that provides Internet solutions for local, state, and federal government agencies and entities. In his free time, he enjoys spending time with his wife and son, coding, playing video games, and trolling the P2P forums.
See More
Download TitleSizeDownload
TheBeerHouse Website for ASP.NET 2.0
Sample project for the Wrox Press book "ASP.NET 2.0 Website Programming", by Marco Bellinaso
4.16 MB Click to Download
See More

Do you think you've discovered an error in this book? Please check the list of errata below to see if we've already addressed the error. If not, please submit the error via our Errata Form. We will attempt to verify your error; if you're right, we will post a correction below.

ChapterPageDetailsDatePrint Run
17 Error in Code
code example before Scalar Functions heading:

return new Article(record.ID, record.AddedDate, record.AddedBy,
record.CategoryID, record.tbh_Category.Title,
record.Title, record.Abstract, record.Body,
record.Country, record.State, record.City,
(DateTime)record.ReleaseDate,
(DateTime)record.ExpireDate, record.Approved,


should be:

return new Article(record.ArticleID, record.AddedDate, record.AddedBy,
record.CategoryID, record.tbh_Category.Title,
record.Title, record.Abstract, record.Body,
record.Country, record.State, record.City,
(DateTime)record.ReleaseDate,
(DateTime)record.ExpireDate, record.Approved,
04/23/2008
See More

Related Titles

Back to Top