© Snotra Tech 2006-2007
Author: Michael Milonov
Snotra Tech Adonet Oracle Data Components for .NET provides dataset which is intended for Oracle database.
Components extend standard functions and features of ADO.NET components and provide the possibility to use
pessimistic and optimistic concurrent models; refresh and lock single dataset's record, get server generated values,
utilize partial data selection. Components based on Microsoft .NET Managed Provider for Oracle and take .NET 2.0.
Snotra Tech Adonet Oracle Data Components provide two major components: STAdonetOracleConnection and
STAdonetOraDataTable.
STAdonetOracleConnection is used to connect to Oracle database. It's simply a wrapper for
System.Data.OracleClient.OracleConnection class. Instead STAdonetOracleConnection on could use
System.Data.OracleClient.OracleConnection.
STAdonetOraDataTable is main component, it represent Snotra Tech DataSet. It works like DataTable from
standard .NET 2.0 distributions, but in contract the one STAdonetOraDataTable uses
connected model and implements extra features like concurrent model selection, current row refreshing, partial data
selection, immediate database constraints checking, errors handling and so on.
This tutorial contains the number of
examples and explanations those, as I hope, allow you to understand main features of
Snotra Tech Adonet Oracle Data Components and start to work with them easy.
If you have any questions or remarks concerning this tutorial please feel free to send e-mail at
info@snotratech.com mailbox.
Prerequisites
Installation of Snotra Tech Adonet Oracle Data Components
First application
Problem to solve
Creating a Sample data table
Creating application
Making STAdonetOracleDataTable to be "ReadOnly"
Using automatic row refreshing
Using complex query in Snotra Tech Adonet Oracle Data Components
Problem to solve
Creating sample data table
Creating application
Adding and deleting rows
Refreshing current data row manually
Refreshing all records
Customising columns of STAdonetOracleDataTable
The selection of concurrent model
Errors handling
Partial data selection
Creating master-detail application
Problem to solve
Creating Sample data tables
Creating application
Editing data using master-detail application
Customizing columns collection of STAdonetOraDataTable
Using PL/SQL functions, ref cursors and ApplyRecord event
Problem to solve
Creating application
In brief
Creating lookup fields using Snotra Tech Adonet Oracle Data Components
Problem to solve
Creating application
Using Snotra Tech Adonet Oracle Data Components for console applications
Problem to solve
Creating application