ADO.NET 3.5 Cookbook
Autor Bill Hamiltonen Limba Engleză Paperback – 6 mai 2008
ACTUALIZAREA: Această a doua ediție a ADO.NET 3.5 Cookbook marchează tranziția fundamentală către ecosistemul .NET 3.5, integrând noile paradigme de interogare și modelare a datelor. Ne-a atras atenția în mod deosebit modul în care autorul a revizuit cele peste 200 de soluții practice pentru a include suportul nativ pentru LINQ (Language Integrated Query) și Entity Framework, tehnologii care au redefinit accesul la date în mediul Microsoft. Considerăm că structura de tip „rețetă” — problemă, soluție, discuție — rămâne cea mai eficientă metodă de învățare pentru inginerii software care au nevoie de rezultate imediate în producție. Pe linia practică a volumului Visual Basic 2008 Recipes, dar cu focus pe arhitectura de acces la date, lucrarea de față elimină ambiguitățile teoretice în favoarea fragmentelor de cod gata de implementat. Dacă în Programming SQL Server 2005 autorul se concentra pe gestiunea și analiza datelor la nivel de server, aici Bill Hamilton mută centrul de greutate către stratul de aplicație, oferind mecanismele necesare pentru a conecta eficient logica de business cu bazele de date relaționale. Abordarea este tehnică și riguroasă, acoperind de la conectivitatea de bază și manipularea seturilor de date deconectate, până la tehnici complexe de serializare XML și securitate. Merită menționat că, spre deosebire de alte manuale care tratează doar scenariul ideal, acest cookbook oferă soluții pentru gestionarea erorilor de concurență și optimizarea performanței în aplicații enterprise de mare anvergură.
Preț: 296.73 lei
Preț vechi: 370.91 lei
-20%
Puncte Express: 445
Carte disponibilă
Livrare economică 15-29 septembrie
Livrare prin curier în România Termenul estimat este afișat lângă disponibilitate.
Transport gratuit de la 400.00 lei Plată online sau ramburs, în funcție de opțiunile comenzii.
Retur gratuit în 14 zile Comandă securizată și suport în română.
Specificații
ISBN-13: 9780596101404
ISBN-10: 0596101406
Pagini: 979
Dimensiuni: 177 x 233 x 20 mm
Greutate: 1.33 kg
Ediția:2nd edition
Editura: O'Reilly
Locul publicării:United States
ISBN-10: 0596101406
Pagini: 979
Dimensiuni: 177 x 233 x 20 mm
Greutate: 1.33 kg
Ediția:2nd edition
Editura: O'Reilly
Locul publicării:United States
V-ar putea interesa
-
ASP.Net and VB.NET Web ProgrammingMatt J. Crouch-20%Preț: 268.63 lei335.79 lei -
Code Complete: A practical handbook of software constructionSteve McConnell-20%Preț: 282.45 lei353.07 lei -
Coding For Dummies, All New EditionPaul McFedries-20%Preț: 114.90 lei143.62 lei -
Pro C# 2010 and the .Net 4 PlatformAndrew Troelsen-20%Preț: 545.30 lei681.63 lei -
Pro C# 5.0 and the .Net 4.5 FrameworkAndrew Troelsen-20%Preț: 498.16 lei622.70 lei -
Pro ASP.NET 4.5 in CAdam Freeman-20%Preț: 382.48 lei478.11 lei -
ABAP CookbookFabian Lupa-20%Preț: 431.06 lei538.83 lei -
Building Client/Server Applications with VB .NetJeff Levinson-20%Preț: 289.29 lei361.60 lei -
Beginning Visual Web Programming in VB .NetChris Hart-20%Preț: 221.93 lei277.42 lei -
Beginning ASP.Net 3.5 in C# 2008Matthew Macdonald-20%Preț: 284.91 lei356.14 lei -
Murach's C# 2008Joel Murach-29%Preț: 341.26 lei477.30 lei -
-28%Preț: 349.51 lei483.53 lei -
-28%Preț: 347.94 lei482.34 lei -
-29%Preț: 338.41 lei475.15 lei -
-29%Preț: 338.91 lei475.52 lei -
-28%Preț: 354.29 lei495.20 lei -
Murachs C# 2012Joel Murach-28%Preț: 355.17 lei495.87 lei -
Murachs Visual Basic 2012Anne Boehm-28%Preț: 356.22 lei496.66 lei -
.NET 10 RevealedKajetan Duszy¿ski-20%Preț: 240.60 lei300.75 lei -
Mastering ASP.NET Core 10Mabrouk Mahdhi-20%Preț: 375.92 lei469.91 lei
De ce să citești această carte
Recomandăm această carte dezvoltatorilor .NET care doresc să stăpânească noile funcționalități din versiunea 3.5, în special LINQ. Cititorul câștigă acces la o bibliotecă vastă de soluții testate care reduc timpul de depanare și dezvoltare. Este un instrument indispensabil pentru cei care lucrează cu baze de date complexe și au nevoie de metode rapide pentru a implementa un strat de acces la date robust și scalabil.
Despre autor
Bill Hamilton este un arhitect enterprise specializat în proiectarea și implementarea aplicațiilor complexe folosind tehnologiile .NET și J2EE. Cu o experiență de peste 15 ani în consultanță pentru sectoarele financiar, retail și producție, Hamilton a publicat lucrări de referință precum Programming SQL Server 2005 și NUnit Pocket Reference. Expertiza sa vastă în integrarea sistemelor și arhitecturi orientate pe servicii se reflectă în pragmatismul soluțiilor propuse, autorul fiind recunoscut pentru capacitatea de a traduce cerințele complexe de business în structuri tehnice eficiente și ușor de întreținut.
Notă biografică
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 bill.hamilton@element14.com.
Cuprins
Preface; What's New in the Second 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;
Chapter 1: Connecting to Data; 1.0 Introduction; 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;
Chapter 2: Working with Disconnected Data Objects; 2.0 Introduction; 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;
Chapter 3: Querying and Retrieving Data; 3.0 Introduction; 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; 3.8 Working with Parent-Child Relations in a Strongly Typed DataSet; 3.9 Using a DataView with a Strongly Typed DataSet; 3.10 Testing Whether a Query Returns an Empty Result Set; 3.11 Counting Records Meeting Criteria; 3.12 Determining the Number of Records Returned in a DataReader; 3.13 Executing a Query That Returns Multiple Result Sets; 3.14 Retrieving Schema and Constraints for a DataSet; 3.15 Retrieving Hierarchical Data; 3.16 Navigating Between Parent and Child Tables in an Untyped DataSet; 3.17 Executing a Parameterized Query; 3.18 Retrieving Data Using a SQL Server Stored Procedure; 3.19 Retrieving Multiple Result Sets Using the Oracle Provider; 3.20 Passing a Null Value to a Query Parameter; 3.21 Using Table-Valued Types As Parameters; 3.22 Retrieving a Return Value from a Stored Procedure; 3.23 Retrieving a Stored Procedure Output Parameter; 3.24 Raising and Handling Stored Procedure Errors; 3.25 Executing a SQL Server Scalar-Valued Function; 3.26 Executing a SQL Server Table-Valued Function; 3.27 Querying a DataSet Using LINQ; 3.28 Querying a SQL Server Database Using LINQ; 3.29 Retrieving Data from a Text File; 3.30 Retrieving Data from a Microsoft Excel Workbook; 3.31 Querying Data Asynchronously with Message Queuing;
Chapter 4: Searching and Analyzing Data; 4.0 Introduction; 4.1 Determining the Differences in Data Between Two DataSet Objects; 4.2 Combining Data from Heterogeneous Data Sources; 4.3 Filtering Rows in a DataTable or DataView; 4.4 Finding Rows in a DataTable or DataView; 4.5 Filtering and Sorting Data in a DataTable; 4.6 Filtering Null Field Values in a DataTable; 4.7 Accessing Deleted Rows in a DataTable; 4.8 Selecting the Top N Rows in a DataTable; 4.9 Executing Queries That Use COMPUTE BY; 4.10 Using the Shape Language to Retrieve Hierarchical Data; 4.11 Retrieving a Random Sample of Records; 4.12 Using a Common Table Expression (CTE); 4.13 Executing a Recursive Query; 4.14 Retrieving a Ranked Result Set; 4.15 Retrieving a Pivot and Unpivot Table; 4.16 Invoking a Function for Each Row in a Result Set;
Chapter 5: Adding and Modifying Data; 5.0 Introduction; 5.1 Using Autoincrementing Columns Without Causing Conflicts; 5.2 Getting an Identity Column Value from SQL Server; 5.3 Getting an AutoNumber Value from Microsoft Access; 5.4 Getting a Sequence Value from Oracle; 5.5 Modifying Data in a Microsoft Excel Workbook; 5.6 Modifying Data in a Text File; 5.7 Retrieving Update Errors; 5.8 Adding Parent/Child Rows with Autoincrementing Keys; 5.9 Adding Records with a GUID Primary Key; 5.10 Inserting Multiple Rows into a Database Table Using T-SQL Row Constructors; 5.11 Updating a Data Source with Data from a Different Data Source; 5.12 Updating a Primary Key Value; 5.13 Getting Stored Procedure Parameter Information at Runtime; 5.14 Updating a DataSet with a Many-to-Many Relationship; 5.15 Updating Data Asynchronously Using Message Queuing; 5.16 Controlling Edits, Deletions, or Additions to Data with a DataView; 5.17 Overcoming Keyword Conflicts When Using a CommandBuilder; 5.18 Capturing Changes to Data in a SQL Server Database;
Chapter 6: Copying and Transferring Data; 6.0 Introduction; 6.1 Copying Rows from One DataTable to Another; 6.2 Copying Tables from One DataSet to Another; 6.3 Converting a DataReader to a DataTable; 6.4 Converting a DataReader to a DataSet; 6.5 Converting a DataTable to a DataReader; 6.6 Converting a DataSet to a DataReader; 6.7 Serializing Data; 6.8 Deserializing Data; 6.9 Merging Data in Two DataSet Objects; 6.10 Merging Data in Two Database Tables; 6.11 Encrypting a DataSet; 6.12 Securing Login Credentials; 6.13 Exporting the Results of a Query As a String; 6.14 Exporting the Results of a Query to an Array; 6.15 Loading an ADO Recordset into a DataSet; 6.16 Converting a DataSet to an ADO Recordset;
Chapter 7: Maintaining Database Integrity; 7.0 Introduction; 7.1 Using Distributed Transactions; 7.2 Using Manual Transactions; 7.3 Nesting Manual Transactions with the SQL Server .NET Data Provider; 7.4 Using ADO.NET and SQL Server DBMS Transactions Together; 7.5 Using a Transaction with a DataAdapter; 7.6 Avoiding Referential Integrity Problems when Updating Data in Related Tables; 7.7 Enforcing Business Rules with Column Expressions; 7.8 Retrieving Constraints from a SQL Server Database; 7.9 Checking for Concurrency Violations; 7.10 Resolving Data Conflicts; 7.11 Using Transaction Isolation Levels to Protect Data; 7.12 Specifying Locking Hints in a SQL Server Database;
Chapter 8: Programmatically Working with Data in .NET Windows and Web Forms User Interfaces; 8.0 Introduction; 8.1 Loading Data into and Binding a Field to a Web Forms Control; 8.2 Binding Data to a Web Forms Control; 8.3 Binding Data to a Web Forms DetailsView Control; 8.4 Binding Data to a Web Forms Repeater Control; 8.5 Binding Data to a Web Forms DataList Control; 8.6 Binding Data to a Web Forms GridView Control; 8.7 Modifying and Updating Data in a Web Forms GridView Control; 8.8 Binding Data to a Web Forms FormView Control; 8.9 Synchronizing Master-Detail Data in a Web Forms Application; 8.10 Displaying an Image from a Database in a Web Forms Control; 8.11 Localizing Client-Side Data in a Web Forms Application; 8.12 Loading Data into and Binding a Field to a Windows Forms Control; 8.13 Binding Data to a Windows Forms Control; 8.14 Binding Data to a Windows Forms DataGridView Control; 8.15 Modifying and Updating Data in a Windows Forms DataGridView Control; 8.16 Using Windows Forms BindingNavigator and BindingSource Controls; 8.17 Synchronizing Master-Detail Data in a Windows Forms Application; 8.18 Displaying an Image from a Database in a Windows Forms Control; 8.19 Binding a Group of Radio Buttons to a Windows Forms Data Field; 8.20 Searching a Windows Forms DataGridView Control;
Chapter 9: Working with XML Data; 9.0 Introduction; 9.1 Using an XML File to Save and Load a DataSet or a DataTable; 9.2 Using XSD Schema Files to Save and Load a DataSet Structure; 9.3 Formatting Column Values When Saving Data As XML; 9.4 Creating an XML File That Shows Changes Made to a DataSet; 9.5 Synchronizing a DataSet and an XML Document; 9.6 Storing and Retrieving XML with a Non-XML Data Type Column; 9.7 Working with a SQL Server XML Data Type Column; 9.8 Using an XPath Query to Retrieve Data; 9.9 Reading XML Data Directly from SQL Server; 9.10 Transforming a DataSet Using XSLT; 9.11 Filling a DataSet Using an XML Template Query; 9.12 Using OpenXML to Update Multiple Changes to SQL Server;
Chapter 10: Optimizing .NET Data Access; 10.0 Introduction; 10.1 Executing Multiple Commands on a Single Connection; 10.2 Executing a SQL Statement Asynchronously; 10.3 Executing Simultaneous SQL Statements Asynchronously; 10.4 Creating a DataReader Asynchronously; 10.5 Filling a DataSet Asynchronously; 10.6 Canceling an Asynchronous Query; 10.7 Caching Data; 10.8 Improving Paging Performance; 10.9 XML Bulk Loading with SQL Server; 10.10 Bulk Copying with SQL Server; 10.11 Improving DataReader Performance with Typed Accessors; 10.12 Improving DataReader Performance with Column Ordinals; 10.13 Debugging a SQL Server Stored Procedure; 10.14 Improving Performance While Filling a DataSet; 10.15 Reading and Writing Large-Value Data with SQL Server; 10.16 Reading and Writing a SQL Server User-Defined Type (UDT); 10.17 Reading and Writing Oracle Large Data; 10.18 Performing Batch Updates with a DataAdapter; 10.19 Automatically Refreshing a DataTable Periodically; 10.20 Automatically Refreshing a DataTable When Underlying Data Changes; 10.21 Retrieving SQL Server Runtime Statistics; 10.22 Writing Provider- and Database-Independent Code;
Chapter 11: Enumerating and Maintaining Database Objects; 11.0 Introduction; 11.1 Enumerating SQL Servers; 11.2 Retrieving Database Metadata; 11.3 Retrieving Database Schema Information from SQL Server; 11.4 Retrieving Column Default Values from SQL Server; 11.5 Determining the Length of Columns in a SQL Server Table; 11.6 Retrieving a SQL Server Query Plan; 11.7 Retrieving SQL Server Column Metadata Without Returning Data; 11.8 Creating a New SQL Server Database; 11.9 Adding a Table to a SQL Server Database; 11.10 Creating a Database Table from a DataTable Schema; 11.11 Creating DataSet Relationships from SQL Server Relationships; 11.12 Creating a New Microsoft Access Database; 11.13 Listing Tables in an Access Database; 11.14 Enumerating .NET Data Providers; 11.15 Enumerating OLE DB Providers; 11.16 Enumerating ODBC Drivers; 11.17 Changing a SQL Server User Password;
Chapter 12: SQL Server CLR Integration; 12.0 Introduction; 12.1 Creating a Stored Procedure; 12.2 Creating a Scalar-Valued Function; 12.3 Creating a Table-Valued Function; 12.4 Creating an Aggregate Function; 12.5 Creating a User-Defined Type; 12.6 Creating a DML Trigger; 12.7 Creating a DDL Trigger;
What's New in ADO.NET Since Version 1.0; A.1 ADO.NET 2.0; A.2 ADO.NET 3.5;
Colophon;
Descriere
Gives you more than 150 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. This book also offers explanations of how and why each code solution works, warns you of potential pitfalls, and cites sources of additional information.