Vous voulez voir cette page en français ? Cliquez ici.

Have one to sell? Sell yours here
Tell the Publisher!
I'd like to read this book on Kindle

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

Migrating to Linq to SQL in Thebeerhouse and ASP.Net 2.0 Website Programming Problem Design Solution [Hardcover]

Doug Parsons

Currently unavailable.
We don't know when or if this item will be back in stock.

Join Amazon Student in Canada

Book Description

March 2008 Wrox Briefs (Book 20)
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).

Product Details

Product Description

About the Author

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.

Sell a Digital Version of This Book in the Kindle Store

If you are a publisher or author and hold the digital rights to a book, you can sell a digital version of it in our Kindle Store. Learn more

Customer Reviews

There are no customer reviews yet on Amazon.ca
5 star
4 star
3 star
2 star
1 star
Most Helpful Customer Reviews on Amazon.com (beta)
Amazon.com: 4.5 out of 5 stars  2 reviews
4.0 out of 5 stars Only C# Coding Examples, Not Enough on N-Tier Oct. 23 2010
By Robert MacFarlane - Published on Amazon.com
The Beer House (TBH) was my first step into ASP.NET and being an n-tier application was key for me to really understand the proper way to build an integrated website application. I never learned C#, but found a code sample of TBH using VB which was really helpful. While this brief mentions VB, all the code is in C#. I've learned to read C# well enough to know what is going on, but this document would have been more useful if it contained both the C# code as well as the VB code. I found this article lacking information on how the n-tier approach is maintained and any mention of how LINQ replaces all the DAL functionality of the original application. Sure the DAL is eventually removed, but passing on a complete understanding of the process was missing. Overall I think it's a good brief. At least it's only 6.99.
5.0 out of 5 stars Teaches you LINQ for SQL Effectively Jan. 24 2009
By A. Solorzano - Published on Amazon.com
Verified Purchase
Does the job. Clearly guides you through the process of LINQ to SQL. I was able to learn it in one afternoon with this.

Look for similar items by category