FDO .NET API Reference Feature Data Objects

OSGeo::FDO::Commands::SQL Namespace Reference


Classes

interface  ISQLCommand
 The ISQLCommand interface defines the SQL command, which supports the execution of a SQL statement against an underlying RDBMS. Two execute methods are provided to distinguish between statements that return table data versus those that execute non query type operations. More...
class  ISQLCommandImp
 The ISQLCommandImp class is a concrete implementation of ISQLCommand. The ISQLCommand interface defines the SQL command, which supports the execution of a SQL statement against an underlying RDBMS. Two execute methods are provided to distinguish between statements that return table data versus those that execute non query type operations. More...
interface  ISQLDataReader
 The ISQLDataReader interface provides a forward-only, read-only iterator for reading relational table data. A reference to an ISQLDataReader is returned from the SQLCommands ExecuteReader method. The initial position of the ISQLDataReader interface is prior to the first item. Thus, you must call ReadNext to begin accessing any data. More...
class  ISQLDataReaderImp
 The ISQLDataReaderImp class is a concrete implementation of ISQLDataReader. The ISQLDataReader interface provides a forward-only, read-only iterator for reading relational table data. A reference to an ISQLDataReader is returned from the SQLCommands ExecuteReader method. The initial position of the ISQLDataReader interface is prior to the first item. Thus, you must call ReadNext to begin accessing any data. More...

Functions

System::Void Close ()
 Closes the ISQLDataReader object, freeing any resources it may be holding.
System::Int32 ExecuteNonQuery ()
 Executes the SQL statement against the connection object and returns the number of rows affected.
OSGeo::FDO::Commands::SQL::ISQLDataReaderExecuteReader ()
 Executes the SQL statement against the connection object and returns an ISQLDataReader.
System::Boolean GetBoolean (System::String *name)
 Gets the Boolean value of the specified column. No conversion is performed, thus the column must be DataType_Boolean or an exception is thrown.
System::Byte GetByte (System::String *name)
 Gets the byte value of the specified column. No conversion is performed, thus the column must be DataType_Byte or an exception is thrown.
System::String * GetColumnName (System::Int32 index)
 Gets the name of the column at the given ordinal position.
OSGeo::FDO::Schema::DataType GetColumnType (System::String *name)
 Gets the data type of the column with the specified name.
System::DateTime GetDateTime (System::String *name)
 Gets the date time value of the specified column. No conversion is performed, thus the column must be DataType_DateTime or an exception is thrown.
System::Double GetDouble (System::String *name)
 Gets the double-precision floating point value of the specified column. No conversion is performed, thus the column must be of type Double or an exception is thrown.
System::Byte GetGeometry (System::String *name)[]
 Gets the geometry value of the specified column as a byte array in FGF format. No conversion is performed, thus the column must be of Geometric type or an exception is thrown.
System::Int16 GetInt16 (System::String *name)
 Gets the signed 16-bit integer value of the specified column. No conversion is performed, thus the column must be DataType_Int16 or an exception is thrown.
System::Int32 GetInt32 (System::String *name)
 Gets the signed 32-bit integer value of the specified column. No conversion is performed, thus the column must be DataType_Int32 or an exception is thrown.
System::Int64 GetInt64 (System::String *name)
 Gets the signed 64-bit integer value of the specified column. No conversion is performed, thus the column must be DataType_Int64 or an exception is thrown.
OSGeo::FDO::Expression::LOBValueGetLOB (System::String *name)
 Gets a LOBValue reference. The LOB is fully read in and data available. Because no conversion is performed, the property must be DataType_BLOB or DataType_CLOB etc. (a LOB type).
OSGeo::FDO::Common::IStreamReaderGetLOBStreamReader (System::String *name)
 Gets a reference of the specified LOB property as a BLOBStreamReader or CLOBStreamReader etc. to allow reading in blocks of data. Because no conversion is performed, the property must be DataType_BLOB or DataType_CLOB etc. (a LOB type) Cast the IStreamReader to the appropiate LOB Stream Reader.
OSGeo::FDO::Schema::PropertyType GetPropertyType (System::String *name)
 Gets property type of the column with the specified name. This is used to indicate if a given column is a geometric property or a data property. If the column is a PropertyType_DataProperty, then GetColumnType can be used to find the data type of the column.
System::Single GetSingle (System::String *name)
 Gets the single-precision floating point value of the specified column. No conversion is performed, thus the column must be DataType_Single or an exception is thrown.
System::String * GetString (System::String *name)
 Gets the string value of the specified column. No conversion is performed, thus the column must be DataType_String or an exception is thrown.
System::Boolean IsNull (System::String *name)
 Returns true if the value of the specified column is null.
System::Boolean ReadNext ()
 Advances the reader to the next item. The default position of the reader is prior to the first item. Thus, you must call ReadNext to begin accessing any data.
__property System::Void set_SQLStatement (System::String *value)
 Sets the SQL statement to be executed as a string.

Variables

public __gc __interface ISQLCommand
public __gc __interface ISQLDataReader
public __gc __interface ISQLDataReader
public __gc __interface ISQLDataReader
public __gc __interface ISQLDataReader

Comments or suggestions? Send us feedback.