Gemstone Data Library
Data
Defines extension functions related to database and SQL interaction.
Definition
Namespace: Gemstone.Data.DataExtensions
Assembly: Gemstone.Data (in Gemstone.Data.dll) Version: 1.0.169 -- Release Build+adcc694938ddb0c37a2b1414eab017f00bb57688
Assembly: Gemstone.Data (in Gemstone.Data.dll) Version: 1.0.169 -- Release Build+adcc694938ddb0c37a2b1414eab017f00bb57688
C#
public static class DataExtensionsVB
<ExtensionAttribute>
Public NotInheritable Class DataExtensionsC++
[ExtensionAttribute]
public ref class DataExtensions abstract sealedJavaScript
Gemstone.Data.DataExtensions.DataExtensions = function();
Type.createClass(
'Gemstone.Data.DataExtensions.DataExtensions');- Inheritance
- Object DataExtensions
Methods
| AddParametersWithValues | Creates and adds a new DbParameter for each of the specified values to the DbCommand object. |
| AddParameterWithValue | Creates and adds an DbParameter to the DbCommand object with the specified value. |
| AsAsyncEnumerable | Returns an IAsyncEnumerableT of DataRow values from the DataTable. |
| AsAwaitConfiguredCancelableAsyncEnumerable | Returns a cancellable IAsyncEnumerableT of DataRow values from the DataTable and configures how awaits on the tasks returned from an async iteration will be performed. |
| ConvertField(DataRow, String, Type) | Automatically applies type conversion to column values when only a type is available. |
| ConvertField(DataRow, String, Type, Object) | Automatically applies type conversion to column values when only a type is available. |
| 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. |
| 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. |
| ConvertGuidField | Parses a Guid from a database field that is a Guid type or a string representing a Guid. |
| ConvertNullableFieldT | Provides strongly-typed access to each of the column values in the specified row. Automatically applies type conversion to the column values. |
| CreateParameterizedCommand | Creates and returns a parameterized DbCommand. Parameter names are embedded in the SQL statement passed as a parameter to this method. |
| ExecuteMySQLScript(DbConnection, TextReader) | Executes the statements defined in the given MySQL script. |
| ExecuteMySQLScript(DbConnection, String) | Executes the statements defined in the given MySQL script. |
| ExecuteNonQuery(DbCommand, String, Object) | Executes the SQL statement using DbCommand, and returns the number of rows affected. |
| ExecuteNonQuery(DbConnection, String, Object) | Executes the SQL statement using DbConnection, and returns the number of rows affected. |
| ExecuteNonQuery(DbCommand, Int32, String, Object) | Executes the SQL statement using DbCommand, and returns the number of rows affected. |
| ExecuteNonQuery(DbConnection, Int32, String, Object) | Executes the SQL statement using DbConnection, and returns the number of rows affected. |
| ExecuteNonQueryAsync(DbCommand, String, CancellationToken, Object) | Executes the SQL statement using DbCommand, and returns the number of rows affected. |
| ExecuteNonQueryAsync(DbConnection, String, CancellationToken, Object) | Executes the SQL statement using DbConnection, and returns the number of rows affected. |
| ExecuteNonQueryAsync(DbCommand, Int32, String, CancellationToken, Object) | Executes the SQL statement using DbCommand, and returns the number of rows affected. |
| ExecuteNonQueryAsync(DbConnection, Int32, String, CancellationToken, Object) | Executes the SQL statement using DbConnection, and returns the number of rows affected. |
| ExecuteOracleScript(DbConnection, TextReader) | Executes the statements defined in the given Oracle database script. |
| ExecuteOracleScript(DbConnection, String) | Executes the statements defined in the given Oracle database script. |
| ExecuteReader(DbCommand, String, Object) | Executes the SQL statement using DbCommand, and builds a DbDataReader. |
| ExecuteReader(DbConnection, String, Object) | Executes the SQL statement using DbConnection, and builds a DbDataReader. |
| ExecuteReader(DbCommand, Int32, String, Object) | Executes the SQL statement using DbCommand, and builds a DbDataReader. |
| ExecuteReader(DbConnection, Int32, String, Object) | Executes the SQL statement using DbConnection, and builds a DbDataReader. |
| ExecuteReader(DbCommand, Int32, String, CommandBehavior, Object) | Executes the SQL statement using DbCommand, and builds a DbDataReader. |
| ExecuteReader(DbConnection, Int32, String, CommandBehavior, Object) | Executes the SQL statement using DbConnection, and builds a DbDataReader. |
| ExecuteReaderAsync(DbCommand, String, CancellationToken, Object) | Executes the SQL statement using DbCommand, and builds a DbDataReader. |
| ExecuteReaderAsync(DbConnection, String, CancellationToken, Object) | Executes the SQL statement using DbConnection, and builds a DbDataReader. |
| ExecuteReaderAsync(DbCommand, Int32, String, CancellationToken, Object) | Executes the SQL statement using DbCommand, and builds a DbDataReader. |
| ExecuteReaderAsync(DbConnection, Int32, String, CancellationToken, Object) | Executes the SQL statement using DbConnection, and builds a DbDataReader. |
| ExecuteReaderAsync(DbCommand, Int32, String, CommandBehavior, CancellationToken, Object) | Executes the SQL statement using DbCommand, and builds a DbDataReader. |
| ExecuteReaderAsync(DbConnection, Int32, String, CommandBehavior, CancellationToken, Object) | Executes the SQL statement using DbConnection, and builds a DbDataReader. |
| ExecuteScalar(DbCommand, String, Object) | Executes the SQL statement using DbCommand, and returns the value in the first column of the first row in the result set. |
| ExecuteScalar(DbConnection, String, Object) | Executes the SQL statement using DbConnection, and returns the value in the first column of the first row in the result set. |
| ExecuteScalar(DbCommand, Int32, String, Object) | Executes the SQL statement using DbCommand, and returns the value in the first column of the first row in the result set. |
| ExecuteScalar(DbConnection, Int32, String, Object) | Executes the SQL statement using DbConnection, and returns the value in the first column of the first row in the result set. |
| ExecuteScalarAsync(DbCommand, String, CancellationToken, Object) | Executes the SQL statement using DbCommand, and returns the value in the first column of the first row in the result set. |
| ExecuteScalarAsync(DbConnection, String, CancellationToken, Object) | Executes the SQL statement using DbConnection, and returns the value in the first column of the first row in the result set. |
| ExecuteScalarAsync(DbCommand, Int32, String, CancellationToken, Object) | Executes the SQL statement using DbCommand, and returns the value in the first column of the first row in the result set. |
| ExecuteScalarAsync(DbConnection, Int32, String, CancellationToken, Object) | Executes the SQL statement using DbConnection, and returns the value in the first column of the first row in the result set. |
| ExecuteTSQLScript(DbConnection, TextReader) | Executes the statements defined in the given TSQL script. |
| ExecuteTSQLScript(DbConnection, String) | Executes the statements defined in the given TSQL script. |
| NullAsDBNull | Gets any null parameter values as DBNull. |
| PopulateParameters(SqlCommand, Object) | Takes the SqlCommand object and populates it with the given parameters. |
| PopulateParameters(SqlCommand, Object, Object) | Takes the SqlCommand object and populates it with the given parameters. |
| PopulateParametersTDbCommand(TDbCommand, ActionTDbCommand, Object) | Takes the DbCommand object and populates it with the given parameters. |
| RetrieveData(DbCommand, String, Object) | Executes the SQL statement using DbCommand, and returns the first DataTable of result set, if the result set contains multiple tables. |
| RetrieveData(DbConnection, String, Object) | Executes the SQL statement using DbConnection, and returns the first DataTable of result set, if the result set contains multiple tables. |
| RetrieveData(DbCommand, Int32, String, Object) | Executes the SQL statement using DbCommand, and returns the first DataTable of result set, if the result set contains multiple tables. |
| RetrieveData(DbConnection, Int32, String, Object) | Executes the SQL statement using DbConnection, and returns the first DataTable of result set, if the result set contains multiple tables. |
| RetrieveDataAsync(DbCommand, String, CancellationToken, Object) | Executes the SQL statement using DbCommand, and returns the first DataTable of result set, if the result set contains multiple tables. |
| RetrieveDataAsync(DbConnection, String, CancellationToken, Object) | Executes the SQL statement using DbConnection, and returns the first DataTable of result set, if the result set contains multiple tables. |
| RetrieveDataAsync(DbCommand, Int32, String, CancellationToken, Object) | Executes the SQL statement using DbCommand, and returns the first DataTable of result set, if the result set contains multiple tables. |
| RetrieveDataAsync(DbConnection, Int32, String, CancellationToken, Object) | Executes the SQL statement using DbConnection, and returns the first DataTable of result set, if the result set contains multiple tables. |
| RetrieveDataSet(DbCommand, String, Object) | Executes the SQL statement using DbCommand, and returns the DataSet that may contain multiple tables, depending on the SQL statement. |
| RetrieveDataSet(DbConnection, String, Object) | Executes the SQL statement using DbConnection, and returns the DataSet that may contain multiple tables, depending on the SQL statement. |
| RetrieveDataSet(DbCommand, Int32, String, Object) | Executes the SQL statement using DbCommand, and returns the DataSet that may contain multiple tables, depending on the SQL statement. |
| RetrieveDataSet(DbConnection, Int32, String, Object) | Executes the SQL statement using DbConnection, and returns the DataSet that may contain multiple tables, depending on the SQL statement. |
| RetrieveDataSetAsync(DbCommand, String, CancellationToken, Object) | Executes the SQL statement using DbCommand, and returns the DataSet that may contain multiple tables, depending on the SQL statement. |
| RetrieveDataSetAsync(DbConnection, String, CancellationToken, Object) | Executes the SQL statement using DbConnection, and returns the DataSet that may contain multiple tables, depending on the SQL statement. |
| RetrieveDataSetAsync(DbCommand, Int32, String, CancellationToken, Object) | Executes the SQL statement using DbCommand, and returns the DataSet that may contain multiple tables, depending on the SQL statement. |
| RetrieveDataSetAsync(DbConnection, Int32, String, CancellationToken, Object) | Executes the SQL statement using DbConnection, and returns the DataSet that may contain multiple tables, depending on the SQL statement. |
| RetrieveRow(DbCommand, String, Object) | Executes the SQL statement using DbCommand, and returns the first DataRow in the result set. |
| RetrieveRow(DbConnection, String, Object) | Executes the SQL statement using DbConnection, and returns the first DataRow in the result set. |
| RetrieveRow(DbCommand, Int32, String, Object) | Executes the SQL statement using DbCommand, and returns the first DataRow in the result set. |
| RetrieveRow(DbConnection, Int32, String, Object) | Executes the SQL statement using DbConnection, and returns the first DataRow in the result set. |
| RetrieveRowAsync(DbCommand, String, CancellationToken, Object) | Executes the SQL statement using DbCommand, and returns the first DataRow in the result set. |
| RetrieveRowAsync(DbConnection, String, CancellationToken, Object) | Executes the SQL statement using DbConnection, and returns the first DataRow in the result set. |
| RetrieveRowAsync(DbCommand, Int32, String, CancellationToken, Object) | Executes the SQL statement using DbCommand, and returns the first DataRow in the result set. |
| RetrieveRowAsync(DbConnection, Int32, String, CancellationToken, Object) | Executes the SQL statement using DbConnection, and returns the first DataRow in the result set. |
| SQLEncode | Performs SQL encoding on given SQL string. |
| ToDataTable | Converts a delimited string into a DataTable. |
| ToDelimitedString | Converts the DataTable to a multi-line delimited string (e.g., CSV export). |
| TryRetrieveRow(DbCommand, String, DataRow, Object) | Tries to retrieve the first DataRow in the result set of the SQL statement using DbCommand. |
| TryRetrieveRow(DbConnection, String, DataRow, Object) | Tries to retrieve the first DataRow in the result set of the SQL statement using DbConnection. |
| TryRetrieveRow(DbCommand, String, Int32, DataRow, Object) | Tries to retrieve the first DataRow in the result set of the SQL statement using DbCommand. |
| TryRetrieveRow(DbConnection, String, Int32, DataRow, Object) | Tries to retrieve the first DataRow in the result set of the SQL statement using DbConnection. |
| TryRetrieveRowAsync(DbCommand, String, CancellationToken, Object) | Tries to retrieve the first DataRow in the result set of the SQL statement using DbCommand. |
| TryRetrieveRowAsync(DbConnection, String, CancellationToken, Object) | Tries to retrieve the first DataRow in the result set of the SQL statement using DbConnection. |
| TryRetrieveRowAsync(DbCommand, String, Int32, CancellationToken, Object) | Tries to retrieve the first DataRow in the result set of the SQL statement using DbCommand. |
| TryRetrieveRowAsync(DbConnection, String, Int32, CancellationToken, Object) | Tries to retrieve the first DataRow in the result set of the SQL statement using DbConnection. |
| UpdateData | Updates the underlying data of the DataTable using SqlConnection, and returns the number of rows successfully updated. |
Fields
| DefaultTimeoutDuration | The default timeout duration used for executing SQL statements when timeout duration is not specified. |