Linux Application Development (2nd Edition) - page 1
- 1
- 2
- LRN
- LRN
- Table of Contents
- Programming Microsoft ADO.NET 2.0 Applications - Advanced Topics
- Foreword
- Introduction
- How This Book Is Organized
- System Requirements
- Prerelease Software
- Technology Updates
- Code Samples
- Support for This Book
- Chapter 1 Overview of ADO.NET Disconnected Classes
- Getting Started with the DataTable Object
- Using a DataSet Object to Work with Lots of Data
- Looping through Data with the DataTableReader
- Summary
- Chapter 2 Overview of ADO.NET Connected Classes
- Summary
- Chapter 3 ADO.NET Trace Logging
- Setting Up Tracing
- Summary
- Chapter 4 Advanced Connectivity to the Data Store
- Connection Pooling
- Asynchronous Data Access
- Working with SQL Server Provider Statistics
- Summary
- Chapter 5 Working with Disconnected Data
- Understanding Concurrency Issues
- Designing for Disconnected Data
- Who s Afraid of the Big, Bad GUID
- Building a Conflict Resolution Screen
- Summary
- Chapter 6 Working with Relational Disconnected Data
- Navigating Relationships
- Creating Constraints
- Updating Data The Beginning of the Data Access Layer
- Summary
- Chapter 7 Working with the Windows Data Grid Control
- Summary
- Chapter 8 Working with the Web Data Grid Control
- Understanding the GridView Control
- GridView Setup
- Summary
- Chapter 9 Working with the SQLCLR
- Does the SQLCLR Replace T-SQL
- Creating a Stored Procedure without Visual Studio
- Creating a Stored Procedure by Using Visual Studio
- Passing Rowset Data
- Creating User-Defined Functions
- Working with User-Defined Aggregates
- Working with Triggers
- Working with User-Defined Types
- Accessing SQLCLR Features from the Client
- Summary
- Chapter 10 Understanding Transactions
- What is a Transaction
- Creating a Transaction
- Setting the Transaction Isolation Level
- Introducing the System.Transactions Namespace
- Best Practices
- Summary
- Chapter 11 Retrieving Metadata
- Getting Started
- Retrieving the Metadata Collections
- Summary
- Chapter 12 Data Caching for Performance
- Using the SqlDependency Class
- ASP.NET SQL Cache Invalidation
- Summary
- Chapter 13 Implementing Security
- Application Security Overview
- SQL Server Security
- ADO.NET Security
- Summary
- What are LOBs, BLOBs, and CLOBs
- Summary
- Chapter 15 Working with XML Data
- Introducing XPath and XQuery
- Why Store XML Data in SQL Server 2005
- 1
- 2
