ExecuteReader() private static method

Executes a single command against a MySQL database, possibly inside an existing transaction.
private static ExecuteReader ( MySqlConnection connection, MySql.Data.MySqlClient.MySqlTransaction transaction, string commandText, MySqlParameter commandParameters, bool ExternalConn ) : MySqlDataReader
connection MySqlConnection object to use for the command
transaction MySql.Data.MySqlClient.MySqlTransaction object to use for the command
commandText string Command text to use
commandParameters MySqlParameter Array of objects to use with the command
ExternalConn bool True if the connection should be preserved, false if not
return MySqlDataReader
MySqlHelper Class Documentation
示例#1
0
        public static Task <MySqlDataReader> ExecuteReaderAsync(string connectionString, string commandText, CancellationToken cancellationToken, params MySqlParameter[] commandParameters)
        {
            TaskCompletionSource <MySqlDataReader> taskCompletionSource = new TaskCompletionSource <MySqlDataReader>();

            if (cancellationToken == CancellationToken.None || !cancellationToken.IsCancellationRequested)
            {
                try
                {
                    MySqlDataReader result = MySqlHelper.ExecuteReader(connectionString, commandText, commandParameters);
                    taskCompletionSource.SetResult(result);
                    goto IL_3F;
                }
                catch (Exception exception)
                {
                    taskCompletionSource.SetException(exception);
                    goto IL_3F;
                }
            }
            taskCompletionSource.SetCanceled();
IL_3F:
            return(taskCompletionSource.Task);
        }
示例#2
0
        private static Task <MySqlDataReader> ExecuteReaderAsync(MySqlConnection connection, MySqlTransaction transaction, string commandText, MySqlParameter[] commandParameters, bool ExternalConn, CancellationToken cancellationToken)
        {
            TaskCompletionSource <MySqlDataReader> taskCompletionSource = new TaskCompletionSource <MySqlDataReader>();

            if (cancellationToken == CancellationToken.None || !cancellationToken.IsCancellationRequested)
            {
                try
                {
                    MySqlDataReader result = MySqlHelper.ExecuteReader(connection, transaction, commandText, commandParameters, ExternalConn);
                    taskCompletionSource.SetResult(result);
                    goto IL_43;
                }
                catch (Exception exception)
                {
                    taskCompletionSource.SetException(exception);
                    goto IL_43;
                }
            }
            taskCompletionSource.SetCanceled();
IL_43:
            return(taskCompletionSource.Task);
        }
示例#3
0
 public static Task <MySqlDataReader> ExecuteReaderAsync(string connectionString, string commandText, params MySqlParameter[] commandParameters)
 {
     return(Task.Factory.StartNew <MySqlDataReader>(() => MySqlHelper.ExecuteReader(connectionString, commandText, commandParameters)));
 }
示例#4
0
 private static Task <MySqlDataReader> ExecuteReaderAsync(MySqlConnection connection, MySqlTransaction transaction, string commandText, MySqlParameter[] commandParameters, bool ExternalConn)
 {
     return(Task.Factory.StartNew <MySqlDataReader>(() => MySqlHelper.ExecuteReader(connection, transaction, commandText, commandParameters, ExternalConn)));
 }
示例#5
0
 public static MySqlDataReader ExecuteReader(MySqlConnection connection, string commandText, params MySqlParameter[] commandParameters)
 {
     return(MySqlHelper.ExecuteReader(connection, null, commandText, commandParameters, true));
 }
示例#6
0
 public static MySqlDataReader ExecuteReader(MySqlConnection connection, string commandText)
 {
     return(MySqlHelper.ExecuteReader(connection, null, commandText, null, true));
 }
示例#7
0
 public static MySqlDataReader ExecuteReader(string connectionString, string commandText)
 {
     return(MySqlHelper.ExecuteReader(connectionString, commandText, null));
 }