Click or drag to resize

DataExtensions Methods

The DataExtensions type exposes the following members.

Methods
  Name Description
Public Extension Method AddParametersWithValues Creates and adds a new IDbDataParameter for each of the specified values to the IDbCommand object.
Public Extension Method AddParameterWithValue Creates and adds an IDbDataParameter to the IDbCommand object with the specified value.
Public Extension Method ConvertField(DataRow, String, Type) Automatically applies type conversion to column values when only a type is available.
Public Extension Method ConvertField(DataRow, String, Type, Object) Automatically applies type conversion to column values when only a type is available.
Public Extension Method ConvertFieldT(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 Method ConvertFieldT(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 Method ConvertGuidField Parses a Guid from a database field that is a Guid type or a string representing a Guid.
Public Extension Method ConvertNullableFieldT Provides strongly-typed access to each of the column values in the specified row. Automatically applies type conversion to the column values.
Public Extension Method CreateParameterizedCommand Creates and returns a parameterized IDbCommand. Parameter names are embedded in the SQL statement passed as a parameter to this method.
Public Extension Method ExecuteMySQLScript(IDbConnection, TextReader) Executes the statements defined in the given MySQL script.
Public Extension Method ExecuteMySQLScript(IDbConnection, String) Executes the statements defined in the given MySQL script.
Public Extension Method ExecuteNonQuery(IDbCommand, String, Object) Executes the SQL statement using IDbCommand, and returns the number of rows affected.
Public Extension Method ExecuteNonQuery(OdbcCommand, String, Object) Executes the SQL statement using OdbcCommand, and returns the number of rows affected.
Public Extension Method ExecuteNonQuery(OdbcConnection, String, Object) Executes the SQL statement using OdbcConnection, and returns the number of rows affected.
Public Extension Method ExecuteNonQuery(OleDbCommand, String, Object) Executes the SQL statement using OleDbCommand, and returns the number of rows affected.
Public Extension Method ExecuteNonQuery(OleDbConnection, String, Object) Executes the SQL statement using OleDbConnection, and returns the number of rows affected.
Public Extension Method ExecuteNonQuery(SqlCommand, String, Object) Executes the SQL statement using SqlCommand, and returns the number of rows affected.
Public Extension Method ExecuteNonQuery(SqlConnection, String, Object) Executes the SQL statement using SqlConnection, and returns the number of rows affected.
Public Extension Method ExecuteNonQuery(IDbCommand, String, Int32, Object) Executes the SQL statement using IDbCommand, and returns the number of rows affected.
Public Extension Method ExecuteNonQuery(OdbcCommand, String, Int32, Object) Executes the SQL statement using OdbcCommand, and returns the number of rows affected.
Public Extension Method ExecuteNonQuery(OdbcConnection, String, Int32, Object) Executes the SQL statement using OdbcConnection, and returns the number of rows affected.
Public Extension Method ExecuteNonQuery(OleDbCommand, String, Int32, Object) Executes the SQL statement using OleDbCommand, and returns the number of rows affected.
Public Extension Method ExecuteNonQuery(OleDbConnection, String, Int32, Object) Executes the SQL statement using OleDbConnection, and returns the number of rows affected.
Public Extension Method ExecuteNonQuery(SqlCommand, String, Int32, Object) Executes the SQL statement using SqlCommand, and returns the number of rows affected.
Public Extension Method ExecuteNonQuery(SqlConnection, String, Int32, Object) Executes the SQL statement using SqlConnection, and returns the number of rows affected.
Public Extension Method ExecuteNonQueryTConnection(TConnection, String, Object) Executes the SQL statement using IDbConnection, and returns the number of rows affected.
Public Extension Method ExecuteNonQueryTConnection(TConnection, String, Int32, Object) Executes the SQL statement using IDbConnection, and returns the number of rows affected.
Public Extension Method ExecuteOracleScript(IDbConnection, TextReader) Executes the statements defined in the given Oracle database script.
Public Extension Method ExecuteOracleScript(IDbConnection, String) Executes the statements defined in the given Oracle database script.
Public Extension Method ExecuteReader(IDbCommand, String, Object) Executes the SQL statement using IDbCommand, and builds a IDataReader.
Public Extension Method ExecuteReader(OdbcCommand, String, Object) Executes the SQL statement using OdbcCommand, and builds a OdbcDataReader.
Public Extension Method ExecuteReader(OdbcConnection, String, Object) Executes the SQL statement using OdbcConnection, and builds a OdbcDataReader.
Public Extension Method ExecuteReader(OleDbCommand, String, Object) Executes the SQL statement using OleDbCommand, and builds a OleDbDataReader.
Public Extension Method ExecuteReader(OleDbConnection, String, Object) Executes the SQL statement using OleDbConnection, and builds a OleDbDataReader.
Public Extension Method ExecuteReader(SqlCommand, String, Object) Executes the SQL statement using SqlCommand, and builds a SqlDataReader.
Public Extension Method ExecuteReader(SqlConnection, String, Object) Executes the SQL statement using SqlConnection, and builds a SqlDataReader.
Public Extension Method ExecuteReader(IDbCommand, String, Int32, Object) Executes the SQL statement using IDbCommand, and builds a IDataReader.
Public Extension Method ExecuteReader(IDbCommand, String, CommandBehavior, Int32, Object) Executes the SQL statement using IDbCommand, and builds a IDataReader.
Public Extension Method ExecuteReader(OdbcCommand, String, CommandBehavior, Int32, Object) Executes the SQL statement using OdbcCommand, and builds a OdbcDataReader.
Public Extension Method ExecuteReader(OdbcConnection, String, CommandBehavior, Int32, Object) Executes the SQL statement using OdbcConnection, and builds a OdbcDataReader.
Public Extension Method ExecuteReader(OleDbCommand, String, CommandBehavior, Int32, Object) Executes the SQL statement using OleDbCommand, and builds a OleDbDataReader.
Public Extension Method ExecuteReader(OleDbConnection, String, CommandBehavior, Int32, Object) Executes the SQL statement using OleDbConnection, and builds a OleDbDataReader.
Public Extension Method ExecuteReader(SqlCommand, String, CommandBehavior, Int32, Object) Executes the SQL statement using SqlCommand, and builds a SqlDataReader.
Public Extension Method ExecuteReader(SqlConnection, String, CommandBehavior, Int32, Object) Executes the SQL statement using SqlConnection, and builds a SqlDataReader.
Public Extension Method ExecuteReaderTConnection(TConnection, String, Object) Executes the SQL statement using IDbConnection, and builds a IDataReader.
Public Extension Method ExecuteReaderTConnection(TConnection, String, Int32, Object) Executes the SQL statement using IDbConnection, and builds a IDataReader.
Public Extension Method ExecuteReaderTConnection(TConnection, String, CommandBehavior, Int32, Object) Executes the SQL statement using IDbConnection, and builds a IDataReader.
Public Extension Method ExecuteScalar(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 Method ExecuteScalar(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 Method ExecuteScalar(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 Method ExecuteScalar(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 Method ExecuteScalar(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 Method ExecuteScalar(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 Method ExecuteScalar(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 Method ExecuteScalar(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 Method ExecuteScalar(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 Method ExecuteScalar(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 Method ExecuteScalar(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 Method ExecuteScalar(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 Method ExecuteScalar(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 Method ExecuteScalar(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 Method ExecuteScalarTConnection(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 Method ExecuteScalarTConnection(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 Method ExecuteTSQLScript(IDbConnection, TextReader) Executes the statements defined in the given TSQL script.
Public Extension Method ExecuteTSQLScript(IDbConnection, String) Executes the statements defined in the given TSQL script.
Public Extension Method PopulateParameters(OdbcCommand, Object) Takes the OdbcCommand object and populates it with the given parameters.
Public Extension Method PopulateParameters(OleDbCommand, Object) Takes the OleDbCommand object and populates it with the given parameters.
Public Extension Method PopulateParameters(SqlCommand, Object) Takes the SqlCommand object and populates it with the given parameters.
Public Extension Method PopulateParameters(OdbcCommand, Object, Object) Takes the OdbcCommand object and populates it with the given parameters.
Public Extension Method PopulateParameters(OleDbCommand, Object, Object) Takes the OleDbCommand object and populates it with the given parameters.
Public Extension Method PopulateParameters(SqlCommand, Object, Object) Takes the SqlCommand object and populates it with the given parameters.
Public Extension Method PopulateParametersTDbCommand(TDbCommand, ActionTDbCommand, Object) Takes the IDbCommand object and populates it with the given parameters.
Public Extension Method RetrieveData(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 Method RetrieveData(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 Method RetrieveData(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 Method RetrieveData(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 Method RetrieveData(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 Method RetrieveData(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 Method RetrieveData(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 Method RetrieveData(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 Method RetrieveData(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 Method RetrieveData(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 Method RetrieveData(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 Method RetrieveData(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 Method RetrieveData(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 Method RetrieveData(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 Method RetrieveData(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 Method RetrieveData(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 Method RetrieveData(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 Method RetrieveData(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 Method RetrieveData(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 Method RetrieveData(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 Method RetrieveData(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 Method RetrieveData(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 Method RetrieveData(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 Method RetrieveData(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 Method RetrieveData(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 Method RetrieveData(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 Method RetrieveData(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 Method RetrieveData(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 Method RetrieveDataSet(OdbcCommand, String) Executes the SQL statement using OdbcCommand, and returns the DataSet that may contain multiple tables, depending on the SQL statement.
Public Extension Method RetrieveDataSet(OdbcConnection, String) Executes the SQL statement using OdbcConnection, and returns the DataSet that may contain multiple tables, depending on the SQL statement.
Public Extension Method RetrieveDataSet(OleDbCommand, String) Executes the SQL statement using OleDbCommand, and returns the DataSet that may contain multiple tables, depending on the SQL statement.
Public Extension Method RetrieveDataSet(OleDbConnection, String) Executes the SQL statement using OleDbConnection, and returns the DataSet that may contain multiple tables, depending on the SQL statement.
Public Extension Method RetrieveDataSet(SqlCommand, String) Executes the SQL statement using SqlCommand, and returns the DataSet that may contain multiple table depending on the SQL statement.
Public Extension Method RetrieveDataSet(SqlConnection, String) Executes the SQL statement using SqlConnection, and returns the DataSet that may contain multiple table depending on the SQL statement.
Public Extension Method RetrieveDataSet(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 Method RetrieveDataSet(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 Method RetrieveDataSet(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 Method RetrieveDataSet(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 Method RetrieveDataSet(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 Method RetrieveDataSet(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 Method RetrieveDataSet(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 Method RetrieveDataSet(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 Method RetrieveDataSet(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 Method RetrieveDataSet(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 Method RetrieveDataSet(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 Method RetrieveDataSet(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 Method RetrieveDataSet(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 Method RetrieveDataSet(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 Method RetrieveDataSet(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 Method RetrieveDataSet(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 Method RetrieveDataSet(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 Method RetrieveDataSet(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 Method RetrieveDataSet(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 Method RetrieveDataSet(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 Method RetrieveDataSet(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 Method RetrieveDataSet(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 Method RetrieveRow(OdbcCommand, String) Executes the SQL statement using OdbcCommand, and returns the first DataRow in the result set.
Public Extension Method RetrieveRow(OdbcConnection, String) Executes the SQL statement using OdbcConnection, and returns the first DataRow in the result set.
Public Extension Method RetrieveRow(OleDbCommand, String) Executes the SQL statement using OleDbCommand, and returns the first DataRow in the result set.
Public Extension Method RetrieveRow(OleDbConnection, String) Executes the SQL statement using OleDbConnection, and returns the first DataRow in the result set.
Public Extension Method RetrieveRow(SqlCommand, String) Executes the SQL statement using SqlCommand, and returns the first DataRow in the result set.
Public Extension Method RetrieveRow(SqlConnection, String) Executes the SQL statement using SqlConnection, and returns the first DataRow in the result set.
Public Extension Method RetrieveRow(OdbcCommand, String, Int32) Executes the SQL statement using OdbcCommand, and returns the first DataRow in the result set.
Public Extension Method RetrieveRow(OdbcCommand, String, Object) Executes the SQL statement using OdbcCommand, and returns the first DataRow in the result set.
Public Extension Method RetrieveRow(OdbcConnection, String, Int32) Executes the SQL statement using OdbcConnection, and returns the first DataRow in the result set.
Public Extension Method RetrieveRow(OdbcConnection, String, Object) Executes the SQL statement using OdbcConnection, and returns the first DataRow in the result set.
Public Extension Method RetrieveRow(OleDbCommand, String, Int32) Executes the SQL statement using OleDbCommand, and returns the first DataRow in the result set.
Public Extension Method RetrieveRow(OleDbCommand, String, Object) Executes the SQL statement using OleDbCommand, and returns the first DataRow in the result set.
Public Extension Method RetrieveRow(OleDbConnection, String, Int32) Executes the SQL statement using OleDbConnection, and returns the first DataRow in the result set.
Public Extension Method RetrieveRow(OleDbConnection, String, Object) Executes the SQL statement using OleDbConnection, and returns the first DataRow in the result set.
Public Extension Method RetrieveRow(SqlCommand, String, Int32) Executes the SQL statement using SqlCommand, and returns the first DataRow in the result set.
Public Extension Method RetrieveRow(SqlCommand, String, Object) Executes the SQL statement using SqlCommand, and returns the first DataRow in the result set.
Public Extension Method RetrieveRow(SqlConnection, String, Int32) Executes the SQL statement using SqlConnection, and returns the first DataRow in the result set.
Public Extension Method RetrieveRow(SqlConnection, String, Object) Executes the SQL statement using SqlConnection, and returns the first DataRow in the result set.
Public Extension Method RetrieveRow(IDbCommand, Type, String, Object) Executes the SQL statement using IDbCommand, and returns the first DataRow in the result set.
Public Extension Method RetrieveRow(IDbConnection, Type, String, Object) Executes the SQL statement using IDbConnection, and returns the first DataRow in the result set.
Public Extension Method RetrieveRow(OdbcCommand, String, Int32, Object) Executes the SQL statement using OdbcCommand, and returns the first DataRow in the result set.
Public Extension Method RetrieveRow(OdbcConnection, String, Int32, Object) Executes the SQL statement using OdbcConnection, and returns the first DataRow in the result set.
Public Extension Method RetrieveRow(OleDbCommand, String, Int32, Object) Executes the SQL statement using OleDbCommand, and returns the first DataRow in the result set.
Public Extension Method RetrieveRow(OleDbConnection, String, Int32, Object) Executes the SQL statement using OleDbConnection, and returns the first DataRow in the result set.
Public Extension Method RetrieveRow(SqlCommand, String, Int32, Object) Executes the SQL statement using SqlCommand, and returns the first DataRow in the result set.
Public Extension Method RetrieveRow(SqlConnection, String, Int32, Object) Executes the SQL statement using SqlConnection, and returns the first DataRow in the result set.
Public Extension Method RetrieveRow(IDbCommand, Type, String, Int32, Object) Executes the SQL statement using IDbCommand, and returns the first DataRow in the result set.
Public Extension Method RetrieveRow(IDbConnection, Type, String, Int32, Object) Executes the SQL statement using IDbConnection, and returns the first DataRow in the result set.
Public Extension Method SQLEncode Performs SQL encoding on given SQL string.
Public Extension Method ToDataTable Converts a delimited string into a DataTable.
Public Extension Method ToDelimitedString Converts the DataTable to a multi-line delimited string (e.g., CSV export).
Public Extension Method TryRetrieveRow(IDbCommand, Type, String, DataRow, Object) Tries to retrieve the first DataRow in the result set of the SQL statement using IDbCommand.
Public Extension Method TryRetrieveRow(IDbConnection, Type, String, DataRow, Object) Tries to retrieve the first DataRow in the result set of the SQL statement using IDbConnection.
Public Extension Method TryRetrieveRow(IDbCommand, Type, String, Int32, DataRow, Object) Tries to retrieve the first DataRow in the result set of the SQL statement using IDbCommand.
Public Extension Method TryRetrieveRow(IDbConnection, Type, String, Int32, DataRow, Object) Tries to retrieve the first DataRow in the result set of the SQL statement using IDbConnection.
Public Extension Method UpdateData(OdbcConnection, DataTable, String) Updates the underlying data of the DataTable using OdbcConnection, and returns the number of rows successfully updated.
Public Extension Method UpdateData(OleDbConnection, DataTable, String) Updates the underlying data of the DataTable using OleDbConnection, and returns the number of rows successfully updated.
Public Extension Method UpdateData(SqlConnection, DataTable, String) Updates the underlying data of the DataTable using SqlConnection, and returns the number of rows successfully updated.
Top
See Also