The final nine tutorials in my Working with Data in ASP.NET 2.0 tutorial series have been published. These final nine tutorials examine a variety of advanced data access scenarios, from using stored procedures in the Data Access Layer to creating Typed DataSets that use JOINs or query tables that include computed columns. There are also tutorials on encrypting sensitive connection string information in Web.config and debugging SQL Server stored procedures and UDFs through Visual Studio.
- Creating New Stored Procedures for the Typed DataSet's TableAdapters [VB | C#] - up until now, all TableAdapters used ad-hoc SQL queries. This tutorial looks at how to have the TableAdapter wizard turn automatically create and use stored procedures based on an ad-hoc query.
- Using Existing Stored Procedures for the Typed DataSet's TableAdapters [VB | C#] - in many scenarios, you will already have the stored procedures for the DAL created. This tutorial looks at how to plug existing sprocs into TableAdapters.
- Updating the TableAdpater to Use JOINs [VB | C#] - provides step-by-step instructions for creating TableAdapters whose main query includes one or more JOINs.
- Adding Additional DataTable Columns [VB | C#] - in certain scenarios you may want to add queries to a TableAdapter that return columns not returned by the main query. This tutorial examines how to accomplish this without causing problems down the road.
- Working with Computed Columns [VB | C#] - there are some wrinkles that arise when creating a DataTable from a query that includes computed columns. This tutorial examines those wrinkles and looks at workarounds.
- Configuring the Data Access Layer's Connection- and Command-Level Settings [VB | C#] - this tutorial shows how to programmatically modify connection- and command-level settings in the DAL from the BLL. There are certain scenarios where such an interaction may be needed.
- Protecting Connection Strings and Other Configuration Information [VB | C#] - .NET 2.0's Configuration API makes it a cinch to encrypt configuration information in Web.config, including sensative connection string information. This tutorial looks at the steps needed to encrypt and decrypt the <connectionStrings> section.
- Debugging Stored Procedures [VB | C#] - if you are using the Professional version of Visual Studio 2005, it is possible to step into SQL Server stored procedures through the debugger. See how in this tutorial.
- Creating Stored Procedures and User-Defined Functions with Managed Code [VB | C#] - with Microsoft SQL Server 2005 it is possible to created managed stored procedures and UDFs. In short, these are stored procedures and UDFs written in C# or Visual Basic! This tutorial looks at how to create, deploy, and debug managed database objects.
Like the previous tutorials in the series, all tutorials are available in C# and VB, include the complete code download as a self-extracting ZIP, and are available in PDF format.
My Toolbox column in the August 2007 issue of MSDN Magazine is avaiable online. The August issue examines three products:
- SharpGraph for .NET - create impressive and eye-pleasing graphs and charts with little to no code.
- Mail for .NET - this library provides a straightforward API for working with the Internet's core email-related protocols: SMTP, POP3, and IMAP.
- UltimateSpell - add spell checking to your web applications.
This month's issue reviewed Pro ASP.NET 2.0 E-Commerce in C# 2005, by Paul Sarknas. Here is an excerpt from the review:
In Pro ASP.NET 2.0 E-Commerce in C# 2005 (Apress, 2006), author Paul Sarknas walks readers through the key steps of building an e-commerce ASP.NET Web application. Rather than focusing on just the e-commerce related tasks, Paul takes readers through the entire application building process. For example, there are high-level discussions on the application’s design and motivation, a look at creating the data model, techniques for building a tiered application architecture, deployment options, and so forth. This background, which encompasses nearly a third of the book, is especially helpful to intermediate ASP.NET developers who may not have had much exposure to building large and complex Web applications; expert ASP.NET developers can skim through these early chapters.
As always, if you have any suggestions for products or books to review for the Toolbox column, please send them into firstname.lastname@example.org.