 |
Description
|
This book demonstrates best practices and advanced techniques for multi-tier database programming with the Visual Studio 2005 release of VB.NET, with SQL Server 2000 and SQL Server 2005 (Yukon). Part I, “ADO.NET 2.0 Basics” begins with a “quick-start” chapter for Visual Basic 6.0 programmers new to the .NET Framework and ADO.NET, describes new features added by ADO.NET 2.0, and provides prescriptive guidance for designing high-performance, scalable intranet and Internet database projects. Part II, “Data Binding in Windows Forms and Controls,” covers basic Windows form clients that use the new DataConnection and GridView controls and progresses from declarative, drag-and-drop front-end designs to customized intranet projects that use VB .NET code to manage server connections, DataAdapters, DataTables, and strongly typed DataSets. Part III, “DataBinding in ASP.NET 2.0,” explains Whidbey’s new WebSite metaphor and use of DataSource, GridView, and DetailsView Web controls. Advanced topics include creating XML Web services to retrieve and update data, client-side data validation, managing session and view state, and optimizing server-side data caching. Part IV, "SQL Server ‘Yukon’ and ADO.NET 2.0,” shows readers how to take advantage of “Yukon’s” new T-SQL extensions, in-process Web services, and notifications. Individual chapters describe integration of the CLR with the database engine, use of the new xml data type, and XQuery data access and update syntax. Part V, “Mapped Data Transformations,” describes how three-part mapping provides representation of SQL Server 2000 and 2005 relational data as an XPathDocument accessed by an XMLAdapter for data retrieval and updates. The other two chapters describe bidirectional relational-to-object (business entity) mapping with ObjectSpaces and the Microsoft Business Framework (business entities and operations).
|
Shopping Cart
My Account
Help
Contact Us 
