Microsoft ADO.NET 4 step by step /

Provides tutorials and examples on using ADO.NET 4 to create datacentric applications for Windows and the Web.

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autor principal: Patrick, Tim, 1966-
Formato: Electrónico eBook
Idioma:Inglés
Publicado: Sebastopol, Calif. : O'Reilly Media, ©2010.
Temas:
Microsoft .NET Framework.
Microsoft LINQ.
Microsoft LINQ
Microsoft .NET Framework
ActiveX.
SQL server (Computer software)
Database design.
Object-oriented programming (Computer science)
Bases de données > Conception.
Programmation orientée objet (Informatique)
COMPUTERS > Data Processing.
Database design
Computer programming.
Microsoft .NET.
Acceso en línea:Texto completo (Requiere registro previo con correo institucional)
Tabla de Contenidos:
  • 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.

Ejemplares similares