|
Provided by: Affinity IT Training, LLC ADO NET Using Oracle and C |
 |
Training
Provided by Affinity IT Training, LLC
This course presents
the essential elements of ADO.NET and how
to build effective Oracle database applications.
The course includes coverage of
the Oracle Data Provider for .NET (ODP.NET).
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.
Audience:C# .NET Application Developers seeking to integrate Oracle datasources into their applications.
|
|
||||||||||
ADO NET Using Oracle and C
Objectives
- Understand the namespaces and classes comprising ADO .NET
- Understand how to integrate Database connections into .NET Applications
- Be familiar with the relationship between XML and ADO .NET
- Be familiar with advanced capabilities such as managing concurrency and transactions
- Be familiar with advanced capabilities available with Oracle Data Sources
Outline
Database Application Basics
Data Modeling
Data Modeling - Key Concepts
Conceptual Model
Logical Model
Physical Data Model
Performance Considerations
Performance Considerations
Acme Computer Case Study
Buy Computer
Model
Component
Part
PartsConfiguration
System
Tracking the System ID
SystemDetails
StatusCode
Relationships
Stored Procedure
Additional Tables
Moving to ADO.NET
Microsoft Data Access Technologies
ODBC
OLE DB
ActiveX Data Objects (ADO)
ADO Is Connection Oriented
ADO Example
ADO.NET
ADO.NET Architecture
.NET Data Providers
ADO.NET Connected Example
ADO.NET DataSet Example
ADO.NET Basics
ADO.NET Block Diagram
.NET Data Providers
Namespaces for .NET Data Providers
Oracle Data Provider for .NET
Basic Connection Programming
Using Interfaces
IDbConnection Properties
Connection String
ODP.NET Connection String
OLE DB Connection String
OLE DB Connection Example
IDbConnection Methods
Connection Life Cycle
ODPConnect (Step 2)
Connection Pooling
Pool Settings for Oracle
Connection Demo Program
Connection Events
Connection Event Demo
ADO.NET Error Handling
DataReader
Using a DataReader
IDataRecord
Type-Safe Accessors
Finding the .NET Type
Setup
- Internet Explorer 6 (or equivalent)
- Microsoft Visual Studio C# .NET
- Access to Oracle 8+
- Internet Access (preferred)
Seminar Pre-Requisites
- Programming experience in a high-level language.
- ITCW_CS_Essentials.xml
- ASP .NET Using C#
- Intro To Oracle 9i (or equivalent)
Training Materials
- Course Workbook
1.0
About The Training Provider: Affinity IT Training, LLC
Affinity IT Training, LLC - .
We are a provider of hands-on, instructor-led IT training for the global business community including website development, databases, programming languages and more. Training includes: ASP, .NET, C#, C , DB2, AJAX, JavaScript, HTML/XHTML/XML, Unix, Linux, Perl, Python, Ruby On Rails, Oracle, Sybase, SQL Server, Project Management Training and customized Integrated Case Study.
