Ado .Net Programming
by Joubert, Terrence J.; Payet, Ryan N.Edition: CD
Format: Paperback
Pub. Date: 2002-08-01
Publisher(s): Wordware
Other versions by this Author
List Price: $49.95
Rent Book
Select for Price
New Book
We're Sorry
Sold Out
Used Book
We're Sorry
Sold Out
eBook
We're Sorry
Not Available
How Marketplace Works:
- This item is offered by an independent seller and not shipped from our warehouse
- Item details like edition and cover design may differ from our description; see seller's comments before ordering.
- Sellers much confirm and ship within two business days; otherwise, the order will be cancelled and refunded.
- Marketplace purchases cannot be returned to eCampus.com. Contact the seller directly for inquiries; if no response within two days, contact customer service.
- Additional shipping costs apply to Marketplace purchases. Review shipping costs at checkout.
Summary
Aimed at database programmers with a working knowledge of the .NET Framework, this book dissects the ADO.NET coomponent model and provides real-world examples demonstrating how ADO.NET can be used to manipulate data from different sources.
Author Biography
Terrence J. Joubert is a software engineer for VCS. He specializes in Microsoft development tools Ryan N. Payet is the software team leader and system administrator for VCS. He has extensive experience with Microsoft SQL database technologies, .NET languages (VB .NET, C#, and C++), and various Microsoft Server technologies
Table of Contents
| Aims and Objectives | p. xiii |
| Introduction to ADO .NET | p. 1 |
| Growing up from ADO | p. 3 |
| In This Chapter | p. 3 |
| Architectural Differences | p. 3 |
| The ADO Architecture | p. 4 |
| Why Not Use ADO in .NET? | p. 5 |
| The ADO .NET Architecture | p. 7 |
| .NET Data Providers | p. 9 |
| In-Memory Data Representation | p. 10 |
| ADO: The Recordset Object | p. 10 |
| ADO .NET: The DataSet and DataTable Objects | p. 10 |
| Relationship Management | p. 12 |
| ADO: Using JOIN in SQL | p. 12 |
| ADO .NET: The DataRelation Object | p. 13 |
| Where is the Recordset? | p. 15 |
| Summary | p. 16 |
| ADO .NET Revealed | p. 17 |
| Interacting with Databases | p. 19 |
| In This Chapter | p. 19 |
| The Connection Object | p. 20 |
| Connection Object Properties | p. 21 |
| ConnectionString | p. 21 |
| Connection Timeout | p. 22 |
| Database | p. 22 |
| DataSource | p. 23 |
| Provider | p. 23 |
| ServerVersion | p. 23 |
| State | p. 24 |
| Connection Object Methods | p. 24 |
| BeginTransaction() | p. 24 |
| ChangeDatabase() | p. 25 |
| Close() | p. 25 |
| CreateCommand() | p. 26 |
| Dispose() | p. 26 |
| Equals() | p. 27 |
| GetType() | p. 27 |
| Open() | p. 28 |
| ToString() | p. 28 |
| Connecting Through SQL Server .NET Data Provider | p. 29 |
| The Command Object | p. 30 |
| Command Object Properties | p. 30 |
| CommandText | p. 30 |
| CommandTimeout | p. 30 |
| CommandType | p. 31 |
| Connection | p. 31 |
| Container | p. 32 |
| Parameters | p. 32 |
| Transaction | p. 32 |
| Command Object Methods | p. 33 |
| Cancel() | p. 33 |
| CreateParameter() | p. 33 |
| Dispose() | p. 34 |
| ExecuteNonQuery() | p. 34 |
| ExecuteReader() | p. 35 |
| ExecuteScalar() | p. 35 |
| ExecuteXmlReader() | p. 36 |
| GetType() | p. 36 |
| ToString() | p. 37 |
| The DataReader Object | p. 37 |
| DataReader Properties | p. 37 |
| Depth | p. 37 |
| FieldCount | p. 38 |
| IsClosed | p. 38 |
| Item([left angle bracket]colum_name as string[right angle bracket] or [left angle bracket]column_ordinal as integer[right angle bracket]) | p. 38 |
| RecordsAffected | p. 39 |
| DataReader Methods | p. 39 |
| Close() | p. 39 |
| CreateObjRef() | p. 39 |
| Equals() | p. 40 |
| GetBoolean() | p. 40 |
| GetByte() | p. 41 |
| GetBytes() | p. 41 |
| GetChar() | p. 42 |
| GetChars() | p. 43 |
| GetDataTypeName() | p. 43 |
| GetDateTime() | p. 44 |
| GetDecimal() | p. 44 |
| GetDouble() | p. 45 |
| GetFieldType() | p. 45 |
| GetFloat() | p. 46 |
| GetGuid() | p. 46 |
| GetHashCode() | p. 47 |
| GetInt16() | p. 47 |
| GetInt32() | p. 48 |
| GetInt64() | p. 49 |
| GetName() | p. 49 |
| GetOrdinal() | p. 50 |
| GetSchemaTable() | p. 50 |
| GetString() | p. 50 |
| GetTimeSpan() | p. 51 |
| GetValue() | p. 51 |
| GetValues() | p. 52 |
| IsDBNull() | p. 52 |
| NextResult() | p. 53 |
| Read() | p. 53 |
| The DataAdapter Object | p. 54 |
| SqlDataAdapter Constructor | p. 54 |
| New() | p. 55 |
| New(System.Data.SqlClient.SqlCommand) | p. 55 |
| New(command as String, connection as String) | p. 56 |
| New(command as String, connection as SqlClient.SqlConnection) | p. 56 |
| SqlDataAdapter Properties | p. 57 |
| AcceptChangesDuringFill | p. 57 |
| ContinueUpdateOnError | p. 58 |
| DeleteCommand | p. 58 |
| InsertCommand | p. 59 |
| MissingMappingAction | p. 59 |
| MissingSchemaAction | p. 60 |
| SelectCommand | p. 60 |
| TableMappings | p. 61 |
| UpdateCommand | p. 61 |
| SqlDataAdapter Methods | p. 62 |
| CreateObjRef() | p. 62 |
| Dispose() | p. 62 |
| Fill() | p. 63 |
| FillSchema() | p. 64 |
| Update() | p. 65 |
| Summary | p. 66 |
| Data Manipulation | p. 67 |
| In This Chapter | p. 67 |
| The DataSet Component | p. 68 |
| What is the DataSet? | p. 68 |
| When Do You Need the DataSet? | p. 69 |
| How is the DataSet Organized? | p. 70 |
| Core DataSet Properties | p. 71 |
| CaseSensitive | p. 71 |
| Container | p. 71 |
| DataSetName | p. 72 |
| DefaultViewManager | p. 72 |
| DesignMode | p. 72 |
| EnforceConstraints | p. 73 |
| ExtendedProperties | p. 73 |
| HasErrors | p. 73 |
| Locale | p. 74 |
| Namespace | p. 74 |
| Prefix | p. 74 |
| Relations | p. 75 |
| Site | p. 75 |
| Tables | p. 75 |
| Core DataSet Methods | p. 76 |
| AcceptChanges() | p. 76 |
| BeginInit() | p. 76 |
| Clear() | p. 77 |
| Clone() | p. 78 |
| Copy() | p. 78 |
| Dispose() | p. 79 |
| EndInit() | p. 79 |
| GetChanges() | p. 80 |
| GetService() | p. 80 |
| GetType() | p. 81 |
| GetXML() | p. 82 |
| GetXmlSchema() | p. 82 |
| HasChanges() | p. 83 |
| InferXmlSchema() | p. 84 |
| Merge() | p. 86 |
| ReadXml() | p. 88 |
| ReadXmlSchema() | p. 89 |
| RejectChanges() | p. 89 |
| Reset() | p. 90 |
| ToString() | p. 90 |
| WriteXml() | p. 91 |
| WriteXmlSchema() | p. 91 |
| DataSet.ExtendedProperties | p. 92 |
| Adding an Extended Property | p. 92 |
| Reading and Writing Values | p. 93 |
| DataTableCollection | p. 93 |
| DataRelationCollection | p. 94 |
| The Big Picture | p. 95 |
| Summary | p. 98 |
| Designing ADO .NET Applications | p. 99 |
| .NET Application Models | p. 99 |
| Windows Forms Applications | p. 99 |
| Form Data Binding | p. 100 |
| Common Scenarios for Data Binding | p. 102 |
| Data Access Strategy for Windows Forms Applications | p. 103 |
| Console Applications | p. 104 |
| Data Access Strategy for Console Applications | p. 104 |
| Windows Services Applications | p. 105 |
| Data Access Strategy for Windows Services | p. 105 |
| ASP .NET Web Applications | p. 106 |
| Web Forms | p. 107 |
| Data Access in Web Forms | p. 107 |
| Data to XML Web Services | p. 109 |
| Data Access Strategy for ASP .NET Applications | p. 115 |
| Data, Data Everywhere | p. 120 |
| Spec My Components | p. 120 |
| What is a Component in .NET? | p. 121 |
| When to Build Data Components | p. 121 |
| Component Design Guidelines | p. 122 |
| Component Implementation | p. 123 |
| Learning to Run | p. 125 |
| Connection Pooling | p. 125 |
| Stored Procedure or SQL Statement? | p. 127 |
| Which Data Type? | p. 127 |
| Data Warehousing | p. 128 |
| Tuning and Monitoring | p. 128 |
| Protecting the Application | p. 129 |
| Passwords, Users, and Access Rights | p. 129 |
| Application Information | p. 130 |
| Summary | p. 130 |
| XML Integration with ADO .NET | p. 131 |
| XML in .NET Frameworks | p. 131 |
| Architectural Overview and Design Goals | p. 131 |
| Standards Compliance | p. 132 |
| Extensibility | p. 132 |
| Pluggable Architecture | p. 132 |
| Performance | p. 133 |
| Tight Integration with ADO .NET | p. 133 |
| DOM: The XML Document Object Model | p. 134 |
| Nodes in .NET | p. 137 |
| Loading XML Documents in the DOM | p. 138 |
| Validating XML Documents | p. 139 |
| XML Integration with Relational Data | p. 143 |
| XML with MS SQL Server 2000 | p. 143 |
| DataSet and XML | p. 144 |
| DiffGrams | p. 145 |
| Working with ReadXml | p. 149 |
| Writing XML from DataSet | p. 152 |
| XML Schemas from DataSet | p. 154 |
| Typed DataSets from XSD Schema | p. 155 |
| DataSet and XmlDataDocument | p. 156 |
| Synchronizing DataSet with XmlDataDocument | p. 157 |
| Nested DataRelations | p. 159 |
| Creating DataSet Relational Schema from XML Schema | p. 164 |
| Creating from XML Schema (XSD) | p. 164 |
| Inferring from XML | p. 170 |
| Summary | p. 172 |
| Practical ADO .NET Programming (Part One) | p. 173 |
| In This Chapter | p. 173 |
| The Case Study | p. 174 |
| The Web Service | p. 175 |
| Designing the Web Service | p. 175 |
| OrderProcessingWS | p. 176 |
| Data Retrieval Methods | p. 176 |
| Implementing OrderProcessingWS | p. 177 |
| Setting Up IIS | p. 178 |
| Creating OrderProcessingWS Project | p. 179 |
| Web Service Namespace | p. 180 |
| Initialization Code | p. 181 |
| GetOrders Methods | p. 184 |
| GetOrderDetails Methods | p. 193 |
| GetFullOrders Methods | p. 195 |
| GetFullOrders Code | p. 201 |
| GetFullOrders_By_Customer Code | p. 205 |
| Summary | p. 207 |
| Practical ADO .NET Programming (Part Two) | p. 209 |
| In This Chapter | p. 209 |
| Data Update Methods | p. 209 |
| The Update Functions | p. 210 |
| The Protected Order Details Update Methods | p. 211 |
| The DeleteOrderDetails Method | p. 211 |
| The InsertOrderDetails Method | p. 214 |
| The UpdateOrderDetails Method | p. 216 |
| Concurrency Issues | p. 219 |
| The Protected Orders Update Methods | p. 220 |
| The sp_UpdateOrders Stored Procedure | p. 220 |
| The sp_InsertOrders Stored Procedure | p. 223 |
| The sp_DeleteOrders Stored Procedure | p. 227 |
| The UpdateOrders Method | p. 228 |
| The DeleteOrders Method | p. 232 |
| The InsertOrders Method | p. 234 |
| The FullUpdateOrder Method | p. 237 |
| Testing the Update Methods | p. 241 |
| Summary | p. 241 |
| Special Topics | p. 243 |
| Migrating ADO Applications | p. 245 |
| In This Chapter | p. 245 |
| Legacy of Time | p. 245 |
| Language Changes | p. 246 |
| What about COM? | p. 249 |
| .NET Framework Bidirectional Migration Support | p. 250 |
| ASP and ASP .NET | p. 250 |
| What about ADO? | p. 250 |
| To Migrate or Not to Migrate? | p. 257 |
| Migration Steps | p. 258 |
| Migrate the Clients | p. 258 |
| Create .NET Wrappers to COM Components | p. 258 |
| Migrate the Business Objects | p. 259 |
| Summary | p. 259 |
| Manipulating Multidimensional Data | p. 261 |
| In This Chapter | p. 261 |
| A Quick Primer on Analysis Services | p. 262 |
| Analysis Services Installation | p. 262 |
| System Requirements | p. 262 |
| Installation Components | p. 264 |
| Setup | p. 266 |
| Starting Up | p. 266 |
| Running Setup | p. 266 |
| Understanding the Data Source | p. 270 |
| The Relational Database | p. 271 |
| The OLAP Database | p. 272 |
| Populating the OLAP Database | p. 272 |
| How is the Data Stored? | p. 273 |
| PivotTable Service | p. 273 |
| OLEDB Provider for OLAP | p. 273 |
| Multidimensional Expressions (MDX) | p. 274 |
| ActiveX Data Object Multidimensional (ADO MD) | p. 274 |
| ADO MD Example | p. 284 |
| Using the CubeBrowser ActiveX Control | p. 285 |
| Summary | p. 297 |
| The Object-Oriented Features of VB .NET | p. 299 |
| Database Normalization | p. 325 |
| Views, Stored Procedures, and Triggers | p. 335 |
| Advanced SQL Query Techniques | p. 375 |
| Index | p. 417 |
| Table of Contents provided by Syndetics. All Rights Reserved. |
An electronic version of this book is available through VitalSource.
This book is viewable on PC, Mac, iPhone, iPad, iPod Touch, and most smartphones.
By purchasing, you will be able to view this book online, as well as download it, for the chosen number of days.
Digital License
You are licensing a digital product for a set duration. Durations are set forth in the product description, with "Lifetime" typically meaning five (5) years of online access and permanent download to a supported device. All licenses are non-transferable.
More details can be found here.
A downloadable version of this book is available through the eCampus Reader or compatible Adobe readers.
Applications are available on iOS, Android, PC, Mac, and Windows Mobile platforms.
Please view the compatibility matrix prior to purchase.