| Course Description | |
| This three-day intensive course teaches the essential elements of ADO.NET for Web applications such that at the end of the course the programmer is able to utilize its tremendous database manipulation powers to build effective database applications. The course includes a major case study demonstrating the use of ADO.NET in a realistic setting. It is current to .NET 3.5, Visual Studio 2008 and SQL Server 2005/2008.
Course Length: 3 Days Course Tuition: $1190 (US) |
|
| Prerequisites | |
| A basic knowledge of SQL and of programming the .NET Framework using C#. The student should also understand the fundamentals of XML. To get full benefit from the examples in the course the student should be able to write simple ASP.NET Web Forms applications. A working knowledge of SQL Server is also desirable. | |
| Course Outline |
|
• Introduction to ADO.NET Microsoft Data Access Technologies ODBC OLE DB ActiveX Data Objects (ADO) Accessing SQL Server Before ADO.NET ADO.NET ADO.NET Architecture .NET Data Providers Programming with ADO.NET Interfaces .NET Namespaces Connected Data Access ADO.NET Class Libraries Connecting to an OLE DB Data Provider Using Commands Creating a Command Object ExecuteNonQuery Using a Data Reader Disconnected Datasets Data Adapters Buy Computer Model Component Part PartConfiguration System SystemId as Identity Column SystemDetails StatusCode Relationships Stored Procedure • ADO.NET Connections ADO.NET Block Diagram .NET Data Providers Namespaces for .NET Data Providers Basic Connection Programming Using Interfaces IDbConnection Properties Connection String SQL Server Connection String OLE DB Connection String SQL Server Security IDbConnection Methods BasicConnect (Step 2) Connection Life Cycle BasicConnect (Step 3) Database Application Front-ends ChangeDatabase Connection Pooling Pool Settings for SQL Server Connection Events ADO.NET Exception Handling • ADO.NET Commands Command Objects Creating Commands Executing Commands Dynamic Queries Parameterized Queries Command Types Stored Procedures Testing the Stored Procedure Stored Procedures in ADO.NET Batch Queries Transactions • DataReaders and Connected Access DataReader Using a DataReader Closing a DataReader IDataRecord Type-Safe Accessors GetOrdinal() Null Data Testing for Null ExecuteReader Options Returning Multiple Result Sets DataReader Multiple Results Sets Obtaining Schema Information • Data Sets and Disconnected Access DataSet DataSet Architecture Why DataSet? DataSet Components DataAdapter Data Access Class Retrieving the Data Filling a DataSet Accessing a DataSet Updating a DataSet Scenario Adding a New Row Searching and Updating a Row Deleting a Row Row Versions Row State BeginEdit and CancelEdit DataTable Events Updating a Database Insert Command Update Command Delete Command Exception Handling Command Builders |
• More About DataSets Filtering DataSets Using a Single DataTable Multiple Tables DataSet Architecture Schema in the DataSet Relations Navigating a DataSet Using Parent/Child Relation Inferring Schema AddWithKey Adding a Primary Key TableMappings Identity Columns Creating a Dataset Manually Manual DataSet Code • XML and ADO.NET ADO.NET and XML Rendering XML from a DataSet XmlWriteMode Reading XML into a DataSet DataSets and XML Schema ModelSchema.xsd Reading XML Schema XmlReadMode Writing Data as Attributes XML Data in DataTables Typed DataSets Table Adapter Using a Typed DataSet Synchronizing DataSets and XML Using XmlDataDocument Windows Client Code Web Client Code XML Serialization Default Constructor • Concurrency and Transactions DataSets and Concurrency Handling Concurrency Violations Pessimistic Concurrency Transactions Programming ADO.NET Transactions ADO.NET Transaction Code Using ADO.NET Transactions DataBase Transactions Transaction in Stored Procedure Testing the Stored Procedure SQL Server Error • Newer Features in ADO.NET and ASP.NET Data Access in ASP.NET 2.0 AcmePub Database Creating a Data Connection Using Server Explorer Performing a Query SQL Generation Options Enable Edit and Delete Editing Records GridView Control DetailsView Control Storing the Connection String Protecting the Configuration String Multiple Active Result Sets Bulk Copy Long Database Operations Asynchronous Operations • LINQ to ADO.NET Language Integrated Query (LINQ) LINQ to ADO.NET Bridging Objects and Data Object Relational Designer IntelliSense Basic LINQ Query Operators Obtaining a Data Source Filtering Ordering Aggregation Obtaining Lists and Arrays Deferred Execution Modifying a Data Source Performing Inserts via LINQ to SQL Performing Deletes via LINQ to SQL Performing Updates via LINQ to SQL LINQ to DataSet Using the Typed DataSet • Appendix A: Acme Computer Case Study Contact us for course schedules or more information. |
