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