Snotra Tech Oracle Data Components and Adonet Oracle Data Components

Snotra Tech Oracle Data Components are superstructure over .NET Data Providers. Nowadays we support two .NET Data Providers: Microsoft .NET Managed Provider for Oracle and Oracle Data Provider for .NET (ODP.NET). So you can select Component's version, according .NET Provider for Oracle that is preferred for you.

Snotra Tech Oracle Data Components for .NET (ODP.NET) takes ODP.NET.
Snotra Tech Adonet Oracle Data Components for .NET takes Microsoft .NET Managed Provider for Oracle.

	Click to see online

Offline version (exe file) [size 1616 kB]

	Download to see offline

Key features

• 100% managed code
• Automatic record locking and refreshing
• Optimistic and pessimistic concurrent models
• Possibility to refresh individual record from database
• Automatic record refreshing after insert and update
• Validating input and Oracle errors check
• Design and develop highly customized database applications
• Make the datatable updateable easy
• Partial data selection
• Design-time editors
• Supports Oracle 10g, 9i, and 8i, including Personal and Express editions
• Easy to deploy
• Handle Oracle errors
• Automatically convert between Oracle internal datatypes and high-level language datatypes
• Call stored procedures easily
• Updating complex query results
• Cursor variables

One of the major strengths of Oracle Database is its capability to maintain data integrity within the database. You can use primary key, unique key, foreign key and check constraints for declarative integrity checking. If any procedural logic is required, you can use database triggers. This way your data is secure, no matter how it is updated. The easiest, convenient and reliable way for your .NET application to validate user input is to rely on the integrity constraints present inside the database. Snotra Tech Oracle Data Components provide this way for validating input and provide events that enable you to fully exploit the integrity constraints of your Oracle database.

The Oracle server is able to lock individual records in the database. This capability is very important for multiuser applications or then some server side logic modifies records. Using Snotra Tech Oracle Data Components you can control if records are locked when a user starts to edit them, when a record is posted to the database, or not at all.

Records in the database can sometimes differ from the records in the Data Table. Other users may have changed these records, or maybe there is some server side logic that modifies records as they are posted to the database. Using Snotra Tech Oracle Data Components you can rest assured that users will always work with the actual image of a database record.

Snotra Tech Oracle Data Components provide powerful and easy way to work with functions, those have cursor variables.

Sometimes your queries are too complex to allow them to be simply updated through a single table. The Snotra Tech Oracle Data Components dataset has special event that allows you to program your own lock, insert, update, delete and refresh actions. Several functions and procedures are provided that support this feature.

The Snotra Tech Oracle Data Components provides more convenient way opposite standard ADO.NET components to allow user update, insert and delete records using some data-aware visual components. It takes SQL expression to retrieve data from Oracle database. To be able to update records, a datatable needs to know the 'rowid' of every retrieved record. As long as you do not include rowid in the query, the AllowEdit, AllowNew and AllowDelete properties of the datatable remains false. SQL expressions for insert, delete, update, lock and refresh record STOraDataTable generate automatically, without any additional line of code. Of course you can overload its behavior using special event.

Snotra Tech Oracle Data Components dataset can select data from database partially, according to the size of visible data-aware component. And when user scrolls data in the data-aware component, it extracts data from database and putts on data table.

Editions

• Snotra Tech Adonet Oracle Data Components (SNOC.NET Adonet) Full Edition:

SNOC.NET Adonet 2.0.2.3 for .NET 2.x

• Snotra Tech Adonet Oracle Data Components (SNOC.NET Adonet) Demo:

SNOC.NET Adonet 2.0.2.3 for .NET 2.x

• Snotra Tech Oracle Data Components (SNOC.NET) Full Edition:

SNOC.NET 2.10.2.3 for .NET 2.x, ODP.NET 2.102.2.20 is required.
SNOC.NET 1.10.2.3 for .NET 1.x, ODP.NET 1.102.2.20 is required.
SNOC.NET 1.9.2.3 for .NET 1.x, ODP.NET 9.2.0.700 is required.
SNOC.NET 2.9.2.3 for .NET 2.x, ODP.NET 9.2.0.700 is required.

• Snotra Tech Oracle Data Components (SNOC.NET) Demo:

SNOC.NET 2.10.2.3 for .NET 2.x, ODP.NET 2.102.2.20 is required.
SNOC.NET 1.10.2.3 for .NET 1.x, ODP.NET 1.102.2.20 is required.
SNOC.NET 1.9.2.3 for .NET 1.x, ODP.NET 9.2.0.700 is required.
SNOC.NET 2.9.2.3 for .NET 2.x, ODP.NET 9.2.0.700 is required.

* Demo version of Snotra Tech Oracle Data Components limited by 5 columns in the STOraDataTable.

Compatibility

Snotra Tech Adonet Oracle Data Components for .NET supports Oracle 10g, 9i, and 8i, including Express and Personal editions. Snotra Tech Adonet Oracle Data Components work with .NET Framework 2.0 and can be used with the following development environments:

• Microsoft Visual Studio .NET 2005

Snotra Tech Oracle Data Components for .NET supports Oracle 10g, 9i, and 8i, including Express and Personal editions. Snotra Tech Oracle Data Components work with .NET Framework 1.x, 2.0 and can be used with the following development environments:

• Microsoft Visual Studio .NET 2005
• Microsoft Visual Studio .NET 2003
• Microsoft Visual Studio .NET 2002

Related products