Click or drag to resize

DataExtensions Class

Defines extension functions related to database and SQL interaction.
Inheritance Hierarchy
SystemObject
  GSF.DataDataExtensions

Namespace: GSF.Data
Assembly: GSF.Core (in GSF.Core.dll) Version: 2.4.181-beta
Syntax
public static class DataExtensions
View Source

The DataExtensions type exposes the following members.

Methods
 NameDescription
Public Extension MethodAddParametersWithValues Creates and adds a new IDbDataParameter for each of the specified values to the IDbCommand object.
Public Extension MethodAddParameterWithValue Creates and adds an IDbDataParameter to the IDbCommand object with the specified value.
Public Extension MethodConvertField(DataRow, String, Type) Automatically applies type conversion to column values when only a type is available.
Public Extension MethodConvertField(DataRow, String, Type, Object) Automatically applies type conversion to column values when only a type is available.
Public Extension MethodConvertFieldT(DataRow, String) Provides strongly-typed access to each of the column values in the specified row. Automatically applies type conversion to the column values.
Public Extension MethodConvertFieldT(DataRow, String, T) Provides strongly-typed access to each of the column values in the specified row. Automatically applies type conversion to the column values.
Public Extension MethodConvertGuidField Parses a Guid from a database field that is a Guid type or a string representing a Guid.
Public Extension MethodConvertNullableFieldT Provides strongly-typed access to each of the column values in the specified row. Automatically applies type conversion to the column values.
Public Extension MethodCreateParameterizedCommand Creates and returns a parameterized IDbCommand. Parameter names are embedded in the SQL statement passed as a parameter to this method.
Public Extension MethodExecuteMySQLScript(IDbConnection, TextReader) Executes the statements defined in the given MySQL script.
Public Extension MethodExecuteMySQLScript(IDbConnection, String) Executes the statements defined in the given MySQL script.
Public Extension MethodExecuteNonQuery(IDbCommand, String, Object) Executes the SQL statement using IDbCommand, and returns the number of rows affected.
Public Extension MethodExecuteNonQuery(OdbcCommand, String, Object) Executes the SQL statement using OdbcCommand, and returns the number of rows affected.
Public Extension MethodExecuteNonQuery(OdbcConnection, String, Object) Executes the SQL statement using OdbcConnection, and returns the number of rows affected.
Public Extension MethodExecuteNonQuery(OleDbCommand, String, Object) Executes the SQL statement using OleDbCommand, and returns the number of rows affected.
Public Extension MethodExecuteNonQuery(OleDbConnection, String, Object) Executes the SQL statement using OleDbConnection, and returns the number of rows affected.
Public Extension MethodExecuteNonQuery(SqlCommand, String, Object) Executes the SQL statement using SqlCommand, and returns the number of rows affected.
Public Extension MethodExecuteNonQuery(SqlConnection, String, Object) Executes the SQL statement using SqlConnection, and returns the number of rows affected.
Public Extension MethodExecuteNonQuery(IDbCommand, String, Int32, Object) Executes the SQL statement using IDbCommand, and returns the number of rows affected.
Public Extension MethodExecuteNonQuery(OdbcCommand, String, Int32, Object) Executes the SQL statement using OdbcCommand, and returns the number of rows affected.
Public Extension MethodExecuteNonQuery(OdbcConnection, String, Int32, Object) Executes the SQL statement using OdbcConnection, and returns the number of rows affected.
Public Extension MethodExecuteNonQuery(OleDbCommand, String, Int32, Object) Executes the SQL statement using OleDbCommand, and returns the number of rows affected.
Public Extension MethodExecuteNonQuery(OleDbConnection, String, Int32, Object) Executes the SQL statement using OleDbConnection, and returns the number of rows affected.
Public Extension MethodExecuteNonQuery(SqlCommand, String, Int32, Object) Executes the SQL statement using SqlCommand, and returns the number of rows affected.
Public Extension MethodExecuteNonQuery(SqlConnection, String, Int32, Object) Executes the SQL statement using SqlConnection, and returns the number of rows affected.
Public Extension MethodExecuteNonQueryTConnection(TConnection, String, Object) Executes the SQL statement using IDbConnection, and returns the number of rows affected.
Public Extension MethodExecuteNonQueryTConnection(TConnection, String, Int32, Object) Executes the SQL statement using IDbConnection, and returns the number of rows affected.
Public Extension MethodExecuteOracleScript(IDbConnection, TextReader) Executes the statements defined in the given Oracle database script.
Public Extension MethodExecuteOracleScript(IDbConnection, String) Executes the statements defined in the given Oracle database script.
Public Extension MethodExecuteReader(IDbCommand, String, Object) Executes the SQL statement using IDbCommand, and builds a IDataReader.
Public Extension MethodExecuteReader(OdbcCommand, String, Object) Executes the SQL statement using OdbcCommand, and builds a OdbcDataReader.
Public Extension MethodExecuteReader(OdbcConnection, String, Object) Executes the SQL statement using OdbcConnection, and builds a OdbcDataReader.
Public Extension MethodExecuteReader(OleDbCommand, String, Object) Executes the SQL statement using OleDbCommand, and builds a OleDbDataReader.
Public Extension MethodExecuteReader(OleDbConnection, String, Object) Executes the SQL statement using OleDbConnection, and builds a OleDbDataReader.
Public Extension MethodExecuteReader(SqlCommand, String, Object) Executes the SQL statement using SqlCommand, and builds a SqlDataReader.
Public Extension MethodExecuteReader(SqlConnection, String, Object) Executes the SQL statement using SqlConnection, and builds a SqlDataReader.
Public Extension MethodExecuteReader(IDbCommand, String, Int32, Object) Executes the SQL statement using IDbCommand, and builds a IDataReader.
Public Extension MethodExecuteReader(IDbCommand, String, CommandBehavior, Int32, Object) Executes the SQL statement using IDbCommand, and builds a IDataReader.
Public Extension MethodExecuteReader(OdbcCommand, String, CommandBehavior, Int32, Object) Executes the SQL statement using OdbcCommand, and builds a OdbcDataReader.
Public Extension MethodExecuteReader(OdbcConnection, String, CommandBehavior, Int32, Object) Executes the SQL statement using OdbcConnection, and builds a OdbcDataReader.
Public Extension MethodExecuteReader(OleDbCommand, String, CommandBehavior, Int32, Object) Executes the SQL statement using OleDbCommand, and builds a OleDbDataReader.
Public Extension MethodExecuteReader(OleDbConnection, String, CommandBehavior, Int32, Object) Executes the SQL statement using OleDbConnection, and builds a OleDbDataReader.
Public Extension MethodExecuteReader(SqlCommand, String, CommandBehavior, Int32, Object) Executes the SQL statement using SqlCommand, and builds a SqlDataReader.
Public Extension MethodExecuteReader(SqlConnection, String, CommandBehavior, Int32, Object) Executes the SQL statement using SqlConnection, and builds a SqlDataReader.
Public Extension MethodExecuteReaderTConnection(TConnection, String, Object) Executes the SQL statement using IDbConnection, and builds a IDataReader.
Public Extension MethodExecuteReaderTConnection(TConnection, String, Int32, Object) Executes the SQL statement using IDbConnection, and builds a IDataReader.
Public Extension MethodExecuteReaderTConnection(TConnection, String, CommandBehavior, Int32, Object) Executes the SQL statement using IDbConnection, and builds a IDataReader.
Public Extension MethodExecuteScalar(IDbCommand, String, Object) Executes the SQL statement using IDbCommand, and returns the value in the first column of the first row in the result set.
Public Extension MethodExecuteScalar(OdbcCommand, String, Object) Executes the SQL statement using OdbcCommand, and returns the value in the first column of the first row in the result set.
Public Extension MethodExecuteScalar(OdbcConnection, String, Object) Executes the SQL statement using OdbcConnection, and returns the value in the first column of the first row in the result set.
Public Extension MethodExecuteScalar(OleDbCommand, String, Object) Executes the SQL statement using OleDbCommand, and returns the value in the first column of the first row in the result set.
Public Extension MethodExecuteScalar(OleDbConnection, String, Object) Executes the SQL statement using OleDbConnection, and returns the value in the first column of the first row in the result set.
Public Extension MethodExecuteScalar(SqlCommand, String, Object) Executes the SQL statement using SqlCommand, and returns the value in the first column of the first row in the result set.
Public Extension MethodExecuteScalar(SqlConnection, String, Object) Executes the SQL statement using SqlConnection, and returns the value in the first column of the first row in the result set.
Public Extension MethodExecuteScalar(IDbCommand, String, Int32, Object) Executes the SQL statement using IDbCommand, and returns the value in the first column of the first row in the result set.
Public Extension MethodExecuteScalar(OdbcCommand, String, Int32, Object) Executes the SQL statement using OdbcCommand, and returns the value in the first column of the first row in the result set.
Public Extension MethodExecuteScalar(OdbcConnection, String, Int32, Object) Executes the SQL statement using OdbcConnection, and returns the value in the first column of the first row in the result set.
Public Extension MethodExecuteScalar(OleDbCommand, String, Int32, Object) Executes the SQL statement using OleDbCommand, and returns the value in the first column of the first row in the result set.
Public Extension MethodExecuteScalar(OleDbConnection, String, Int32, Object) Executes the SQL statement using OleDbConnection, and returns the value in the first column of the first row in the result set.
Public Extension MethodExecuteScalar(SqlCommand, String, Int32, Object) Executes the SQL statement using SqlCommand, and returns the value in the first column of the first row in the result set.
Public Extension MethodExecuteScalar(SqlConnection, String, Int32, Object) Executes the SQL statement using SqlConnection, and returns the value in the first column of the first row in the result set.
Public Extension MethodExecuteScalarTConnection(TConnection, String, Object) Executes the SQL statement using IDbConnection, and returns the value in the first column of the first row in the result set.
Public Extension MethodExecuteScalarTConnection(TConnection, String, Int32, Object) Executes the SQL statement using IDbConnection, and returns the value in the first column of the first row in the result set.
Public Extension MethodExecuteTSQLScript(IDbConnection, TextReader) Executes the statements defined in the given TSQL script.
Public Extension MethodExecuteTSQLScript(IDbConnection, String) Executes the statements defined in the given TSQL script.
Public Extension MethodPopulateParameters(OdbcCommand, Object) Takes the OdbcCommand object and populates it with the given parameters.
Public Extension MethodPopulateParameters(OleDbCommand, Object) Takes the OleDbCommand object and populates it with the given parameters.
Public Extension MethodPopulateParameters(SqlCommand, Object) Takes the SqlCommand object and populates it with the given parameters.
Public Extension MethodPopulateParameters(OdbcCommand, Object, Object) Takes the OdbcCommand object and populates it with the given parameters.
Public Extension MethodPopulateParameters(OleDbCommand, Object, Object) Takes the OleDbCommand object and populates it with the given parameters.
Public Extension MethodPopulateParameters(SqlCommand, Object, Object) Takes the SqlCommand object and populates it with the given parameters.
Public Extension MethodPopulateParametersTDbCommand(TDbCommand, ActionTDbCommand, Object) Takes the IDbCommand object and populates it with the given parameters.
Public Extension MethodRetrieveData(OdbcCommand, String) Executes the SQL statement using OdbcCommand, and returns the first DataTable of result set, if the result set contains multiple tables.
Public Extension MethodRetrieveData(OdbcConnection, String) Executes the SQL statement using OdbcConnection, and returns the first DataTable of result set, if the result set contains multiple tables.
Public Extension MethodRetrieveData(OleDbCommand, String) Executes the SQL statement using OleDbCommand, and returns the first DataTable of result set, if the result set contains multiple tables.
Public Extension MethodRetrieveData(OleDbConnection, String) Executes the SQL statement using OleDbConnection, and returns the first DataTable of result set, if the result set contains multiple tables.
Public Extension MethodRetrieveData(SqlCommand, String) Executes the SQL statement using SqlCommand, and returns the first DataTable of result set, if the result set contains multiple tables.
Public Extension MethodRetrieveData(SqlConnection, String) Executes the SQL statement using SqlConnection, and returns the first DataTable of result set, if the result set contains multiple tables.
Public Extension MethodRetrieveData(OdbcCommand, String, Object) Executes the SQL statement using OdbcCommand, and returns the first DataTable of result set, if the result set contains multiple tables.
Public Extension MethodRetrieveData(OdbcConnection, String, Object) Executes the SQL statement using OdbcConnection, and returns the first DataTable of result set, if the result set contains multiple tables.
Public Extension MethodRetrieveData(OleDbCommand, String, Object) Executes the SQL statement using OleDbCommand, and returns the first DataTable of result set, if the result set contains multiple tables.
Public Extension MethodRetrieveData(OleDbConnection, String, Object) Executes the SQL statement using OleDbConnection, and returns the first DataTable of result set, if the result set contains multiple tables.
Public Extension MethodRetrieveData(SqlCommand, String, Object) Executes the SQL statement using SqlCommand, and returns the first DataTable of result set, if the result set contains multiple tables.
Public Extension MethodRetrieveData(SqlConnection, String, Object) Executes the SQL statement using SqlConnection, and returns the first DataTable of result set, if the result set contains multiple tables.
Public Extension MethodRetrieveData(IDbCommand, Type, String, Object) Executes the SQL statement using IDbCommand, and returns the first DataTable of result set, if the result set contains multiple tables.
Public Extension MethodRetrieveData(IDbConnection, Type, String, Object) Executes the SQL statement using IDbConnection, and returns the first DataTable of result set, if the result set contains multiple tables.
Public Extension MethodRetrieveData(IDbCommand, Type, String, Int32, Object) Executes the SQL statement using IDbCommand, and returns the first DataTable of result set, if the result set contains multiple tables.
Public Extension MethodRetrieveData(IDbConnection, Type, String, Int32, Object) Executes the SQL statement using IDbConnection, and returns the first DataTable of result set, if the result set contains multiple tables.
Public Extension MethodRetrieveData(OdbcCommand, String, Int32, Int32, Int32) Executes the SQL statement using OdbcCommand, and returns the first DataTable of result set, if the result set contains multiple tables.
Public Extension MethodRetrieveData(OdbcConnection, String, Int32, Int32, Int32) Executes the SQL statement using OdbcConnection, and returns the first DataTable of result set, if the result set contains multiple tables.
Public Extension MethodRetrieveData(OleDbCommand, String, Int32, Int32, Int32) Executes the SQL statement using OleDbCommand, and returns the first DataTable of result set, if the result set contains multiple tables.
Public Extension MethodRetrieveData(OleDbConnection, String, Int32, Int32, Int32) Executes the SQL statement using OleDbConnection, and returns the first DataTable of result set, if the result set contains multiple tables.
Public Extension MethodRetrieveData(SqlCommand, String, Int32, Int32, Int32) Executes the SQL statement using SqlCommand, and returns the first DataTable of result set, if the result set contains multiple tables.
Public Extension MethodRetrieveData(SqlConnection, String, Int32, Int32, Int32) Executes the SQL statement using SqlConnection, and returns the first DataTable of result set, if the result set contains multiple tables.
Public Extension MethodRetrieveData(OdbcCommand, String, Int32, Int32, Int32, Object) Executes the SQL statement using OdbcCommand, and returns the first DataTable of result set, if the result set contains multiple tables.
Public Extension MethodRetrieveData(OdbcConnection, String, Int32, Int32, Int32, Object) Executes the SQL statement using OdbcConnection, and returns the first DataTable of result set, if the result set contains multiple tables.
Public Extension MethodRetrieveData(OleDbCommand, String, Int32, Int32, Int32, Object) Executes the SQL statement using OleDbCommand, and returns the first DataTable of result set, if the result set contains multiple tables.
Public Extension MethodRetrieveData(OleDbConnection, String, Int32, Int32, Int32, Object) Executes the SQL statement using OleDbConnection, and returns the first DataTable of result set, if the result set contains multiple tables.
Public Extension MethodRetrieveData(SqlCommand, String, Int32, Int32, Int32, Object) Executes the SQL statement using SqlCommand, and returns the first DataTable of result set, if the result set contains multiple tables.
Public Extension MethodRetrieveData(SqlConnection, String, Int32, Int32, Int32, Object) Executes the SQL statement using SqlConnection, and returns the first DataTable of result set, if the result set contains multiple tables.
Public Extension MethodRetrieveDataSet(OdbcCommand, String) Executes the SQL statement using OdbcCommand, and returns the DataSet that may contain multiple tables, depending on the SQL statement.
Public Extension MethodRetrieveDataSet(OdbcConnection, String) Executes the SQL statement using OdbcConnection, and returns the DataSet that may contain multiple tables, depending on the SQL statement.
Public Extension MethodRetrieveDataSet(OleDbCommand, String) Executes the SQL statement using OleDbCommand, and returns the DataSet that may contain multiple tables, depending on the SQL statement.
Public Extension MethodRetrieveDataSet(OleDbConnection, String) Executes the SQL statement using OleDbConnection, and returns the DataSet that may contain multiple tables, depending on the SQL statement.
Public Extension MethodRetrieveDataSet(SqlCommand, String) Executes the SQL statement using SqlCommand, and returns the DataSet that may contain multiple table depending on the SQL statement.
Public Extension MethodRetrieveDataSet(SqlConnection, String) Executes the SQL statement using SqlConnection, and returns the DataSet that may contain multiple table depending on the SQL statement.
Public Extension MethodRetrieveDataSet(OdbcCommand, String, Object) Executes the SQL statement using OdbcCommand, and returns the DataSet that may contain multiple tables, depending on the SQL statement.
Public Extension MethodRetrieveDataSet(OdbcConnection, String, Object) Executes the SQL statement using OdbcConnection, and returns the DataSet that may contain multiple tables, depending on the SQL statement.
Public Extension MethodRetrieveDataSet(OleDbCommand, String, Object) Executes the SQL statement using OleDbCommand, and returns the DataSet that may contain multiple tables, depending on the SQL statement.
Public Extension MethodRetrieveDataSet(OleDbConnection, String, Object) Executes the SQL statement using OleDbConnection, and returns the DataSet that may contain multiple tables, depending on the SQL statement.
Public Extension MethodRetrieveDataSet(SqlCommand, String, Object) Executes the SQL statement using SqlCommand, and returns the DataSet that may contain multiple tables depending on the SQL statement.
Public Extension MethodRetrieveDataSet(SqlConnection, String, Object) Executes the SQL statement using SqlConnection, and returns the DataSet that may contain multiple tables depending on the SQL statement.
Public Extension MethodRetrieveDataSet(IDbCommand, Type, String, Object) Executes the SQL statement using IDbCommand, and returns the DataSet that may contain multiple tables, depending on the SQL statement.
Public Extension MethodRetrieveDataSet(IDbConnection, Type, String, Object) Executes the SQL statement using IDbConnection, and returns the DataSet that may contain multiple tables, depending on the SQL statement.
Public Extension MethodRetrieveDataSet(IDbCommand, Type, String, Int32, Object) Executes the SQL statement using IDbCommand, and returns the DataSet that may contain multiple tables, depending on the SQL statement.
Public Extension MethodRetrieveDataSet(IDbConnection, Type, String, Int32, Object) Executes the SQL statement using IDbConnection, and returns the DataSet that may contain multiple tables, depending on the SQL statement.
Public Extension MethodRetrieveDataSet(OdbcCommand, String, Int32, Int32, Int32) Executes the SQL statement using OdbcCommand, and returns the DataSet that may contain multiple tables, depending on the SQL statement.
Public Extension MethodRetrieveDataSet(OdbcConnection, String, Int32, Int32, Int32) Executes the SQL statement using OdbcConnection, and returns the DataSet that may contain multiple tables, depending on the SQL statement.
Public Extension MethodRetrieveDataSet(OleDbCommand, String, Int32, Int32, Int32) Executes the SQL statement using OleDbCommand, and returns the DataSet that may contain multiple tables, depending on the SQL statement.
Public Extension MethodRetrieveDataSet(OleDbConnection, String, Int32, Int32, Int32) Executes the SQL statement using OleDbConnection, and returns the DataSet that may contain multiple tables, depending on the SQL statement.
Public Extension MethodRetrieveDataSet(SqlCommand, String, Int32, Int32, Int32) Executes the SQL statement using SqlCommand, and returns the DataSet that may contain multiple tables, depending on the SQL statement.
Public Extension MethodRetrieveDataSet(SqlConnection, String, Int32, Int32, Int32) Executes the SQL statement using SqlConnection, and returns the DataSet that may contain multiple tables, depending on the SQL statement.
Public Extension MethodRetrieveDataSet(OdbcCommand, String, Int32, Int32, Int32, Object) Executes the SQL statement using OdbcCommand, and returns the DataSet that may contain multiple tables, depending on the SQL statement.
Public Extension MethodRetrieveDataSet(OdbcConnection, String, Int32, Int32, Int32, Object) Executes the SQL statement using OdbcConnection, and returns the DataSet that may contain multiple tables, depending on the SQL statement.
Public Extension MethodRetrieveDataSet(OleDbCommand, String, Int32, Int32, Int32, Object) Executes the SQL statement using OleDbCommand, and returns the DataSet that may contain multiple tables, depending on the SQL statement.
Public Extension MethodRetrieveDataSet(OleDbConnection, String, Int32, Int32, Int32, Object) Executes the SQL statement using OleDbConnection, and returns the DataSet that may contain multiple tables, depending on the SQL statement.
Public Extension MethodRetrieveDataSet(SqlCommand, String, Int32, Int32, Int32, Object) Executes the SQL statement using SqlCommand, and returns the DataSet that may contain multiple tables, depending on the SQL statement.
Public Extension MethodRetrieveDataSet(SqlConnection, String, Int32, Int32, Int32, Object) Executes the SQL statement using SqlConnection, and returns the DataSet that may contain multiple tables, depending on the SQL statement.
Public Extension MethodRetrieveRow(OdbcCommand, String) Executes the SQL statement using OdbcCommand, and returns the first DataRow in the result set.
Public Extension MethodRetrieveRow(OdbcConnection, String) Executes the SQL statement using OdbcConnection, and returns the first DataRow in the result set.
Public Extension MethodRetrieveRow(OleDbCommand, String) Executes the SQL statement using OleDbCommand, and returns the first DataRow in the result set.
Public Extension MethodRetrieveRow(OleDbConnection, String) Executes the SQL statement using OleDbConnection, and returns the first DataRow in the result set.
Public Extension MethodRetrieveRow(SqlCommand, String) Executes the SQL statement using SqlCommand, and returns the first DataRow in the result set.
Public Extension MethodRetrieveRow(SqlConnection, String) Executes the SQL statement using SqlConnection, and returns the first DataRow in the result set.
Public Extension MethodRetrieveRow(OdbcCommand, String, Int32) Executes the SQL statement using OdbcCommand, and returns the first DataRow in the result set.
Public Extension MethodRetrieveRow(OdbcCommand, String, Object) Executes the SQL statement using OdbcCommand, and returns the first DataRow in the result set.
Public Extension MethodRetrieveRow(OdbcConnection, String, Int32) Executes the SQL statement using OdbcConnection, and returns the first DataRow in the result set.
Public Extension MethodRetrieveRow(OdbcConnection, String, Object) Executes the SQL statement using OdbcConnection, and returns the first DataRow in the result set.
Public Extension MethodRetrieveRow(OleDbCommand, String, Int32) Executes the SQL statement using OleDbCommand, and returns the first DataRow in the result set.
Public Extension MethodRetrieveRow(OleDbCommand, String, Object) Executes the SQL statement using OleDbCommand, and returns the first DataRow in the result set.
Public Extension MethodRetrieveRow(OleDbConnection, String, Int32) Executes the SQL statement using OleDbConnection, and returns the first DataRow in the result set.
Public Extension MethodRetrieveRow(OleDbConnection, String, Object) Executes the SQL statement using OleDbConnection, and returns the first DataRow in the result set.
Public Extension MethodRetrieveRow(SqlCommand, String, Int32) Executes the SQL statement using SqlCommand, and returns the first DataRow in the result set.
Public Extension MethodRetrieveRow(SqlCommand, String, Object) Executes the SQL statement using SqlCommand, and returns the first DataRow in the result set.
Public Extension MethodRetrieveRow(SqlConnection, String, Int32) Executes the SQL statement using SqlConnection, and returns the first DataRow in the result set.
Public Extension MethodRetrieveRow(SqlConnection, String, Object) Executes the SQL statement using SqlConnection, and returns the first DataRow in the result set.
Public Extension MethodRetrieveRow(IDbCommand, Type, String, Object) Executes the SQL statement using IDbCommand, and returns the first DataRow in the result set.
Public Extension MethodRetrieveRow(IDbConnection, Type, String, Object) Executes the SQL statement using IDbConnection, and returns the first DataRow in the result set.
Public Extension MethodRetrieveRow(OdbcCommand, String, Int32, Object) Executes the SQL statement using OdbcCommand, and returns the first DataRow in the result set.
Public Extension MethodRetrieveRow(OdbcConnection, String, Int32, Object) Executes the SQL statement using OdbcConnection, and returns the first DataRow in the result set.
Public Extension MethodRetrieveRow(OleDbCommand, String, Int32, Object) Executes the SQL statement using OleDbCommand, and returns the first DataRow in the result set.
Public Extension MethodRetrieveRow(OleDbConnection, String, Int32, Object) Executes the SQL statement using OleDbConnection, and returns the first DataRow in the result set.
Public Extension MethodRetrieveRow(SqlCommand, String, Int32, Object) Executes the SQL statement using SqlCommand, and returns the first DataRow in the result set.
Public Extension MethodRetrieveRow(SqlConnection, String, Int32, Object) Executes the SQL statement using SqlConnection, and returns the first DataRow in the result set.
Public Extension MethodRetrieveRow(IDbCommand, Type, String, Int32, Object) Executes the SQL statement using IDbCommand, and returns the first DataRow in the result set.
Public Extension MethodRetrieveRow(IDbConnection, Type, String, Int32, Object) Executes the SQL statement using IDbConnection, and returns the first DataRow in the result set.
Public Extension MethodSQLEncode Performs SQL encoding on given SQL string.
Public Extension MethodToDataTable Converts a delimited string into a DataTable.
Public Extension MethodToDelimitedString Converts the DataTable to a multi-line delimited string (e.g., CSV export).
Public Extension MethodUpdateData(OdbcConnection, DataTable, String) Updates the underlying data of the DataTable using OdbcConnection, and returns the number of rows successfully updated.
Public Extension MethodUpdateData(OleDbConnection, DataTable, String) Updates the underlying data of the DataTable using OleDbConnection, and returns the number of rows successfully updated.
Public Extension MethodUpdateData(SqlConnection, DataTable, String) Updates the underlying data of the DataTable using SqlConnection, and returns the number of rows successfully updated.
Top
Fields
 NameDescription
Public fieldStatic memberDefaultTimeoutDuration The default timeout duration used for executing SQL statements when timeout duration is not specified.
Top
See Also