|
" Microsoft ADO.NET 4 step by step "
Tim Patrick.
| Document Type
|
:
|
BL
|
| Record Number
|
:
|
572382
|
| Doc. No
|
:
|
GBB058143b401601
|
| Main Entry
|
:
|
Patrick, Tim,1966-
|
| Title & Author
|
:
|
Microsoft ADO.NET 4 step by step\ Tim Patrick.
|
| Publication Statement
|
:
|
Sebastopol, Calif. :: O'Reilly Media,, c2010.
|
| ISBN
|
:
|
9780735638884
|
|
|
:
|
: 0735638888
|
| Notes
|
:
|
Includes index.
|
| Contents
|
:
|
Part I. Getting to Know ADO.NET -- 1. Introducing ADO.NET 4 -- What is ADO.NET? -- Why ADO.NET? -- Major Components of ADO.NET -- Extensions to ADO.NET -- Connecting to External Data -- Summary -- Chapter 1. Quick Reference -- 2. Building Tables of Data -- Implementing Tables -- Logical and Physical Table Implementations -- The DataTable Class -- Adding Data Columns -- Dataset Designer -- Summary -- Chapter 2. Quick Reference -- 3. Storing Data in Memory -- Adding Data -- Creating New Rows -- Defining Row Values -- Storing Rows in a Table -- Examining and Changing Data -- Removing Data -- Batch Processing -- Row State -- Row Versions -- Validating Changes -- Exception-Based Errors -- Validation-Based Errors -- Summary -- Chapter 3. Quick Reference -- 4. Accessing the Right Data Values -- Querying and Sorting Data -- Finding Rows by Primary Key -- Selecting Rows with a Search Criteria -- Sorting Search Results -- Performing Case-Sensitive Lookups -- Using Expression Columns -- Summary -- Chapter 4. Quick Reference -- 5. Bringing Related Data Together -- Collecting Tables into Sets -- Establishing Relationships Between Tables -- Understanding Table Relations -- Creating Data Relations -- Locating Parent and Child Records -- Defining Table Constraints -- Summary -- Chapter 5. Quick Reference -- 6. Turning Data into Information -- Aggregating Data -- Generating a Single Aggregate -- Adding an Aggregate Column -- Aggregating Data Across Related Tables -- Referencing Parent Fields in Expressions -- Setting Up Indexed Views -- Creating a DataView -- Using a DataView -- Summary -- Chapter 6. Quick Reference -- 7. Saving and Restoring Data -- Serializing DataSet and DataTable Objects -- Writing XML -- Reading XML -- Guiding XML Generation -- Identifying Namespaces -- Nesting Child Tables -- Managing and Positioning Columns -- Summary -- Chapter 7. Quick Reference -- Part II. Connecting to External Data Sources -- 8. Establishing External Connections -- Using Connection Strings -- SQL Server Connection Strings -- OLE DB and ODBC Connection Strings -- Connection String Builders -- Storing Connection Strings -- Understanding Data Providers -- Connecting to SQL Server via a Data Provider -- Creating and Opening Connections -- Connection Pooling -- Summary -- Chapter 8. Quick Reference -- 9. Querying Databases -- Processing SQL Queries -- Creating Command Objects -- Processing Queries -- Processing Asynchronously -- Returning Query Results -- Returning a Single Value -- Returning Data Rows -- Accessing Field Values -- Processing More Complicated Results -- Summary -- Chapter 9. Quick Reference -- 10. Adding Standards to Queries -- Developing Parameterized Queries -- Understanding the Need for Parameters -- Implementing Standard Queries -- Using Parameters with Other Providers -- Using Parameters in Stored Procedures -- Summary -- Chapter 10. Quick Reference -- 11. Making External Data Available Locally -- Understanding Data Adapters -- Moving Data from Source to Memory -- Moving Data into a DataTable -- Moving Data into a DataSet -- Moving Data from Memory to Source -- Configuring the Update Commands -- Performing the Update -- Generating Update Commands Automatically -- Table and Column Mapping -- Summary -- Chapter 11. Quick Reference -- 12. Guaranteeing Data Integrity -- Transactions and Concurrency -- Using Local Transactions -- Employing Savepoints -- Using Distributed Transactions -- Summary -- Chapter 12. Quick Reference -- Part III. Entity Framework -- 13. Introducing the Entity Framework -- Understanding the Entity Framework -- Defining the Entity Framework's Terms -- Understanding the Entity Framework's Layers -- Understanding the Conceptual Model -- Understanding the Storage Model -- Understanding the Model Mappings -- Using the Entity Framework -- Building the Model -- Generating the Objects -- Instantiating the Context -- Running Framework Queries -- Summary -- Chapter 13. Quick Reference -- 14. Visualizing Data Models -- Designing an Entity Framework Model -- Using the Entity Data Model Wizard -- Entity Data Model Designer -- Working with the Mapping Details Panel -- Using the Model Browser -- Managing the Object Layer -- Summary -- Chapter 14. Quick Reference -- 15. Querying Data in the Framework -- Getting to Know Entity SQL -- Writing Basic Queries -- Using Literals, Operators, and Expressions -- Grouping and Aggregating Entity Data -- Using Features Unique to Entity SQL -- Running Entity SQL Queries -- Running Queries Using an ObjectQuery -- Running Queries Using a Provider -- Summary -- Chapter 15. Quick Reference -- 16. Understanding Entities Through Objects -- Managing Entity Data Through Objects -- Accessing Entity Data through Objects -- Modifying Entity Data through Objects -- Using Query Builder Methods -- Queryable Extension Methods -- Summary -- Chapter 16. Quick Reference -- Part IV. Linq -- 17. Introducing LINQ -- Getting to Know LINQ -- Using LINQ with .NET Objects -- Starting a Query with the From Clause -- Projecting Results with the Select Clause -- Filtering Results with the Where Clause -- Sorting Results with the Order By Clause -- Selecting Linked Results with the Join Keyword -- Limiting the Queried Content -- Summarizing Data Using Aggregates -- Applying Set Operations -- Summary -- Chapter 17. Quick Reference -- 18. Using LINQ to DataSet -- Understanding the LINQ to DataSet Provider -- Writing Queries with LINQ to DataSet -- Summary -- Chapter 18. Quick Reference -- 19. Using LINQ to Entities -- Understanding the LINQ to Entities Provider -- Writing Queries with LINQ to Entities -- Working with Entity and Database Functions -- Working with Custom Database Functions -- Summary -- Chapter 19. Quick Reference -- 20. Using LINQ to SQL -- Understanding the LINQ to SQL Provider -- Comparing LINQ to SQL with LINQ to Entities -- Understanding the Components of LINQ to SQL -- Using the Object Relational Designer -- Using Custom Database Functions in Queries -- Summary -- Chapter 20. Quick Reference -- Part V. Presenting Data to the World -- 21. Binding Data with ADO.NET -- Binding Data in Windows Forms -- Creating Complex-Bound Applications -- Creating Simple-Bound Applications -- Understanding Windows Forms Data Binding -- Binding Data in WPF -- Creating Data-Bound WPF Applications -- Understanding WPF Data Binding -- Binding Data in ASP.NET -- Creating Data-Bound ASP.NET Applications -- Understanding ASP.NET Data Binding -- Summary -- Chapter 21. Quick Reference -- 22. Providing RESTful Services with WCF Data Services -- Getting to Know the Service Layers -- Introducing WCF Data Services -- Introducing REST -- Setting Up a Data Service -- Defining Service Rights -- Accessing a Data Service using REST -- Querying Entities with REST -- Updating Entities with REST -- Summary -- Chapter 22. Quick Reference.
|
| Abstract
|
:
|
Provides tutorials and examples on using ADO.NET 4 to create datacentric applications for Windows and the Web.
|
| Subject
|
:
|
Database design.
|
| Subject
|
:
|
Object-oriented programming (Computer science)
|
| |