Softgroup .Net Data Objects

Softgroup .Net Data Objects is a .Net component that gives to developers powerful objects for accessing, editing, and updating data from a wide range of databases throw an internal system named "Scripts Drivers" .

With Softgroup .Net Data Objects developers can especially easy migrate old Microsoft Visual Basic data-oriented projects that use Microsoft ActiveX Data Objects (ADO) to Microsoft ADO.NET technology based on .NET Framework without rewriting many lines of code.

In fact in order to facilitate the migration of source code Softgroup .Net Data Objects contains most of same objects (with most same Properties and Methods) of Microsoft ADO (Connection, Recordset, Fields, Field etc.)

In addition Softgroup .Net Data Objects contains other useful SQL objects and functions to query, insert, update and delete tables data on a database using auto-generated standard SQL statements that can be executed in all supported databases.

The most common usage of Softgroup .Net Data Objects is to query and manipulate the structure of a relational or non-relational database, retrieve and display the results in an application, and let users make and save changes to the data.

Other tasks include:

• Open a Connection to a database
• Easy manipulation of database objects (Databases, Tables, Indexes, Primary Keys and Foreign Keys, Views, Procedures, Triggers, Groups, Users, Permissions etc?)
• Perform advanced operations on Databases like: enumerate existing databases, create or delete e database, backup or restore a database etc.
• Multilanguage advanced dialogs (with Unicode support) to Connect to a database, backup and restore operations (use of dialogs is optional)
• Querying a database using SQL and displaying the results
• Executing commands and stored procedures with parameters
• Dynamically create Recordset objects, to hold, navigate, and manipulate data like Microsoft ADO Recordset object also with Bookmark support
• Performing transactional database operations
• Transformation of a Recordset object to a .System.DataTable object
• Filtering and sorting local copies of database information based on run-time criteria
• Saving data from a database into an XML file
• A series of SQL objects and functions in order to standardize writing of SQL statements in your code (SQLSelect, SQLInsert, SQLUpdate and SQLDelete)
• Support for Unicode databases

Softgroup .Net Data Objects con be used as a standard way to write .Net data-oriented solutions that support most commercial databases types using one single component.

<b>Script Drivers</b>
A Script Driver is a .INI Windows file format that contains all the necessary instructions used by Softgroup .Net Data Objects objects for provide access to all supported database functionality.

With the standard installation many  Script Drivers are supplied for the most populars databases:

• Microsoft Access
• Microsoft SQL Server / MSDE
• Oracle
• IBM DB2
• MySQL
• PostgreSQL
• FireBird

Script Driver can use a specific data provider based on one of these Microsoft data access technologies:

• ODBC Drivers
• OLEDB Drivers
• .NET Data Providers

It is possible to create new Script Drivers using instructions included in the Script Driver manual supplied with the installation or you can download Script Drivers Guide.pdf from our site.

Requirements
Prior to running Setup to install the Softgroup .Net Data Objects, you must already have the .NET Framework 2.0 and Microsoft Visual Studio 2005 installed on the computer.

Documentation and informational resources
Softgroup .Net Data Objects has exhaustive documentation supplied with installation where every aspect of using the product is covered in details.

Support
If you have a question regarding Softgroup .Net Data Objects, take a look through list of Frequently Asked Questions or use support page to obtain information on how to contact Softgroup  .Net Data Objects support team.

Platforms supported:
Windows 2000, Windows XP, Windows Server 2003, .NET Windows, .NET Cross-Platform, .NET 2.0 Windows, Windows Vista