Ebooks Link Collection and Review

The following list provides a breakdown of the topics covered in each chapter:

Chapter 1—Abrief history of data access technologies so you can see why some of the features are needed. It also touches on the major design goals of ADO.NET 2.0 and highlights what is covered in the rest of the book.
Chapter 2—Basic database design concepts, primarily in Microsoft SQL Server 2005. It also covers creating databases, tables, and views following third normal form and the importance of primary and foreign keys. It shows you how to optimize performance using indexes and other methods, and in general provides you with a solid foundation for developing database-driven applications.
Chapter 3—The basics of creating a connection, executing a query, and returning a result. It also digs deeply into many of these areas, showing best practices and techniques for optimizing your code. It covers scenarios for which it may or may not be appropriate to use features such as DataSets and DataViews. It also covers the various options for persisting data back to a database, and introduces new techniques in ADO.NET 2.0. Finally, it introduces the new APIs available for schema discovery and connection pooling.
Chapter 4—Delves into the new data types available in the 2.0 framework, and discusses the appropriate situations in which to use them.
Chapter 5—Covers many of the new features available for XML integration. It offers a brief overview of how XML evolved, the numerous designer enhancements and new features available in XmlReader and XmlWriter, and introduces the XPathDocument as the new standard for storing XML documents. It details new validation features and highlights many of the performance gains available in this framework, and provides a roadmap to where XML technologies are heading.
Chapter 6—Looks into the new transactional capabilities available in the ADO.NET 2.0 Framework and how to integrate them with Microsoft SQL Server 2005 and other data sources. It covers locking, replication, and other design issues.
Chapter 7—Covers the details of data binding. It shows how to use the ADO.NET 2.0 design time programmability features in Visual Studio.NET. It also shows off the new TableAdapters and DataConnectors. You will see how you can data bind not only to database queries, but to Web services, business objects, and other sources.
Chapter 8—In this chapter, you learn how to create a custom ADO.NET managed provider. Step by step, you’ll create your own provider, including the various interfaces for creating connections, commands, readers, and adapters.
Chapter 9—Shows the new TSQL language enhancements available in Microsoft SQL Server 2005. It also covers how these new features tightly integrate with the ADO.NET 2.0 Framework.
Chapter 10—Covers the details of integrating the new Microsoft SQL Server 2005 features into a client application using ADO.NET 2.0. In this chapter, you learn about the new asynchronous support features, the capability to return multiple result sets from a query, and how to initiate bulk copies. You also learn how to use the new caching features, create your own user-defined data types, and explore various new APIs for working with Microsoft SQL Server 2005.
Chapter 11—Shows how to use many of the new CLR capabilities of Microsoft SQL Server 2005. You’ll learn how to create CLR code in stored procedures, how to use CLR objects for data types, and how to debug your CLR code in Microsoft SQL Server 2005.
Chapter 12—Provides a detailed description of how to create a Notification Services application in Microsoft SQL Server 2005. It starts from the beginning, assuming no prior experience with notification services, and shows how to create an application from the ground up, including how to interface with that application from custom .NET code.
Chapter 13—Shows off the message queuing functionality in the .NET 2.0 Framework by introducing the Service Broker. It covers the feature set and the various options and describes how to use them to develop scalable applications.
Chapter 14—Displays how to use the full text search capabilities of Microsoft SQL Server 2005. It provides a background on full text searches, covers the new features available and how to enable them, and describes the best practices for using them.
Chapter 15—Many tools are available for retrieving data and presenting it in various ways. This chapter covers some of the most common tools, such as Crystal Reports, Microsoft SQL Reporting Services, OLAP, and other business analysis tools, and shows how to best use them with Microsoft SQL Server 2005.
Chapter 16—MySQL is an option for data storage that is rapidly growing in popularity. In this chapter, you examine the new provider available for MySQL and learn how to best utilize it to maximize performance and scalability.
Chapter 17—Shows how to best use Oracle in the ADO.NET Framework. It shows off the features specific to the Oracle Managed provider in ADO.NET 2.0. It covers topics such as blobs, clobs, bfiles, packages, and transactions

Size: 4.5 MB
Download: Ziddu OR Rapidshare