Class DataProvider
Namespace: Mediachase.Data.Provider
Assembly: Mediachase.DataProvider.dll
Version: 12.17.2Syntax
public abstract class DataProvider : ProviderBaseConstructors
DataProvider()
Declaration
protected DataProvider()Properties
ApplicationName
Gets or sets the name of the application.
Declaration
public abstract string ApplicationName { get; set; }Property Value
| Type | Description |
|---|---|
| System.String | The name of the application. |
CommandTimeOut
Gets the connection time out from the configuration.
Declaration
public abstract int CommandTimeOut { get; }Property Value
| Type | Description |
|---|---|
| System.Int32 | The connection time out. |
Methods
ExecuteNonExec(DataCommand)
Declaration
public abstract DataResult ExecuteNonExec(DataCommand command)Parameters
| Type | Name | Description |
|---|---|---|
| DataCommand | command |
Returns
| Type | Description |
|---|---|
| DataResult |
ExecuteScalar(DataCommand)
Runs the return integer.
Declaration
public abstract DataResult ExecuteScalar(DataCommand command)Parameters
| Type | Name | Description |
|---|---|---|
| DataCommand | command | The command. |
Returns
| Type | Description |
|---|---|
| DataResult |
LoadDataSet(DataCommand)
Executes a command resulting in a data set, and returns the data set.
Declaration
public abstract 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. |
LoadReader(DataCommand)
Executes a command, and returns a reader enumerating the results.
Declaration
public abstract DataResult LoadReader(DataCommand command)Parameters
| Type | Name | Description |
|---|---|---|
| DataCommand | command | The command to execute. |
Returns
| Type | Description |
|---|---|
| DataResult | A DataResult containing the result reader. |
LoadReader(DataCommand, DateTimeKind)
Executes a command, and returns a reader enumerating the results.
Declaration
public virtual DataResult LoadReader(DataCommand command, DateTimeKind dateTimeKind)Parameters
| Type | Name | Description |
|---|---|---|
| DataCommand | command | The command to execute. |
| System.DateTimeKind | dateTimeKind | All DateTime values in the result will have
|
Returns
| Type | Description |
|---|---|
| DataResult | A DataResult containing the result reader. |
LoadTable(DataCommand)
Executes a command resulting in a single table, and returns the table.
Declaration
public abstract DataTable LoadTable(DataCommand command)Parameters
| Type | Name | Description |
|---|---|---|
| DataCommand | command | The command to execute. |
Returns
| Type | Description |
|---|---|
| System.Data.DataTable | The returned table. |
LoadTableSchema(DataCommand)
Declaration
public abstract DataTable LoadTableSchema(DataCommand command)Parameters
| Type | Name | Description |
|---|---|---|
| DataCommand | command |
Returns
| Type | Description |
|---|---|
| System.Data.DataTable |
Run(DataCommand)
Runs the specified command.
Declaration
public abstract void Run(DataCommand command)Parameters
| Type | Name | Description |
|---|---|---|
| DataCommand | command | The command. |
RunReturnInteger(DataCommand)
Runs the return integer.
Declaration
public abstract int RunReturnInteger(DataCommand command)Parameters
| Type | Name | Description |
|---|---|---|
| DataCommand | command | The command. |
Returns
| Type | Description |
|---|---|
| System.Int32 |
Save(DataCommand)
Saves the data table.
Declaration
public abstract DataResult Save(DataCommand command)Parameters
| Type | Name | Description |
|---|---|---|
| DataCommand | command | The command. |
Returns
| Type | Description |
|---|---|
| DataResult | Returns either DataTable or DataRow[] depending on what was passed in the command |
