book

Microsoft® ADO.NET 4 Step by Step

Name: Microsoft® ADO.NET 4 Step by Step
Author: Tim Patrick
ISBN: 9780735656260

by Tim Patrick

October 2010

Beginner to intermediate

400 pages

11h 24m

English

Microsoft Press

Read now

Unlock full access

Microsoft® ADO.NET 4 Step by Step
Table of Contents
Dedication
Acknowledgments
Introduction
Who Is This Book For?AssumptionsAssumptionsOrganization of This BookFinding Your Best Starting Point in This BookConventions and Features in This BookSystem RequirementsCode SamplesInstalling the Code SamplesInstalling the Sample DatabaseUsing the Code SamplesUninstalling the Code SamplesSoftware ReleaseErrata and Book SupportWe Want to Hear from YouStay in Touch
I. Getting to Know ADO.NET
1. Introducing ADO.NET 4
What Is ADO.NET?Why ADO.NET?Major Components of ADO.NETExtensions to ADO.NETConnecting to External DataCreating a Data Source Using the Connection WizardSummaryChapter 1 Quick Reference
2. Building Tables of Data
Implementing TablesLogical and Physical Table ImplementationsThe DataTable ClassCreating a DataTable: C#Creating a DataTable: Visual BasicAdding Data ColumnsAdding Columns to a DataTable: C#Adding Columns to a DataTable: C#Adding Columns to a DataTable: Visual BasicDataset DesignerCreating a Custom Table in the Dataset DesignerCreating a Custom Table in the Dataset DesignerAdding a Database Table to the Dataset DesignerUsing Dataset Designer Tables in CodeSummaryChapter 2 Quick Reference
3. Storing Data in Memory
Adding DataCreating New RowsDefining Row ValuesStoring Rows in a TableAdding Rows to a DataTable: C#Adding Rows to a DataTable: Visual BasicExamining and Changing DataModifying Existing Rows in a DataTable: C#Modifying Existing Rows in a DataTable: C#Modifying Existing Rows in a DataTable: Visual BasicRemoving DataBatch ProcessingRow StateRow VersionsValidating ChangesException-Based ErrorsValidation-Based ErrorsValidating Content in a DataRow: C#Validating Content in a DataRow: Visual BasicSummaryChapter 3 Quick Reference
4. Accessing the Right Data Values
Querying and Sorting DataFinding Rows by Primary KeyFinding a Row by Primary Key: C#Finding a Row by Primary Key: Visual BasicSelecting Rows with a Search CriteriaSorting Search ResultsSelecting and Sorting DataRow Objects: C#Selecting and Sorting DataRow Objects: Visual BasicPerforming Case-Sensitive LookupsUsing Expression ColumnsAdding Expression Columns to a DataTable: C#Adding Expression Columns to a DataTable: C#Adding Expression Columns to a DataTable: Visual BasicSummaryChapter 4 Quick Reference

5. Bringing Related Data Together
Collecting Tables into SetsAdding Tables to a DataSet: C#Adding Tables to a DataSet: C#Adding Tables to a DataSet: Visual BasicEstablishing Relationships Between TablesUnderstanding Table RelationsCreating Data RelationsAdding a Relationship Between Two Tables: C#Adding a Relationship Between Two Tables: Visual BasicLocating Parent and Child RecordsDefining Table ConstraintsDefining the Update and Delete Rules in a DataRelation: C#Defining the Update and Delete Rules in a DataRelation: C#Defining the Update and Delete Rules in a DataRelation: Visual BasicSummaryChapter 5 Quick Reference
6. Turning Data into Information
Aggregating DataGenerating a Single AggregateComputing an Aggregate Value: C#Computing an Aggregate Value: Visual BasicAdding an Aggregate ColumnAggregating Data Across Related TablesReferencing Parent Fields in ExpressionsSetting Up Indexed ViewsCreating a DataViewUsing a DataViewGenerating a New DataTable from a DataView: C#Generating a New DataTable from a DataView: Visual BasicSummaryChapter 6 Quick Reference
7. Saving and Restoring Data
Serializing DataSet and DataTable ObjectsWriting XMLReading XMLGuiding XML GenerationIdentifying NamespacesNesting Child TablesManaging and Positioning ColumnsGenerating XML from a DataSet: C#Generating XML from a DataSet: Visual BasicSummaryChapter 7 Quick Reference
II. Connecting to External Data Sources
8. Establishing External Connections
Using Connection StringsSQL Server Connection StringsOLE DB and ODBC Connection StringsConnection String BuildersStoring Connection StringsUnderstanding Data ProvidersConnecting to SQL Server via a Data ProviderCreating and Opening ConnectionsOpening a Database Connection: C#Opening a Database Connection: Visual BasicConnection PoolingSummaryChapter 8 Quick Reference
9. Querying Databases
Processing SQL QueriesCreating Command ObjectsProcessing QueriesProcessing AsynchronouslyReturning Query ResultsReturning a Single ValueReturning Data RowsAccessing Field ValuesProcessing More Complicated ResultsProcessing Database Queries: C#Processing Database Queries: Visual BasicSummaryChapter 9 Quick Reference
10. Adding Standards to Queries
Developing Parameterized QueriesUnderstanding the Need for ParametersImplementing Standard QueriesUpdating Data with Parameters: C#Updating Data with Parameters: Visual BasicUsing Parameters with Other ProvidersUsing Parameters in Stored ProceduresCalling a Stored Procedure with Parameters: C#Calling a Stored Procedure with Parameters: C#Calling a Stored Procedure with Parameters: Visual BasicSummaryChapter 10 Quick Reference
11. Making External Data Available Locally
Understanding Data AdaptersMoving Data from Source to MemoryMoving Data into a DataTableMoving Data into a DataSetMoving Data from Memory to SourceConfiguring the Update CommandsPerforming the UpdateGenerating Update Commands AutomaticallySyncing Data with a SqlDataAdapter: C#Syncing Data with a SqlDataAdapter: Visual BasicTable and Column MappingSummaryChapter 11 Quick Reference
12. Guaranteeing Data Integrity
Transactions and ConcurrencyUsing Local TransactionsProcessing with a Local Transaction: C#Processing with a Local Transaction: C#Processing with a Local Transaction: Visual BasicEmploying SavepointsUsing Distributed TransactionsProcessing with a Distributed Transaction: C#Processing with a Distributed Transaction: C#Processing with a Distributed Transaction: Visual BasicSummaryChapter 12 Quick Reference
III. Entity Framework
13. Introducing the Entity Framework
Understanding the Entity FrameworkDefining the Entity Framework’s TermsUnderstanding the Entity Framework’s LayersUnderstanding the Conceptual ModelUnderstanding the Storage ModelUnderstanding the Model MappingsUsing the Entity FrameworkBuilding the ModelGenerating the ObjectsInstantiating the ContextRunning Framework QueriesSummaryChapter 13 Quick Reference
14. Visualizing Data Models
Designing an Entity Framework ModelUsing the Entity Data Model WizardImporting Database Tables as EntitiesEntity Data Model DesignerCreating a Complex Property from Scalar PropertiesWorking with the Mapping Details PanelAdding a Mapping Condition to an EntityUse a Stored Procedure to Manage Entity DataUsing the Model BrowserManaging the Object LayerSummaryChapter 14 Quick Reference
15. Querying Data in the Framework
Getting to Know Entity SQLWriting Basic QueriesUsing Literals, Operators, and ExpressionsGrouping and Aggregating Entity DataUsing Features Unique to Entity SQLRunning Entity SQL QueriesRunning Queries Using an ObjectQueryRetrieving Entity Data Through an ObjectQuery: C#Retrieving Entity Data Through an ObjectQuery: Visual BasicRunning Queries Using a ProviderRetrieving Entity Data Through a Provider: C#Retrieving Entity Data Through a Provider: Visual BasicSummaryChapter 15 Quick Reference
16. Understanding Entities Through Objects
Managing Entity Data Through ObjectsAccessing Entity Data Through ObjectsModifying Entity Data Through ObjectsModifying a Database Through Entity Objects: C#Modifying a Database Through Entity Objects: Visual BasicUsing Query Builder MethodsQueryable Extension MethodsUsing Query Builder Methods: C#Using Query Builder Methods: Visual BasicSummaryChapter 16 Quick Reference
IV. LINQ
17. Introducing LINQ
Getting to Know LINQUsing LINQ with .NET ObjectsStarting a Query with the From ClauseProjecting Results with the Select ClauseFiltering Results with the Where ClauseSorting Results with the Order By ClauseSelecting Linked Results with the Join KeywordLimiting the Queried ContentSummarizing Data Using AggregatesApplying Set OperationsSummaryChapter 17 Quick Reference
18. Using LINQ to DataSet
Understanding the LINQ to DataSet ProviderWriting Queries with LINQ to DataSetQuerying with LINQ to DataSet: C#Querying with LINQ to DataSet: Visual BasicSummaryChapter 18 Quick Reference
19. Using LINQ to Entities
Understanding the LINQ to Entities ProviderWriting Queries with LINQ to EntitiesQuerying with LINQ to Entities: C#Querying with LINQ to Entities: C#Querying with LINQ to Entities: Visual BasicWorking with Entity and Database FunctionsWorking with Custom Database FunctionsCalling Custom Database Functions: C#Calling Custom Database Functions: Visual BasicSummaryChapter 19 Quick Reference
20. Using LINQ to SQL
Understanding the LINQ to SQL ProviderComparing LINQ to SQL with LINQ to EntitiesUnderstanding the Components of LINQ to SQLUsing the Object Relational DesignerBuilding a LINQ to SQL ModelBuilding a LINQ to SQL ModelUsing Custom Database Functions in QueriesQuerying with LINQ to SQL: C#Querying with LINQ to SQL: C#Querying with LINQ to SQL: Visual BasicSummaryChapter 20 Quick Reference
V. Presenting Data to the World
21. Binding Data with ADO.NET
Binding Data in Windows FormsCreating Complex-Bound ApplicationsCreating a Complex Data-Bound FormCreating Simple-Bound ApplicationsCreating a Simple Data-Bound FormUnderstanding Windows Forms Data BindingBinding Data in WPFCreating Data-Bound WPF ApplicationsCreating a Data-Bound WPF ProjectAdding Navigation to a Data-Bound WPF Window: C#Adding Navigation to a Data-Bound WPF Window: Visual BasicUnderstanding WPF Data BindingBinding Data in ASP.NETCreating Data-Bound ASP.NET ApplicationsCreating a Data-Bound ASP.NET PageUnderstanding ASP.NET Data BindingSummaryChapter 21 Quick Reference
22. Providing RESTful Services with WCF Data Services
Getting to Know the Service LayersIntroducing WCF Data ServicesIntroducing RESTSetting Up a Data ServiceCreating a Data Service from an EF Model: C#Creating a Data Service from an EF Model: C#Creating a Data Service from an EF Model: Visual BasicDefining Service RightsAccessing a Data Service using RESTQuerying Entities with RESTUpdating Entities with RESTSummaryChapter 22 Quick Reference
Index
About the Author
Copyright

Content preview from Microsoft® ADO.NET 4 Step by Step

Chapter 9. Querying Databases

After completing this chapter, you will be able to:

Issue data-modifying queries on external data sources
Retrieve a table of records from a SQL Server database
Return the primary key value for a newly inserted database record

Despite its capability to work with data generated completely within an application, ADO.NET’s main purpose is to access and manipulate data in external data stores. To enable this query-and-update functionality on the source data platform, ADO.NET includes a “command” object, a wrapper around a platform-specific query that updates, inserts, or deletes target data; or returns single or multiple values from the data source.

This chapter introduces this command wrapper, and demonstrates how to process ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.

Julian F.

Head of Cybersecurity

I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.

Addison B.

Field Engineer

I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.

Amir M.

Data Platform Tech Lead

I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.

Mark W.

Embedded Software Engineer

Publisher Resources

ISBN: 9780735656260

Cloud Computing

Data Engineering

Data Science

AI & ML

Programming Languages

Software Architecture

IT/Ops

Security

Design

Business

Soft Skills

Microsoft® ADO.NET 4 Step by Step

by Tim Patrick

Chapter 9. Querying Databases

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.