ASP.NET Data Access Tutorials

Creating Stored Procedures and User-Defined Functions with Managed Code

ASP.NET Data Access Tutorials — Friday, 3 Aug 2007

Microsoft SQL Server 2005 integrates with the .NET Common Language Runtime to allow developers to create database objects through managed code. This tutorial shows how to create managed stored procedures and managed user-defined functions with your Visual Basic or C# code. We also see how these editions of Visual Studio allow you to debug such managed database objects.
View Visual Basic tutorial
View Visual C# tutorial

Debugging Stored Procedures

ASP.NET Data Access Tutorials — Friday, 3 Aug 2007

Visual Studio Professional and Team System editions allow you to set breakpoints and step in to stored procedures within SQL Server, making debugging stored procedures as easy as debugging application code. This tutorial demonstrates direct database debugging and application debugging of stored procedures.
View Visual Basic tutorial
View Visual C# tutorial

Protecting Connection Strings and Other Configuration Information

ASP.NET Data Access Tutorials — Friday, 3 Aug 2007

An ASP.NET application typically stores configuration information in a Web.config file. Some of this information is sensitive and warrants protection. By default this file will not be served to a Web site visitor, but an administrator or a hacker may gain access to the Web server’s file system and view the contents of the file. In this tutorial we learn that ASP.NET 2.0 allows us to protect sensitive information by encrypting sections of the Web.config file.
View Visual Basic tutorial
View Visual C# tutorial

Configuring the Data Access Layer’s Connection- and Command-Level Settings

ASP.NET Data Access Tutorials — Friday, 3 Aug 2007

The TableAdapters within a Typed DataSet automatically take care of connecting to the database, issuing commands, and populating a DataTable with the results. There are occasions however when we want to take care of these details ourselves, and in this tutorial we learn how to access the database connection- and command-level settings in the TableAdapter.
View Visual Basic tutorial
View Visual C# tutorial

Working with Computed Columns

ASP.NET Data Access Tutorials — Friday, 3 Aug 2007

When creating a database table, Microsoft SQL Server allows you to define a computed column whose value is calculated from an expression that usually references other values in the same database record. Such values are read-only at the database, which requires special considerations when working with TableAdapters. In this tutorial we learn how to meet the challenges posed by computed columns.
View Visual Basic tutorial
View Visual C# tutorial

Adding Additional DataTable Columns

ASP.NET Data Access Tutorials — Wednesday, 18 Jul 2007

When using the TableAdapter Wizard to create a Typed DataSet, the corresponding DataTable contains the columns returned by the main database query. But there are occasions when the DataTable needs to include additional columns. In this tutorial we learn why stored procedures are recommended when we need additional DataTable columns.
View Visual Basic tutorial
View Visual C# tutorial

Updating the TableAdapter to Use JOINs

ASP.NET Data Access Tutorials — Wednesday, 18 Jul 2007

When working with a database it is common to request data that is spread across multiple tables. To retrieve data from two different tables we can use either a correlated subquery or a JOIN operation. In this tutorial we compare correlated subqueries and the JOIN syntax before looking at how to create a TableAdapter that includes a JOIN in its main query.
View Visual Basic tutorial
View Visual C# tutorial

Using Existing Stored Procedures for the Typed DataSet’s TableAdapters

ASP.NET Data Access Tutorials — Wednesday, 18 Jul 2007

In the previous tutorial we learned how to use the TableAdapter Wizard to generate new stored procedures. In this tutorial we learn how the same TableAdapter Wizard can work with existing stored procedures. We also learn how to manually add new stored procedures to our database.
View Visual Basic tutorial
View Visual C# tutorial

Creating New Stored Procedures for the Typed DataSet’s TableAdapters

ASP.NET Data Access Tutorials — Wednesday, 18 Jul 2007

In earlier tutorials we have created SQL statements in our code and passed the statements to the database to be executed. An alternative approach is to use stored procedures, where the SQL statements are pre-defined at the database. In this tutorial we learn how to have the TableAdapter Wizard generate new stored procedures for us.
View Visual Basic tutorial
View Visual C# tutorial

Batch Inserting

ASP.NET Data Access Tutorials — Tuesday, 26 Jun 2007

Learn how to insert multiple database records in a single operation. In the User Interface Layer we extend the GridView to allow the user to enter multiple new records. In the Data Access Layer we wrap the multiple Insert operations within a transaction to ensure that all insertions succeed or all insertions are rolled back.
View Visual Basic tutorial
View Visual C# tutorial

Batch Deleting

ASP.NET Data Access Tutorials — Tuesday, 26 Jun 2007

Learn how to delete multiple database records in a single operation. In the User Interface Layer we build upon an enhanced GridView created in an earlier tutorial. In the Data Access Layer we wrap the multiple Delete operations within a transaction to ensure that all deletions succeed or all deletions are rolled back.
View Visual Basic tutorial
View Visual C# tutorial

Batch Updating

ASP.NET Data Access Tutorials — Tuesday, 26 Jun 2007

Learn how to update multiple database records in a single operation. In the User Interface Layer we build a GridView where each row is editable. In the Data Access Layer we wrap the multiple Update operations within a transaction to ensure that all updates succeed or all updates are rolled back.
View Visual Basic tutorial
View Visual C# tutorial

Wrapping Database Modifications within a Transaction

ASP.NET Data Access Tutorials — Tuesday, 26 Jun 2007

This tutorial is the first of four that looks at updating, deleting, and inserting batches of data. In this tutorial we learn how database transactions allow batch modifications to be carried out as an atomic operation, which ensures that either all steps succeed or all steps fail.
View Visual Basic tutorial
View Visual C# tutorial

Building a Custom Database-Driven Site Map Provider

ASP.NET Data Access Tutorials — Tuesday, 26 Jun 2007

The default site map provider in ASP.NET 2.0 retrieves its data from a static XML file. While the XML-based provider is suitable to many small and medium-sized Web sites, larger Web applications require a more dynamic site map. In this tutorial we’ll build a custom site map provider that retrieves its data from the Business Logic Layer, which in turn retrieves data from the database.
View Visual Basic tutorial
View Visual C# tutorial

Using SQL Cache Dependencies

ASP.NET Data Access Tutorials — Wednesday, 30 May 2007

The simplest caching strategy is to allow cached data to expire after a specified period of time. But this simple approach means that the cached data maintains no association with its underlying data source, resulting in stale data that is held too long or current data that is expired too soon. A better approach is to use the SqlCacheDependency class so that data remains cached until its underlying data has been modified in the SQL database. This tutorial shows you how.
View Visual Basic tutorial
View Visual C# tutorial