Coverart for item
The Resource Microsoft ADO.NET 4 step by step, Tim Patrick

Microsoft ADO.NET 4 step by step, Tim Patrick

Label
Microsoft ADO.NET 4 step by step
Title
Microsoft ADO.NET 4 step by step
Statement of responsibility
Tim Patrick
Creator
Subject
Genre
Language
eng
Summary
Provides tutorials and examples on using ADO.NET 4 to create datacentric applications for Windows and the Web
Member of
Cataloging source
N$T
http://library.link/vocab/creatorDate
1966-
http://library.link/vocab/creatorName
Patrick, Tim
Dewey number
005.758
Illustrations
illustrations
Index
index present
LC call number
QA76.9.D26
LC item number
P38 2010eb
Literary form
non fiction
Nature of contents
dictionaries
http://library.link/vocab/subjectName
  • Database design
  • Object-oriented programming (Computer science)
  • COMPUTERS
  • Database design
  • Object-oriented programming (Computer science)
  • Database design
  • Computer programming
  • Microsoft .NET
Label
Microsoft ADO.NET 4 step by step, Tim Patrick
Instantiates
Publication
Antecedent source
unknown
Carrier category
online resource
Carrier category code
  • cr
Carrier MARC source
rdacarrier
Color
multicolored
Content category
text
Content type code
  • txt
Content type MARC source
rdacontent
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
Control code
776202219
Dimensions
unknown
Extent
1 online resource (xxiii, 411 pages)
File format
unknown
Form of item
online
Isbn
9780735657137
Lccn
2012472718
Level of compression
unknown
Media category
computer
Media MARC source
rdamedia
Media type code
  • c
Other physical details
illustrations
http://library.link/vocab/ext/overdrive/overdriveId
cl0500000094
Quality assurance targets
not applicable
Reformatting quality
unknown
Sound
unknown sound
Specific material designation
remote
System control number
(OCoLC)776202219
Label
Microsoft ADO.NET 4 step by step, Tim Patrick
Publication
Antecedent source
unknown
Carrier category
online resource
Carrier category code
  • cr
Carrier MARC source
rdacarrier
Color
multicolored
Content category
text
Content type code
  • txt
Content type MARC source
rdacontent
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
Control code
776202219
Dimensions
unknown
Extent
1 online resource (xxiii, 411 pages)
File format
unknown
Form of item
online
Isbn
9780735657137
Lccn
2012472718
Level of compression
unknown
Media category
computer
Media MARC source
rdamedia
Media type code
  • c
Other physical details
illustrations
http://library.link/vocab/ext/overdrive/overdriveId
cl0500000094
Quality assurance targets
not applicable
Reformatting quality
unknown
Sound
unknown sound
Specific material designation
remote
System control number
(OCoLC)776202219

Library Locations

    • Ellis LibraryBorrow it
      1020 Lowry Street, Columbia, MO, 65201, US
      38.944491 -92.326012
    • Engineering Library & Technology CommonsBorrow it
      W2001 Lafferre Hall, Columbia, MO, 65211, US
      38.946102 -92.330125
Processing Feedback ...