Bill Hamilton

ADO.NET 3.5 Cookbook (eBook, ePUB)

Building Data-Centric .NET Applications

• Format: ePub

Produktbeschreibung

This guide is strikingly different from other books on Microsoft ADO.NET. Rather than load you down with theory, the new edition of ADO.NET 3.5 Cookbook gives you more than 200 coding solutions and best practices for real problems you're likely to face with this technology using Visual Studio 2008 and the .NET 3.5 platform.Organized to help you find the topic and specific recipe you need quickly and easily, this book is more than just a handy compilation of cut-and-paste C# code. ADO.NET 3.5 Cookbook also offers clear explanations of how and why each code solution works, and warns you of potential pitfalls so you can learn to adapt the book's problem-solving techniques to different situations.This collection of timesaving recipes covers vital topics including:Connecting to dataRetrieving and managing dataTransforming and analyzing dataModifying dataBinding data to .NET user interfacesOptimizing .NET data accessEnumerating and maintaining database objectsMaintaining database integrityIdeal for ADO.NET programmers at all levels, from the relatively inexperienced to the most sophisticated, this new edition covers the significant 3.5 upgrade, including new programming tools such as LINQ. ADO.NET 3.5 Cookbook offers a painless way for those of you who prefer to learn by doing when it comes to expanding your skills and productivity.

---

Dieser Download kann aus rechtlichen Gründen nur mit Rechnungsadresse in A, B, BG, CY, CZ, D, DK, EW, E, FIN, F, GR, HR, H, IRL, I, LT, L, LR, M, NL, PL, P, R, S, SLO, SK ausgeliefert werden.

Produktdetails

• Verlag: O'Reilly Media
• Seitenzahl: 982
• Erscheinungstermin: 28. März 2008
• Englisch
• ISBN-13: 9780596555290
• Artikelnr.: 53003613

Autorenporträt

Bill Hamilton is a technology and management consultant who specializes in assessing business objectives and company processes and designing and restructuring technology strategy and enterprise architecture. Bill has been designing and implementing enterprise solutions using both SQL Server and Oracle for over a decade. Bill is the author of other O'Reilly titles including the highly praised Programming SQL Server 2005 and ADO.NET Cookbook, and he also writes for the Microsoft Developer Network. You can email Bill at [e-mail].

Inhaltsangabe

From the contents: Preface1. Connecting to Data 1.1 Storing Connection Strings 1.2 Building a Connection String 1.3 Connecting to SQL Server 1.4 Connecting to a Named Instance of SQL Server 1.5 Connecting to SQL Server Using an IP Address 1.6 Connecting to SQL Server Using Integrated Security from ASP.NET 1.7 Connecting to an Oracle Database 1.8 Connecting to an OLE DB Data Source 1.9 Connecting to an ODBC Data Source 1.10 Connecting to a Microsoft Access Database 1.11 Connecting to a Password-Protected Microsoft Access Database 1.12 Connecting to a Microsoft Access Database from ASP.NET 1.13 Connecting to a Microsoft Excel Workbook 1.14 Connecting to a Text File 1.15 Changing the Database for an Open Connection 1.16 Setting Connection Pooling Options 1.17 Taking Advantage of Connection Pooling 1.18 Using Transactions with Pooled Connections 1.19 Displaying a Connection Property Dialog Box 1.20 Displaying the Data Link Properties Dialog Box 1.21 Monitoring Connections 2. Working with Disconnected Data Objects 2.1 Creating a DataColumn and Adding It to a DataTable 2.2 Creating a DataTable and Adding It to a DataSet 2.3 Mapping Table and Column Names Between a Data Source and DataSet 2.4 Mapping .NET Data Provider Data Types to .NET Framework Data Types 2.5 Adding a Calculated Column to a DataTable 2.6 Creating a Unique Constraint 2.7 Creating Single- and Multi-Column Primary Keys 2.8 Creating an Autoincrementing Primary Key 2.9 Creating a Foreign Key Constraint 2.10 Creating a Data Relation 2.11 Building a DataSet Programmatically 2.12 Adding a Column to a Child DataTable That Displays Data from the Parent Table 2.13 Adding a Column to a Parent DataTable That Aggregates a Child Table's Column Values 2.14 Converting Between a DataTable and a DataRow Array 2.15 Accessing Data Values in a DataRow Array 2.16 Creating a Strongly Typed DataSet 2.17 Controlling the Names Used in a Strongly Typed DataSet 2.18 Replacing Null Values in a Strongly Typed DataSet 3. Querying and Retrieving Data 3.1 Executing a Query That Does Not Return a Result Set 3.2 Executing a Query That Returns a Single Value 3.3 Retrieving a Result Set Stream Using a DataReader 3.4 Accessing Data Values in a DataReader 3.5 Retrieving a Result Set Using a DataTable or a DataSet 3.6 Accessing Data Values in a DataTable or DataSet 3.7 Working with Data in a Strongly Typed DataSet