  
                     
|
| |
 |
ADO.NET USING ORACLE AND C#
| Course Description |
|
TThis three-day course teaches the essential elements of ADO.NET so that programmers are 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. The course uses Oracle as the database and includes coverage of the Oracle Data Provider for .NET (ODP.NET). The close relationship between ADO.NET and XML is covered in detail. There is a practical discussion of data binding and its use in both Windows Forms and Web Forms (ASP.NET) applications. Students will gain a familiarity with creating a Data Access Layer, as it applies to traditional three-tier application architecture, and will learn how to use it in their code.
Course Length: 3 Days
Course Tuition: $1190 (US)
|
| Prerequisites |
|
| A basic knowledge of SQL and the .NET Framework using C#. A basic understanding of XML is helpful.
|
• Database Application Basics
Data Modeling
Data Modeling – Key Concepts
Conceptual Model
Logical Model
Physical Data Model
Performance Considerations
ORACLE_SID Environment Variable
Model
Component
Part
Component Configuration
PartsConfiguration
System
Tracking the System ID
SystemDetails
StatusCode
Relationships
Stored Procedure
• ADO.NET Fundamentals
Microsoft Data Access Technologies
ODBC
OLE DB
ActiveX Data Objects (ADO
ADO Is Connection Oriented
ADO.NET Architecture
ADO.NET Block Diagram
.NET Data Providers
Namespaces for .NET Data Providers
Oracle Data Provider for .NET
Basic Connection Programming
Using Interfaces
IDbConnection Properties
ODP.NET Connection String
OLE DB Connection String
IDbConnection Methods
Connection Life Cycle
ODPConnect (Step 2)
Connection Pooling
Pool Settings for Oracle
Connection Events
ADO.NET Error Handling
DataReader
Using a DataReader
IDataRecord
Type-Safe Accessors
Finding the .NET Type
GetOrdinal
Null Data
Testing for Null
Using List Boxes
ADO.NET with ASP.NET
Web Client Isolation
Web Client Database Code
Use of Session State
Generic Collections and Data Binding
• ADO.NET Commands
Command Objects
Creating Commands
Executing Commands
Dynamic Queries
Parameterized Queries
OracleDbType Enumeration Type
Command Types
Stored Procedures
Testing the Stored Procedure
Stored Procedures in ADO.NET
Using an Oracle REF CURSOR
Client Program Using REF CURSOR
• Data Sets and Disonnected Access
DataSet Architecture
Why DataSet?
DataSet Components
DataAdapter
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
Command Builders
Filtering DataSets
|
• XML and ADO.NET
ADO.NET and XML
Rendering XML from a DataSet
XmlWriteMode
Writing Data As Attributes
Reading XML into a DataSet
DataSets and XML Schema
ModelSchema.xsd
Reading XML Schema
XmlReadMode
XML Data in DataTables
Typed DataSets
Table Adapter
Using the Typed Data Set
Synchronizing DataSets and XML
Using XmlDataDocument
XML Serialization
Default Constructor
• Data Binding
Data Binding Concept
Simple Data Binding
Binding to a List
Binding to DataGrid
DataGrid in Visual Studio 2005
Complex Data Binding
DataView
Filtering and Sorting
DataView and Data Binding
New Data Binding
BindingSource Architecture
Binding to a List
Setting up the Bindings
Category Class
Code in the Form
DataGridView Control
DataGridView Binding
Data Binding in ASP.NET
Web Forms Data Binding
• Creating and Using a Data Access Layer
One-Tier Systems
Disadvantages of One-Tier
PCs
PC LANs
Database Servers
Client/Server Systems
Fat Clients
Scalability and Flexibility
Three-Tier Systems
Application Servers
Benefits of Three-Tier Architecture
Three-Tier Architecture using .NET
User Interface Components
Designing User Process Components
Data Access Components
• Appendix A - Acme Computer Case Study
• Appendix B - Learning Resources
Contact us for course schedules or more
information.
|
|
|
|
|
|
|
