Snotra Tech Oracle Data Components for .NET provides connected dataset for data-aware components like DataGrid,
DataGridView and etc which is intented for Oracle database.
Snotra Tech Oracle Data Components extend standard functions and features of ADO.NET set of components
and provide advanced reliable and convenient way to work with Oracle database.
It supports automatically record locking, refreshing, server generated values
and allows you to create applications with a native database checks support, dynamically adopting changes
in the database without even recompiling it.
Snotra Tech Oracle Data Components for .NET solve following well known problems of ADO components:
Disconnected Model problem:
ADO.NET datasets use disconnected model which in return leads to validating input data problems.
Snotra Tech Oracle Data Components provide a way for validating input and provide events that enable you to fully exploit the integrity constraints of your Oracle database;
Multiuser system problem:
ADO.NET components does not support multi-user environment which is one of Oracle server major features, thus allowing multiple users to change a specific record in the same time feature will not be applicable if using ADO.NET components. Using Snotra Tech Oracle Data Components you can easily decide if records should be locked when any user starts to edit them, when a record is posted to the database, or not to be locked at all;
Urgency of data problem:
Records in Oracle database can sometimes be different from those records in the Data Table. Using Snotra Tech Oracle Data Components you can rest assured that your Oracle database users will always work with the actual image of a database record;
Too much set of selected data problem:
One of the major flows of ADO.NET components is that ADO.NET Data Tables select all the data according to the SQL select expression included in the component from the Oracle database and store this data on memory.
Using Snotra Tech Oracle Data Components dataset you can easily select data from Oracle database partially, according to the size of visible data-aware component.
Key features are:
Validating input and Oracle errors check;
Record locking;
Record refreshing;
Support cursor variables;
Updating complex query results;
Easy way to make datatable updateable;
Partial data selection.
Snotra Tech Oracle Data Components based on Oracle Data Provider for .NET.
Components are especially worth to use for applications that work under multiuser concurrent environment.
