Advanced Data Access Scenarios

These tutorials cover how to work with stored procedures and computed columns, how to use joins with database tables, and how to encrypt data connection information.

• Creating New Stored Procedures for the Typed DataSet's TableAdapters (C#)
• Using Existing Stored Procedures for the Typed DataSet's TableAdapters (C#)
• Updating the TableAdapter to Use JOINs (C#)
• Adding Additional DataTable Columns (C#)
• Working with Computed Columns (C#)
• Configuring the Data Access Layer's Connection- and Command-Level Settings (C#)
• Protecting Connection Strings and Other Configuration Information (C#)
• Debugging Stored Procedures (C#)
• Creating Stored Procedures and User-Defined Functions with Managed Code (C#)
• Creating New Stored Procedures for the Typed DataSet's TableAdapters (VB)
• Using Existing Stored Procedures for the Typed DataSet's TableAdapters (VB)
• Updating the TableAdapter to Use JOINs (VB)
• Adding Additional DataTable Columns (VB)
• Working with Computed Columns (VB)
• Configuring the Data Access Layer's Connection- and Command-Level Settings (VB)
• Protecting Connection Strings and Other Configuration Information (VB)
• Debugging Stored Procedures (VB)
• Creating Stored Procedures and User-Defined Functions with Managed Code (VB)