Class SqlDataProvider
Inheritance
System.Object
SqlDataProvider
Assembly: Mediachase.SqlDataProvider.dll
Version: 10.8.0
public class SqlDataProvider : DataProvider
Constructors
Declaration
Properties
Declaration
public override string ApplicationName { get; set; }
Property Value
Type |
Description |
System.String |
|
Overrides
Gets the connection time out from the configuration.
Declaration
public override int CommandTimeOut { get; }
Property Value
Type |
Description |
System.Int32 |
The connection time out.
|
Overrides
Methods
Declaration
protected SqlCommand CreateDeleteCommand(DataCommand command)
Parameters
Returns
Type |
Description |
System.Data.SqlClient.SqlCommand |
|
Declaration
protected SqlCommand CreateInsertCommand(DataCommand command)
Parameters
Returns
Type |
Description |
System.Data.SqlClient.SqlCommand |
|
Declaration
protected string CreateLoadCommand(SqlCommand cmd, DataCommand command)
Parameters
Type |
Name |
Description |
System.Data.SqlClient.SqlCommand |
cmd |
|
DataCommand |
command |
|
Returns
Type |
Description |
System.String |
|
Declaration
protected SqlCommand CreateParameters(DataCommand command)
Parameters
Returns
Type |
Description |
System.Data.SqlClient.SqlCommand |
|
Declaration
protected SqlCommand CreateUpdateCommand(DataCommand command)
Parameters
Returns
Type |
Description |
System.Data.SqlClient.SqlCommand |
|
Declaration
public override DataResult ExecuteNonExec(DataCommand command)
Parameters
Returns
Overrides
Declaration
public override DataResult ExecuteScalar(DataCommand command)
Parameters
Returns
Overrides
Initializes the provider.
Declaration
public override void Initialize(string name, NameValueCollection config)
Parameters
Type |
Name |
Description |
System.String |
name |
The friendly name of the provider.
|
System.Collections.Specialized.NameValueCollection |
config |
A collection of the name/value pairs representing the provider-specific attributes specified in the configuration for this provider.
|
Exceptions
Type |
Condition |
System.ArgumentNullException |
The name of the provider is null.
|
System.InvalidOperationException |
An attempt is made to call System.Configuration.Provider.ProviderBase.Initialize(System.String,System.Collections.Specialized.NameValueCollection) on a provider after the provider has already been initialized.
|
System.ArgumentException |
The name of the provider has a length of zero.
|
Executes a command resulting in a data set, and returns the data set.
Declaration
public override DataResult LoadDataSet(DataCommand command)
Parameters
Type |
Name |
Description |
DataCommand |
command |
The command to execute.
|
Returns
Type |
Description |
DataResult |
A data result containing the returned data set.
|
Overrides
Executes a command, and returns a reader enumerating the results.
Declaration
public override DataResult LoadReader(DataCommand command)
Parameters
Type |
Name |
Description |
DataCommand |
command |
The command to execute.
|
Returns
Overrides
Executes a command resulting in a single table, and returns the table.
Declaration
public override DataTable LoadTable(DataCommand command)
Parameters
Type |
Name |
Description |
DataCommand |
command |
The command to execute.
|
Returns
Type |
Description |
System.Data.DataTable |
The returned table.
|
Overrides
Declaration
public override DataTable LoadTableSchema(DataCommand command)
Parameters
Returns
Type |
Description |
System.Data.DataTable |
|
Overrides
Runs the specified command.
Declaration
public override void Run(DataCommand command)
Parameters
Overrides
Declaration
public override int RunReturnInteger(DataCommand command)
Parameters
Returns
Type |
Description |
System.Int32 |
|
Overrides
Declaration
public override DataResult Save(DataCommand command)
Parameters
Returns
Type |
Description |
DataResult |
Returns either DataTable or DataRow[] depending on what was passed in the command
|
Overrides