C# Class Engage.Dnn.Booking.SqlDataProvider

Base functionality for SQL Server data access
Afficher le fichier Open project: EngageSoftware/Engage-Booking

Méthodes publiques

Méthode Description
ExecuteDataTable ( string storedProcedureName ) : DataTable

Executes a SQL stored procedure, returning the results as a SqlDataReader.
ExecuteNonQuery ( string storedProcedureName ) : void

Executes a SQL stored procedure without returning any value.
ExecuteReader ( string storedProcedureName ) : System.Data.SqlClient.SqlDataReader

Executes a SQL stored procedure, returning the results as a SqlDataReader.
ExecuteScalar ( string storedProcedureName ) : object

Executes a SQL stored procedure, returning a single value.

Private Methods

Méthode Description
SqlDataProvider ( ) : System

Prevents a default instance of the SqlDataProvider class from being created.

Method Details

ExecuteDataTable() public méthode

Executes a SQL stored procedure, returning the results as a SqlDataReader.
if there's an error while going to the database to retrieve the appointments
public ExecuteDataTable ( string storedProcedureName ) : DataTable
storedProcedureName string Name of the stored procedure. Does not include any prefix, for example "GetAppointment" is translated to "dnn_EngageBooking_spGetAppointment."
Résultat System.Data.DataTable

ExecuteNonQuery() public méthode

Executes a SQL stored procedure without returning any value.
if there's an error while going to the database to retrieve the appointments
public ExecuteNonQuery ( string storedProcedureName ) : void
storedProcedureName string Name of the stored procedure. Does not include any prefix, for example "InsertAppointment" is translated to "dnn_EngageBooking_spInsertAppointment."
Résultat void

ExecuteReader() public méthode

Executes a SQL stored procedure, returning the results as a SqlDataReader.
if there's an error while going to the database to retrieve the appointments
public ExecuteReader ( string storedProcedureName ) : System.Data.SqlClient.SqlDataReader
storedProcedureName string Name of the stored procedure. Does not include any prefix, for example "GetAppointment" is translated to "dnn_EngageBooking_spGetAppointment."
Résultat System.Data.SqlClient.SqlDataReader

ExecuteScalar() public méthode

Executes a SQL stored procedure, returning a single value.
if there's an error while going to the database to retrieve the appointments
public ExecuteScalar ( string storedProcedureName ) : object
storedProcedureName string Name of the stored procedure. Does not include any prefix, for example "InsertAppointment" is translated to "dnn_EngageBooking_spInsertAppointment."
Résultat object