Snotra Tech Articles

Annotation:
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. 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.

Annotation:
This tutorial describes how you can build a simple .NET application that uses the Snotra Tech Oracle Data Components to access and modify data in an Oracle Database.

Annotation:
This tutorial describes how you can build a master-detail .NET application that uses the Snotra Tech Oracle Data Components to access and modify data in an Oracle Database.

Annotation:
The most popular instrument to access database data for .NET applications is ADO.NET. This set of components contains three main classes those are used to manipulate and store data: DataReader, DataSet and DataAdapter. DataReader is only able to read data and can't work as data source for data-aware components like DataGridView; DataSet provides all interfaces to be a data source but disconnected model considers some restrictions that can become important for some kind of applications, especially for desktop programs that work under multiuser concurrent environment and change database data actively. Below we consider main restrictions and popular ways to solve them; non standard solutions is considered also.

Annotation:
Nowadays different databases are used in the majority of applications. Concerning .NET programs the most popular way to access databases is using ADO.NET components. It's not a secret that ADO.NET uses disconnected model and component named DataTable doesn't have such thing like current data row. But very often developers have to refresh current data row that can be changed by another application or server side logic. Below I consider solution of this problem for Oracle database, but the same way is suitable for other RDBMS.