Mapping of Ingres Native Types to .NET Types

The following table maps the native Ingres database types supported by the Ingres .NET Data Provider to their corresponding .NET type. It also maps the typed accessor that a .NET application uses for an Ingres native database type to be obtained as a .NET type.

IngresDataAdapter Class

The IngresDataAdapter class represents a set of SQL statements and a database connection that are used to fill a DataSet and, optionally, update the Ingres database. The IngresDataAdapter object acts as a bridge between a .NET DataSet and the Ingres database for retrieving and updating data.

IngresDataAdapter Class Declaration

The declarations for the IngresDataAdapter class are:

C#: public sealed class IngresDataAdapter : DbDataAdapter, IDbDataAdapter, ICloneable

VB.NET: NotInheritable Public Class DataAdapter
Inherits DbDataAdapter
Implements IDbDataAdapter, ICloneable

IngresDataAdapter Class Example

public DataSet CreateDataSet(

    string dsName, string connectionString, string commandText)

{

    IngresConnection connection =

        new IngresConnection(connectionString);

    IngresCommand command =

        new IngresCommand(commandText, connection);

    IngresDataAdapter adapter = new IngresDataAdapter(command);

    DataSet ds = new DataSet();

    adapter.Fill(ds, dsName);

    return ds;

}

IngresDataAdapter Class Properties

The IngresDataAdapter class has the following properties:

IngresDataAdapter Class Public Methods

The public methods available to the IngresDataAdapter Class are:

IngresDataAdapter Class Events

The events generated by the IngresDataAdapter class are:

IngresDataAdapter Class Constructors

The IngresDataAdapter class contains the following constructors:

IngresError Class

The IngresError class represents error or warning information returned by the Ingres database.

IngresError Class Declaration

The IngresError class can be declared as follows:

C#: [Serializable] public sealed class IngresError

VB.NET: NotInheritable Public Class IngresError

IngresError Class Example

The following is an implementation of the IngresError class:

static void PrintErrorCollection(IngresErrorCollection errcol)

{

    foreach(IngresError err in errcol)

    {

        PrintError(err);

    }

    Console.WriteLine("");

}

static void PrintError(IngresError err)

{

    Console.Write(err.GetType().ToString() + ":\n");

    Console.Write("\t" + "Message = " +

        (err.Message !=null?

            err.Message.ToString() :"<null>") + "\n");

    Console.Write("\t" + "Source = " +

        (err.Source!=null?err.Source.ToString():"<null>") + "\n");

    Console.Write("\t" + "ToString: " + err.ToString() + "\n");

    Console.Write("\t" + "Number = " +

        (err.Number.ToString()) + "\n");

    Console.Write("\t" + "SQLState = " +

        (err.SQLState !=null?

            err.SQLState.ToString() :"<null>") + "\n");

    Console.WriteLine("");

}

IngresError Class Properties

The IngresError class has the following properties:

IngresError Class Public Methods

The public methods available to the IngresError class are:

IngresErrorCollection Class

The IngresErrorCollection class represents a collection of the IngresError objects returned by the Ingres database. Created by IngresException, an IngresErrorCollection collection always contains at least one instance of IngresError.

IngresErrorCollection Class Declaration

The declarations for the IngresErrorCollection class are:

C#: [Serializable]
  public sealed class IngresErrorCollection : ICollection, IEnumerable

VB.NET: <Serializable]>
NotInheritable Public Class IngresError
Inherits ICollection Implements IEnumerable

IngresErrorCollection Class Example

The following is an example implementation of the IngresErrorCollection class:

static void PrintErrorCollection(IngresErrorCollection errcol)

{

    foreach(IngresError err in errcol)

    {

        PrintError(err);

    }

    Console.WriteLine("");

}

static void PrintError(IngresError err)

{

    Console.Write(err.GetType().ToString() + ":\n");

    Console.Write("\t" + "Message = " +

        (err.Message !=null?

            err.Message.ToString() :"<null>") + "\n");

    Console.Write("\t" + "Source = " +

        (err.Source!=null?err.Source.ToString():"<null>") + "\n");

    Console.Write("\t" + "ToString: " + err.ToString() + "\n");

    Console.Write("\t" + "Number = " +

        (err.Number.ToString()) + "\n");

    Console.Write("\t" + "SQLState = " +

        (err.SQLState !=null?

            err.SQLState.ToString() :"<null>") + "\n");

    Console.WriteLine("");

}

IngresErrorCollection Class Properties

The IngresErrorCollection class has the following properties:

IngresErrorCollection Class Public Methods

The public methods available to the IngresErrorCollection class are:

IngresException Class

The IngresException class represents the exception that is thrown when error information is returned by the Ingres database.

IngresException Class Declaration

The IngresException is declared as follows:

C#: [Serializable]
public sealed class IngresException : SystemException

VB.NET: <Serializable>
NotInheritable Public Class IngresException
Inherits SystemException

IngresException Class Example

The following is an example implementation of the IngresException class:

static void PrintException(IngresException ex)

{

    Console.Write(ex.GetType().ToString() + ":\n");

    Console.Write("\t" + "Errors = " +

        (ex.Errors !=null?ex.Errors.ToString() :

            "<null>") + "\n");

    Console.Write("\t" + "HelpLink = " +

        (ex.HelpLink !=null?ex.HelpLink.ToString() :

            "<null>") + "\n");

    Console.Write("\t" + "InnerException = " +

                (ex.InnerException!=null?ex.InnerException.ToString():

            "<null>") + "\n");

    Console.Write("\t" + "Source = " +

        (ex.Source !=null?ex.Source.ToString() :

            "<null>") + "\n");

    Console.Write("\t" + "TargetSite = " +

                (ex.TargetSite!=null?ex.TargetSite.ToString():"<null>") + "\n");

    Console.WriteLine("");

}

IngresException Class Properties

The IngresException class contains the following properties:

IngresException Class Public Methods

The public methods available to the IngresException class are:

IngresFactory Class

The IngresFactory class helps generates many of the other Ingres classes in an interoperable data provider model. For each Ingres class that the factory wants to construct, simply call the Ingres constructor for that class and return the object instance.

IngresFactory Class Declaration

The IngresFactory class can be declared as follows:

C#: public sealed class IngresFactory : DbProviderFactory

VB.NET: NotInheritable Public Class IngresFactory
Inherits DbProviderFactory

IngresFactory Class Public Fields

The IngresFactory class has the following public fields:

IngresFactory Class Public Methods

The public methods available to the IngresFactory class are:

IngresInfoMessageEventArgs Class

The IngresInfoMessageEventArgs class provides the information on warnings from the database to the delegate method that handles the InfoMessage event.

IngresInfoMessageEventArgs Class Declaration

The IngresInfoMessageEventArgs class is declared as follows:

C#: public sealed class IngresInfoMessageEventArgs : EventArgs

VB.NET: NotInheritable Public Class IngresInfoMessageEventArgs
    Inherits EventArgs

IngresInfoMessageEventArgs Class Example

The following is an implementation of the IngresInfoMessageEventArgs class:

static void OnInfoMessage(

    Object sender, IngresInfoMessageEventArgs e)

{

    Console.WriteLine("OnInfoMessage event args: ("+

        "ErrorCode=" + e.Number +

        ", Errors=" + e.Errors +

        ", Message=\"" + e.Message + "\"" +

        ", Source=" + e.Source +")");

}

IngresInfoMessageEventArgs Class Properties

The following are the properties of the IngresInfoMessageEventArgs class:

IngresInfoMessageEventHandler Class

The IngresInfoMessageEventHandler delegate represents the delegate method that handles the InfoMessage event.

IngresInfoMessageEventHandler Class Declaration

The IngresInfoMessageEventHandler class has the following message declaration:

C#: [Serializable]
         public delegate void IngresInfoMessageEventHandler
         (object sender, IngresInfoMessageEventArgs e)

VB.NET: <Serializable>
Public Delegate Sub IngresInfoMessageEventHandler _
(ByVal sender As Object, ByVal e As
IngresInfoMessageEventArgs)

IngresInfoMessageEventHandler Class Example

The following is an implementation of the IngresInfoMessageEventHandler class:

static void DoWork(string connstring)

{

    IngresConnection conn = new IngresConnection(connstring);

    conn.InfoMessage += new

    IngresInfoMessageEventHandler(OnInfoMessage);

<do additional work>

 }

static void OnInfoMessage(

    Object sender, IngresInfoMessageEventArgs e)

{

    Console.WriteLine("OnInfoMessage event args: ("+

        "ErrorCode=" + e.Number +

        ", Errors=" + e.Errors +

        ", Message=\"" + e.Message + "\"" +

        ", Source=" + e.Source +")");

}

IngresMetaDataCollectionNames Class

The IngresMetaDataCollectionNames class presents information on metadata, such as tables, views, and columns. Each member of the class is a constant string suitable for use as collectionName argument for the IngresConnection.GetSchema method.

The collectionNames supported are:

• Columns
• ForeignKeys
• Indexes
• ProcedureParameters
• Procedures
• Tables
• Views

IngresMetaDataCollectionNames Class Declaration

The IngresMetaDataCollectionNames Class can be declared as follows:

C#: public static class IngresMetaDataCollectionNames

VB.NET: Public Shared Class IngresMetaDataCollectionNames

IngresParameter Class

The IngresParameter class represents a parameter for an IngresCommand for each question mark (?) placeholder in the command and, optionally, its mapping to a DataSet column.

The IngresParameter constructor determines the data type of the parameter in the following ways:

• The constructor specifies an IngresType enumeration
• The constructor specifies a System.DbType enumeration
• Through the .NET Framework System.Type of the Value object if no specific data type is in the constructor

IngresParameter Class Example

The following is an implementation of the IngresParameter class:

static string DemoParameterSSN(

    string connstring, int intNumber, string strSSN)

{

    IngresConnection conn = new IngresConnection(connstring);

    string strName = null;

    conn.Open();

    IngresCommand cmd = new IngresCommand(

        "select name from demo_personnel where number = ? and ssn = ?",

        conn);

    // add two parameters to the command's IngresParameterCollection

    cmd.Parameters.Add(new IngresParameter("Number", intNumber));

    IngresParameter parm =

        new IngresParameter("SSN", IngresType.VarChar);

    parm.Value = strSSN;

    cmd.Parameters.Add(parm);

    IngresDataReader reader = cmd.ExecuteReader();

    while (reader.Read())

    {

        if (reader.IsDBNull(0))

            break;

        strName = reader.GetString(0);

    }

    reader.Close();

    conn.Close();

    return strName;

}

IngresParameter Class Declaration

The class declaration for IngresParameter class is:

C#: public sealed class IngresParameter : System.Data.Common.DbParameter, IDataParameter, IDbDataParameter, ICloneable

VB.NET: NotInheritable Public Class IngresParameter
Inherits System.Data.Common.DbParameter
Implements IDataParameter, IDbDataParameter, ICloneable

IngresParameter Class Properties

The properties for the IngresParameter are:

Important! .NET strings are Unicode based. If the application is sending a Unicode string as a parameter to a database field that is ASCII char or varchar, the application can direct the data provider to coerce the Unicode string to an ASCII string on the client side by setting the parameter DbType property to DbType.AnsiString, or the IngresType property to IngresType.VarChar.

IngresParameter Class Public Methods

The public methods available for the IngresParameter class are:

IngresParameter Class Constructors

The constructors available to the IngresParameter class are:

IngresParameterCollection Class

The IngresParameterCollection class represents a collection of all parameters for an IngresCommand object and their mapping to a DataSet object.

IngresParameterCollection Class Declaration

The class declaration for IngresParameterCollection class is as follows:

C#: public sealed class IngresParameterCollection : System.Data.Common.DbParameterCollection, IDataParameterCollection, IList, ICollection, IEnumerable

VB.NET: NotInheritable Public Class IngresParameterCollection
Inherits System.Data.Common.DbParameterCollection
Implements IDataParameterCollection, IList, ICollection, IEnumerable

IngresParameterCollection Class Example

For an example of adding parameters to an IngresParameterCollection, see IngresParameter Class Example.

IngresParameterCollection Class Properties

The IngresParameterCollection has the following properties:

IngresParameterCollection Class Public Methods

The public methods available to the IngresParameterCollection class are:

IngresPermission Class

The IngresPermission class provides additional information that a user has a security level sufficient to access the Ingres database. At present, the class is not used by the Ingres .NET Data Provider. The class is included in the Ingres data provider to provide completeness for the Factory interoperability model. Instead, standard Ingres security and access control is used.

The IngresPermission class can be declared as follows:

C#: public sealed class IngresPermission : DBPermission

VB.NET: NotInheritable Public Class IngresPermission
Inherits DBPermission

IngresRowUpdatedEventArgs Class

The IngresRowUpdatedEventArgs class provides the information for the RowUpdated event of an IngresDataAdapter.

IngresRowUpdatedEventArgs Class Declaration

The class declaration for IngresRowUpdateEventArgs is as follows:

C#: public sealed class IngresRowUpdatedEventArgs : RowUpdatedEventArgs

VB.NET: NotInheritable Public Class IngresRowUpdatedEventArgs
Inherits RowUpdatedEventArgs

IngresRowUpdatedEventArgs Class Properties

The IngresRowUpdatedEventArgs has the following properties:

IngresRowUpdatedEventHandler Class

The IngresRowUpdatedEventHandler delegate represents a delegate method that handles the RowUpdated event of an IngresDataAdapter.

IngresRowUpdatedEventHandler Class Declaration

The IngresRowUpdateEventHandler class has the following declaration:

C#: [Serializable]
         public delegate void Ingres RowUpdated EventHandler
         ( object sender, IngresRowUpdated EventArgs e)

VB.NET: <Serializable>
   Public Delegate Sub Ingres RowUpdatedEventHandler _
(ByVal sender As Object, ByVal e As
IngresRowUpdatedEventArgs)

IngresRowUpdatingEventArgs Class

The IngresRowUpdatingEventArgs class provides the information for the RowUpdating event of an IngresDataAdapter.

IngresRowUpdatingEventArgs Class Declaration

The IngresRowUpdatingEventArgs class has the following declaration:

C#: public sealed class IngresRowUpdatingEventArgs : RowUpdatingEventArgs

VB.NET: NotInheritable Public Class Ingres RowUpdatingEventArgs
Inherits RowUpdatingEventArgs

IngresRowUpdatingEventArgs Class Properties

The IngresRowUpdatingEventArgs class has the following properties:

IngresRowUpdatingEventHandler Class

The IngresRowUpdatingEventHandler delegate represents a delegate method that handles the RowUpdating event of an IngresDataAdapter.

IngresRowUpdatingEventHandler Class Declaration

The IngresRowUpdatingEventHandler class declaration is as follows:

C#: [Serializable]
         public delegate void IngresRowUpdatingEventHandler
         ( object sender, IngresRowUpdatingEventArgs e)

VB.NET: <Serializable>
   Public Delegate Sub Ingres RowUpdatingEventHandler _
(ByVal sender As Object, ByVal e As IngresRowUpdatingEventArgs)

IngresTransaction Class

The IngresTransaction class represents a local, non-distributed database transaction. Each connection is associated with a transaction. This object allows manual commit or rollback control over the pending local transaction.

Created by the BeginTransaction method in the IngresConnection object. After Commit() or Rollback has been issued against the transaction, the IngresTransaction object can not be reused and a new IngresTransaction object must be obtained from the IngresConnection.BeginTransaction method if another transaction is desired.

IngresTransaction Class Declaration

The IngresTransaction class declaration is as follows:

C#: public sealed class IngresTransaction : System.Data.Common.DbTransaction

VB.NET: NotInheritable Public Class IngresTransaction
Inherits System.Data.Common.DbTransaction

IngresTransaction Class Example

The following is an implementation of the IngresTransaction class:

static void DemoTxn(string connstring)

{
    IngresConnection conn = new IngresConnection(connstring);
    ProviderTransaction txn;

    conn.Open();
    txn = conn.BeginTransaction();

    IngresCommand cmd = new IngresCommand(
        "update demo_personnel set name = 'Howard Lane' "+
        " where number = 200", conn, txn);

    int numberOfRecordsAffected = cmd.ExecuteNonQuery();

    Console.WriteLine(numberOfRecordsAffected.ToString() +
        " records updated.");

    txn.Commit();

    conn.Close();
}

IngresTransaction Class Properties

The IngresTransaction class has the following properties:

IngresTransaction Class Methods

The IngresTransaction class contains the following methods: