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

Have one to sell? Sell yours here
Migrating to Linq to SQL in Thebeerhouse and ASP.Net 2.0 Website Programming Problem Design Solution
 
See larger image
 

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.



Product Details


Product Description

Product Description

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).

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.

Tag this product

 (What's this?)
Think of a tag as a keyword or label you consider is strongly related to this product.
Tags will help all customers organize and find favorite items.
Your tags: Add your first tag
 

Customer Reviews

There are no customer reviews yet on Amazon.ca
5 star:    (0)
4 star:    (0)
3 star:    (0)
2 star:    (0)
1 star:    (0)
 
 
 
Share your experience with this product with others
Create your own review
Most Helpful Customer Reviews on Amazon.com (beta)
Amazon.com: 4.5 out of 5 stars (2 customer 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 "ValueHunter" - Published on Amazon.com
Amazon Verified Purchase(What's this?)
Does the job. Clearly guides you through the process of LINQ to SQL. I was able to learn it in one afternoon with this.
 Go to Amazon.com to see both reviews  4.5 out of 5 stars 

Listmania!

Create a Listmania! list

Look for similar items by category


Look for similar items by subject






i.e., each book must be in subject 1 AND subject 2 AND ...

Feedback