ADO.NET USING ORACLE AND C#
Course Title: ADO.NET USING ORACLE AND C#
Course #: ADO6I
Duration: 3 days
Overview:
This 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.
Topics:
Database Application Basics
Appendix A - Acme Computer Case Study
Appendix B - Learning Resources
Audience: ADO.NET programmers.
Prerequisites: A basic knowledge of SQL and the .NET Framework using C#. A basic understanding of XML is helpful.
Course #: ADO6I
Duration: 3 days
Overview:
This 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.
Topics:
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
- Parts Configuration
- System
- Tracking the System ID
- SystemDetails
- StatusCode
- Relationships
- Stored Procedure
- 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
- 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
- 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
- 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 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
- 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
Audience: ADO.NET programmers.
Prerequisites: A basic knowledge of SQL and the .NET Framework using C#. A basic understanding of XML is helpful.
Clients
