示例#1
0
 /// <summary>
 /// Query the database for a single row that returns as a single object of the supplied type.
 /// </summary>
 /// <typeparam name="T">The data return type.</typeparam>
 /// <param name="EstablishedConnection">An open and established connection to a MySQL database.</param>
 /// <param name="QueryString">The full SQL query string to be used to retrieve the value requested.</param>
 /// <param name="Parameters">Named parameters for the query.</param>
 /// <param name="ThrowException">Throw exception or cache in LastExecutionException and continue.</param>
 /// <param name="SqlTransaction">Supply an existing transaction for use in this operation.</param>
 /// <returns>An object populated with the requested data.</returns>
 public static T GetDataObject <T>(MySqlConnection EstablishedConnection, string QueryString, Dictionary <string, object> Parameters = null, bool ThrowException = true, MySqlTransaction SqlTransaction = null) where T : DALBaseModel
 => ObjectResultsHelper.GetDataObject <T>(EstablishedConnection, QueryString, Parameters : Parameters, ThrowException : ThrowException, SqlTransaction : SqlTransaction);
示例#2
0
        //***************** Object results *****************//

        /// <summary>
        /// Query the database for a single row that returns as a single object of the supplied type.
        /// </summary>
        /// <typeparam name="T">The data return type.</typeparam>
        /// <param name="ConfigConnectionString">An enum type to reference a connection string defined in web.config.</param>
        /// <param name="QueryString">The full SQL query string to be used to retrieve the value requested.</param>
        /// <param name="Parameters">Named parameters for the query.</param>
        /// <param name="ThrowException">Throw exception or cache in LastExecutionException and continue.</param>
        /// <param name="AllowUserVariables">Will allow special user variables (variables start with "@") to be defined in the query that will be eventually executed.</param>
        /// <returns>An object populated with the requested data.</returns>
        public static T GetDataObject <T>(Enum ConfigConnectionString, string QueryString, Dictionary <string, object> Parameters = null, bool ThrowException = true, bool AllowUserVariables = false) where T : DALBaseModel
        => ObjectResultsHelper.GetDataObject <T>(ConfigConnectionString, QueryString, Parameters : Parameters, ThrowException : ThrowException, AllowUserVariables : AllowUserVariables);