doc.xml

比较好的异步数据库访问示例

<?xml version="1.0"?>
<doc>
    <assembly>
        <name>Ordina.Data.CrudHelper</name>
    </assembly>
    <members>
        <member name="T:Ordina.Data.SqlClient.CrudHelper.SqlHelper">
            <summary>
            The SqlHelper class is intended to be used as a thin layer between an
            application and an SQL server database. It abstracts the technical issues
            involved in fetching and updating data.
            </summary>
        </member>
        <member name="M:Ordina.Data.SqlClient.CrudHelper.SqlHelper.AttachParameters(System.Data.IDbCommand,System.Data.IDataParameter[])">
            <summary>
            This method is used to attach array of IDataParameters to an IDbCommand.
            
            This method will assign a value of DbNull to any parameter with a direction of
            InputOutput and a value of null.  
            
            This behavior will prevent default values from being used, but
            this will be the less common case than an intended pure output parameter (derived as InputOutput)
            where the user provided no input value.
            </summary>
            <param name="command">The command to which the parameters will be added</param>
            <param name="commandParameters">an array of IDataParameters to be added to command</param>
        </member>
        <member name="M:Ordina.Data.SqlClient.CrudHelper.SqlHelper.AssignParameterValues(System.Data.IDataParameter[],System.Object[])">
            <summary>
            This method assigns an array of values to an array of IDataParameters.
            </summary>
            <param name="commandParameters">array of IDataParameters to be assigned values</param>
            <param name="parameterValues">array of objects holding the values to be assigned</param>
        </member>
        <member name="M:Ordina.Data.SqlClient.CrudHelper.SqlHelper.PrepareCommand(System.Data.IDbCommand,System.Data.IDbConnection,System.Data.IDbTransaction,System.Data.CommandType,System.String,System.Data.IDataParameter[])">
            <summary>
            This method opens (if necessary) and assigns a connection, transaction, command type and parameters 
            to the provided command.
            </summary>
            <param name="command">the IDbCommand to be prepared</param>
            <param name="connection">a valid IDbConnection, on which to execute this command</param>
            <param name="transaction">a valid IDbTransaction, or 'null'</param>
            <param name="commandType">the CommandType (stored procedure, text, etc.)</param>
            <param name="commandText">the stored procedure name or T-SQL command</param>
            <param name="commandParameters">an array of IDataParameters to be associated with the command or 'null' if no parameters are required</param>
        </member>
        <member name="M:Ordina.Data.SqlClient.CrudHelper.SqlHelper.LogException(System.Data.SqlClient.SqlException)">
            <summary>
            This method logs an SQL Server error to the event log.
            </summary>
            <param name="sqlex">The error raised by the SqlClient data provider.</param>
        </member>
        <member name="M:Ordina.Data.SqlClient.CrudHelper.SqlHelper.GetConnection(System.String)">
            <summary>
            The method creates an SqlConnection object and returns it casted as IDbConnection.
            </summary>
            <param name="connectionString"></param>
            <returns>An SqlConnection object casted as IDbConnection</returns>
        </member>
        <member name="M:Ordina.Data.SqlClient.CrudHelper.SqlHelper.ExecuteNonQuery(System.Data.IDbConnection,System.Data.IDbTransaction,System.Data.CommandType,System.String,System.Data.IDataParameter[])">
            <summary>
            Execute a command that returns no resultset
            </summary>
            <param name="connection">a valid IDbConnection, on which to execute this command</param>
            <param name="transaction">a valid IDbTransaction, or 'null'</param>
            <param name="commandType">the CommandType (stored procedure, text, etc.)</param>
            <param name="commandText">the stored procedure name or T-SQL command</param>
            <param name="commandParameters">an array of IDataParameters to be associated with the command or 'null' if no parameters are required</param>
            <returns>an int representing the number of rows affected by the command</returns>
        </member>
        <member name="M:Ordina.Data.SqlClient.CrudHelper.SqlHelper.ExecuteNonQuery(System.String,System.Data.CommandType,System.String)">
            <summary>
            Execute a command that returns no resultset
            </summary>
            <param name="connectionString">a valid connection string for a connection yet to be opened</param>
            <param name="commandType">the CommandType (stored procedure, text, etc.)</param>
            <param name="commandText">the stored procedure name or T-SQL command</param>
            <returns>an int representing the number of rows affected by the command</returns>
        </member>
        <member name="M:Ordina.Data.SqlClient.CrudHelper.SqlHelper.ExecuteNonQuery(System.String,System.Data.CommandType,System.String,System.Data.IDataParameter[])">
            <summary>
            Execute a command that returns no resultset
            </summary>
            <param name="connectionString">a valid connection string for a connection yet to be opened</param>
            <param name="commandType">the CommandType (stored procedure, text, etc.)</param>
            <param name="commandText">the stored procedure name or T-SQL command</param>
            <param name="commandParameters">an array of IDataParameters to be associated with the command or 'null' if no parameters are required</param>
            <returns>an int representing the number of rows affected by the command</returns>
        </member>
        <member name="M:Ordina.Data.SqlClient.CrudHelper.SqlHelper.ExecuteNonQuery(System.String,System.String,System.Object[])">
            <summary>
            Execute a stored procedure via a command (that returns no resultset) against the database specified in 
            the connection string using the provided parameter values.  This method will query the database to discover the parameters for the 
            stored procedure (the first time each stored procedure is called), and assign the values based on parameter order.
            </summary>
            <param name="connectionString">a valid connection string for a connection yet to be opened</param>
            <param name="spName">the name of the stored prcedure</param>
            <param name="parameterValues">an array of objects to be assigned as the input values of the stored procedure</param>
            <returns>an int representing the number of rows affected by the command</returns>
        </member>
        <member name="M:Ordina.Data.SqlClient.CrudHelper.SqlHelper.ExecuteNonQuery(System.Data.IDbConnection,System.Data.CommandType,System.String)">
            <summary>
            Execute a command that returns no resultset
            </summary>
            <param name="connection">a valid IDbConnection</param>
            <param name="commandType">the CommandType (stored procedure, text, etc.)</param>
            <param name="commandText">the stored procedure name or T-SQL command</param>
            <returns>an int representing the number of rows affected by the command</returns>
        </member>
        <member name="M:Ordina.Data.SqlClient.CrudHelper.SqlHelper.ExecuteNonQuery(System.Data.IDbConnection,System.Data.CommandType,System.String,System.Data.IDataParameter[])">
            <summary>
            Execute a command that returns no resultset
            </summary>
            <param name="connection">a valid IDbConnection</param>
            <param name="commandType">the CommandType (stored procedure, text, etc.)</param>
            <param name="commandText">the stored procedure name or T-SQL command</param>
            <param name="commandParameters">an array of parameters used to execute the command</param>
            <returns>an int representing the number of rows affected by the command</returns>
        </member>
        <member name="M:Ordina.Data.SqlClient.CrudHelper.SqlHelper.ExecuteNonQuery(System.Data.IDbConnection,System.String,System.Object[])">
            <summary>
            Execute a stored procedure via a command (that returns no resultset) against the specified IDbConnection 
            using the provided parameter values.  This method will query the database to discover the parameters for the 
            stored procedure (the first time each stored procedure is called), and assign the values based on parameter order.
            </summary>
            <param name="connection">a valid IDbConnection</param>
            <param name="spName">the name of the stored procedure</param>
            <param name="parameterValues">an array of objects to be assigned as the input values of the stored procedure</param>
            <returns>an int representing the number of rows affected by the command</returns>
        </member>
        <member name="M:Ordina.Data.SqlClient.CrudHelper.SqlHelper.ExecuteNonQuery(System.Data.IDbTransaction,System.Data.CommandType,System.String)">
            <summary>
            Execute a command that returns no resultset
            </summary>
            <param name="transaction">a valid IDbTransaction</param>
            <param name="commandType">the CommandType (stored procedure, text, etc.)</param>
            <param name="commandText">the stored procedure name or T-SQL command</param>
            <returns>an int representing the number of rows affected by the command</returns>
        </member>
        <member name="M:Ordina.Data.SqlClient.CrudHelper.SqlHelper.ExecuteNonQuery(System.Data.IDbTransaction,System.Data.CommandType,System.String,System.Data.IDataParameter[])">
            <summary>
            Execute a command that returns no resultset
            </summary>
            <param name="transaction">a valid IDbTransaction</param>
            <param name="commandType">the CommandType (stored procedure, text, etc.)</param>
            <param name="commandText">the stored procedure name or T-SQL command</param>
            <param name="commandParameters">an array of IDataParameters used to execute the command</param>
            <returns>an int representing the number of rows affected by the command</returns>
        </member>
        <member name="M:Ordina.Data.SqlClient.CrudHelper.SqlHelper.ExecuteNonQuery(System.Data.IDbTransaction,System.String,System.Object[])">
            <summary>
            Execute a stored procedure via a SqlCommand (that returns no resultset) against the specified 
            IDbTransaction using the provided parameter values.  This method will query the database to discover the parameters for the 
            stored procedure (the first time each stored procedure is called), and assign the values based on parameter order.
            </summary>
            <param name="transaction">a valid IDbTransaction</param>
            <param name="spName">the name of the stored procedure</param>
            <param name="parameterValues">an array of objects to be assigned as the input values of the stored procedure</param>
            <returns>an int representing the number of rows affected by the command</returns>
        </member>
        <member name="M:Ordina.Data.SqlClient.CrudHelper.SqlHelper.BeginExecuteNonQuery(System.String,System.Data.CommandType,System.String,System.AsyncCallback,System.Object)">
            <summary>
            Execute a command that returns no resultset
            </summary>
            <param name="connectionString">a valid connection string for a connection yet to be opened</param>
            <param name="commandType">the CommandType (stored procedure, text, etc.)</param>