Many VB developers choose SQL Server 2000, a robust enterprise-level database system, to provide the data layer in their applications. The introduction of Microsoft's .NET Framework brings us ADO.NET, the latest means of connecting to that data source. This book will teach the experienced VB developer, with a working knowledge of Visual Basic .NET, how to integrate SQL Server 2000 with VB .NET applications using ADO.NET.
ADO.NET introduces .NET classes for:
- Efficient access to multiple data sources
- Data sorting
- Data manipulation
- Improved inter-application communication
"Building an effective data layer" illustrates how to take advantage of the new features available in the .NET Framework when working with data-centric applications. It covers:
- The key classes and objects in ADO.NET and how to utilize them to access and manipulate data from SQL Server 2000
- How to write and utilize efficient stored procedures, to reduce middle-tier code
- Databinding methods for use in both Windows Forms and Web Form applications
- Transactions and locking management
- Transactions and object pooling
