Loading ad...
SQLBase .NET Data Provider
This .NET Framework Class Library is provided by Unify.
The class library is contained in the file Gupta.SQLBase.Data.DLL.
The class library is contained in the file Gupta.SQLBase.Data.DLL.
Coding
Add a reference to the assembly Gupta.SQLBase.Data and include the Gupta.SQLBase.Data namespace. Instantiate a new SQLBaseConnection connection object. Set the connection string and open the connection.
VB.NET code sample
C# code sample
VB.NET code sample
Imports Gupta.SQLBase.Data
Dim myConnection As SQLBaseConnection = New SQLBaseConnection()
myConnection.ConnectionString = myConnectionString
myConnection.Open()
' execute queries, etc
myConnection.Close()
Dim myConnection As SQLBaseConnection = New SQLBaseConnection()
myConnection.ConnectionString = myConnectionString
myConnection.Open()
' execute queries, etc
myConnection.Close()
C# code sample
using Gupta.SQLBase.Data;
SQLBaseConnection myConnection = new SQLBaseConnection();
myConnection.ConnectionString = myConnectionString;
myConnection.Open();
// execute queries, etc
myConnection.Close();
SQLBaseConnection myConnection = new SQLBaseConnection();
myConnection.ConnectionString = myConnectionString;
myConnection.Open();
// execute queries, etc
myConnection.Close();
Description
The current version of SQLBase provides objects that implement eight of the .NET interfaces. The vast majority of their functionality is identical to that described in the .NET Framework documentation for the class library.
SQLBaseConnection: implements the IDbConnection interface, establishes a connection to a specific data source.
SQLBaseCommand: implements the IDbCommand interface, executes a command against a data source, exposes parameters and can execute within the scope of a Transaction.
SQLBaseDataReader: implements the IDataReader interface and reads a scrollable, read-only stream of data from a data source.
SQLBaseDataAdapter: implements the IDataAdapter interface; populates a DataSet and resolves updates with the data source.
SQLBaseTransaction: implements the IDbTransaction interface and represents a transaction to be performed at a data source.
SQLBaseParameter: implements the IDataParameter interface, represents a parameter which can be passed to a SQL command.
SQLBaseParameters: implements the IDataParameters interface, which is a simple collection of SQLBaseParameter objects.
In addition to these eight objects, SQLBase provides SQLBaseException, a public interface/object which is used for throwing exceptions to a client in case of a SQLBase error during a client method call.
SQLBaseConnection: implements the IDbConnection interface, establishes a connection to a specific data source.
SQLBaseCommand: implements the IDbCommand interface, executes a command against a data source, exposes parameters and can execute within the scope of a Transaction.
SQLBaseDataReader: implements the IDataReader interface and reads a scrollable, read-only stream of data from a data source.
SQLBaseDataAdapter: implements the IDataAdapter interface; populates a DataSet and resolves updates with the data source.
SQLBaseTransaction: implements the IDbTransaction interface and represents a transaction to be performed at a data source.
SQLBaseParameter: implements the IDataParameter interface, represents a parameter which can be passed to a SQL command.
SQLBaseParameters: implements the IDataParameters interface, which is a simple collection of SQLBaseParameter objects.
In addition to these eight objects, SQLBase provides SQLBaseException, a public interface/object which is used for throwing exceptions to a client in case of a SQLBase error during a client method call.
More info about this class library can be found at the Unify product page.
Download link missing
The SQLBase .NET Data Provider installation package download link is missing. Please provide info and contribute to the community by email to
Connection Strings
Additional info or comments on this class library? Want to submit content?