9. Understanding .NET Data Provider Connectivity : .NET Data Provider Classes : IngresCommand Class
 
Share this page                  
IngresCommand Class
The IngresCommand class represents an SQL command or a database procedure that executes against an Ingres or Enterprise Access database.
Parameter placeholders in the SQL command text are represented by a question mark (?).
Database procedures can be invoked by either setting CommandText=”myproc” and CommandType=CommandType.StoredProcedure, or by using the escape sequence format and setting CommandText=”{ call myproc }” and CommandType=CommandType.Text.
The .NET Data Provider does not currently support the following features:
Multiple active results-sets
Batched commands consisting of multiple Ingres SQL commands in one IngresCommand object
Support for Ingres SQL command COPY TABLE
Support for Ingres SQL command SAVEPOINT
IngresCommand.ExecuteReader(CommandBehavior.SchemaOnly) is supported for SELECT commands only