ADO.NET 3.5 cookbook / Bill Hamilton.

Format:

Book

Author/Creator:

Hamilton, Bill.

Language:

English

Subjects (All):

ActiveX.

SQL server.

Database design.

Microsoft .NET.

Object-oriented programming (Computer science).

Physical Description:

1 online resource (992 p.)

Edition:

2nd ed.

Place of Publication:

Sebastopol, California : O'Reilly, 2008.

Language Note:

English

System Details:

text file

Summary:

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 so

Contents:

ADO.NET 3.5 Cookbook, 2nd Edition; Who This Book Is For; What You Need to Use This Book; How This Book Is Organized; What Was Left Out; Conventions Used in This Book; About the Code; Using Code Examples; Comments and Questions; Safari® Books Online; Acknowledgments; 1. Connecting to Data; Connections, Connection Strings, and Connection Pooling; 1.1. Storing Connection Strings; Solution; Discussion; Protected configuration; Hardcode in the application; Universal data link (UDL) file; Windows registry; Custom file; 1.2. Building a Connection String; Solution; Discussion

1.3. Connecting to SQL ServerSolution; Discussion; OLE DB; ODBC; 1.4. Connecting to a Named Instance of SQL Server; Solution; Discussion; 1.5. Connecting to SQL Server Using an IP Address; Solution; Discussion; 1.6. Connecting to SQL Server Using Integrated Security from ASP.NET; Solution; Discussion; 1.7. Connecting to an Oracle Database; Solution; Discussion; OLE DB; ODBC; 1.8. Connecting to an OLE DB Data Source; Solution; Discussion; 1.9. Connecting to an ODBC Data Source; Solution; Discussion; 1.10. Connecting to a Microsoft Access Database; Solution; Discussion

1.11. Connecting to a Password-Protected Microsoft Access DatabaseSolution; Discussion; 1.12. Connecting to a Microsoft Access Database from ASP.NET; Solution; Discussion; Configure the Access computer; 1.13. Connecting to a Microsoft Excel Workbook; Solution; Discussion; 1.14. Connecting to a Text File; Solution; Discussion; 1.15. Changing the Database for an Open Connection; Solution; Discussion; 1.16. Setting Connection Pooling Options; Solution; Discussion; Oracle; OLE DB; ODBC; 1.17. Taking Advantage of Connection Pooling; Solution; Discussion; OLE DB; ODBC

1.18. Using Transactions with Pooled ConnectionsSolution; Discussion; 1.19. Displaying a Connection Property Dialog Box; Solution; Discussion; 1.20. Displaying the Data Link Properties Dialog Box; Solution; Discussion; 1.21. Monitoring Connections; Solution; Discussion; ODBC; 2. Working with Disconnected Data Objects; 2.1. Creating a DataColumn and Adding It to a DataTable; Solution; Discussion; 2.2. Creating a DataTable and Adding It to a DataSet; Solution; Discussion; 2.3. Mapping Table and Column Names Between a Data Source and DataSet; Solution; Discussion

2.4. Mapping .NET Data Provider Data Types to .NET Framework Data TypesSolution; Discussion; 2.5. Adding a Calculated Column to a DataTable; Solution; Discussion; 2.6. Creating a Unique Constraint; Solution; Discussion; 2.7. Creating Single- and Multi-Column Primary Keys; Solution; Discussion; 2.8. Creating an Autoincrementing Primary Key; Solution; Discussion; 2.9. Creating a Foreign Key Constraint; Solution; Discussion; 2.10. Creating a Data Relation; Solution; Discussion; 2.11. Building a DataSet Programmatically; Solution; Discussion

2.12. Adding a Column to a Child DataTable That Displays Data from the Parent Table

Notes:

"Building data-centric .NET applications"--Cover.

"Updated for .NET 3.5, LINQ, and SQL Server 2008"--Cover.

Includes index.

Description based on print version record.

ISBN:

9781306814614

1306814618

9780596522452

0596522452

9780596555290

0596555296

OCLC:

609841190