/// <summary> /// Execute DataTable async /// </summary> /// <param name="conn"></param> /// <param name="cmdText"></param> /// <param name="commandType"></param> /// <returns></returns> public static Task <DataTable> ExecuteDataTableAsync(this MySqlConnection conn, string cmdText, CommandType commandType) { conn.CheckNull(nameof(conn)); return(conn.ExecuteDataTableAsync(cmdText, null, commandType, null)); }
/// <summary> /// Execute Reader /// </summary> /// <param name="conn"></param> /// <param name="cmdText"></param> /// <param name="parameters"></param> /// <param name="commandType"></param> /// <returns></returns> public static Task <MySqlDataReader> ExecuteReaderAsync(this MySqlConnection conn, string cmdText, MySqlParameter[] parameters, CommandType commandType) { conn.CheckNull(nameof(conn)); return(conn.ExecuteReaderAsync(cmdText, parameters, commandType, null)); }
/// <summary> /// Execute Reader /// </summary> /// <param name="conn"></param> /// <param name="cmdText"></param> /// <param name="commandType"></param> /// <param name="transaction"></param> /// <returns></returns> public static MySqlDataReader ExecuteReader(this MySqlConnection conn, string cmdText, CommandType commandType, MySqlTransaction transaction) { conn.CheckNull(nameof(conn)); return(conn.ExecuteReader(cmdText, null, commandType, transaction)); }
/// <summary> /// Execute Scalar to... /// </summary> /// <param name="conn"></param> /// <param name="commandFactory"></param> /// <typeparam name="T"></typeparam> /// <returns></returns> public static T ExecuteScalarTo <T>(this MySqlConnection conn, Action <MySqlCommand> commandFactory) { conn.CheckNull(nameof(conn)); using var command = conn.CreateCommand(commandFactory); return(command.ExecuteScalar().CastTo <T>()); }
/// <summary> /// Execute Scalar to... /// </summary> /// <param name="conn"></param> /// <param name="cmdText"></param> /// <param name="commandType"></param> /// <param name="transaction"></param> /// <typeparam name="T"></typeparam> /// <returns></returns> public static T ExecuteScalarTo <T>(this MySqlConnection conn, string cmdText, CommandType commandType, MySqlTransaction transaction) { conn.CheckNull(nameof(conn)); return(conn.ExecuteScalarTo <T>(cmdText, null, commandType, transaction)); }
/// <summary> /// Execute Scalar to... /// </summary> /// <param name="conn"></param> /// <param name="cmdText"></param> /// <param name="parameters"></param> /// <param name="transaction"></param> /// <typeparam name="T"></typeparam> /// <returns></returns> public static T ExecuteScalarTo <T>(this MySqlConnection conn, string cmdText, MySqlParameter[] parameters, MySqlTransaction transaction) { conn.CheckNull(nameof(conn)); return(conn.ExecuteScalarTo <T>(cmdText, parameters, CommandType.Text, transaction)); }
/// <summary> /// Execute Scalar to... /// </summary> /// <param name="conn"></param> /// <param name="cmdText"></param> /// <param name="transaction"></param> /// <typeparam name="T"></typeparam> /// <returns></returns> public static Task <T> ExecuteScalarToAsync <T>(this MySqlConnection conn, string cmdText, MySqlTransaction transaction) { conn.CheckNull(nameof(conn)); return(conn.ExecuteScalarToAsync <T>(cmdText, null, CommandType.Text, transaction)); }
/// <summary> /// Execute NonQuery /// </summary> /// <param name="conn"></param> /// <param name="commandFactory"></param> public static Task ExecuteNonQueryAsync(this MySqlConnection conn, Action <MySqlCommand> commandFactory) { conn.CheckNull(nameof(conn)); using var command = conn.CreateCommand(commandFactory); return(command.ExecuteNonQueryAsync()); }
/// <summary> /// Execute NonQuery /// </summary> /// <param name="conn"></param> /// <param name="cmdText"></param> public static Task ExecuteNonQueryAsync(this MySqlConnection conn, string cmdText) { conn.CheckNull(nameof(conn)); return(conn.ExecuteNonQueryAsync(cmdText, null, CommandType.Text, null)); }
/// <summary> /// Execute DataSet /// </summary> /// <param name="conn"></param> /// <param name="cmdText"></param> /// <param name="transaction"></param> /// <returns></returns> public static DataSet ExecuteDataSet(this MySqlConnection conn, string cmdText, MySqlTransaction transaction) { conn.CheckNull(nameof(conn)); return(conn.ExecuteDataSet(cmdText, null, CommandType.Text, transaction)); }
/// <summary> /// Execute DataSet /// </summary> /// <param name="conn"></param> /// <param name="cmdText"></param> /// <param name="commandType"></param> /// <returns></returns> public static DataSet ExecuteDataSet(this MySqlConnection conn, string cmdText, CommandType commandType) { conn.CheckNull(nameof(conn)); return(conn.ExecuteDataSet(cmdText, null, commandType, null)); }
/// <summary> /// Execute DataSet async /// </summary> /// <param name="conn"></param> /// <param name="cmdText"></param> /// <param name="parameters"></param> /// <returns></returns> public static Task <DataSet> ExecuteDataSetAsync(this MySqlConnection conn, string cmdText, MySqlParameter[] parameters) { conn.CheckNull(nameof(conn)); return(conn.ExecuteDataSetAsync(cmdText, parameters, CommandType.Text, null)); }
/// <summary> /// Execute DataTable /// </summary> /// <param name="conn"></param> /// <param name="cmdText"></param> /// <returns></returns> public static DataTable ExecuteDataTable(this MySqlConnection conn, string cmdText) { conn.CheckNull(nameof(conn)); return(conn.ExecuteDataTable(cmdText, null, CommandType.Text, null)); }
/// <summary> /// Execute DataTable /// </summary> /// <param name="conn"></param> /// <param name="commandFactory"></param> /// <returns></returns> public static DataTable ExecuteDataTable(this MySqlConnection conn, Action <MySqlCommand> commandFactory) { conn.CheckNull(nameof(conn)); using var command = conn.CreateCommand(commandFactory); return(command.ExecuteFirstDataTable()); }
/// <summary> /// Execute a set of expando object /// </summary> /// <param name="conn"></param> /// <param name="cmdText"></param> /// <param name="parameters"></param> /// <param name="commandType"></param> /// <returns></returns> public static Task <IEnumerable <dynamic> > ExecuteExpandoObjectsAsync(this MySqlConnection conn, string cmdText, MySqlParameter[] parameters, CommandType commandType) { conn.CheckNull(nameof(conn)); return(conn.ExecuteExpandoObjectsAsync(cmdText, parameters, commandType, null)); }
/// <summary> /// Execute NonQuery /// </summary> /// <param name="conn"></param> /// <param name="cmdText"></param> /// <param name="parameters"></param> /// <param name="commandType"></param> /// <param name="transaction"></param> public static void ExecuteNonQuery(this MySqlConnection conn, string cmdText, MySqlParameter[] parameters, CommandType commandType, MySqlTransaction transaction) { conn.CheckNull(nameof(conn)); using var command = conn.CreateCommand(cmdText, commandType, transaction, parameters); command.ExecuteNonQuery(); }
/// <summary> /// Execute a set of expando object /// </summary> /// <param name="conn"></param> /// <param name="cmdText"></param> /// <param name="commandType"></param> /// <param name="transaction"></param> /// <returns></returns> public static IEnumerable <dynamic> ExecuteExpandoObjects(this MySqlConnection conn, string cmdText, CommandType commandType, MySqlTransaction transaction) { conn.CheckNull(nameof(conn)); return(conn.ExecuteExpandoObjects(cmdText, null, commandType, transaction)); }
/// <summary> /// Execute NonQuery /// </summary> /// <param name="conn"></param> /// <param name="cmdText"></param> /// <param name="commandType"></param> /// <param name="transaction"></param> public static Task ExecuteNonQueryAsync(this MySqlConnection conn, string cmdText, CommandType commandType, MySqlTransaction transaction) { conn.CheckNull(nameof(conn)); return(conn.ExecuteNonQueryAsync(cmdText, null, commandType, transaction)); }
/// <summary> /// Execute Scalar to... /// </summary> /// <param name="conn"></param> /// <param name="cmdText"></param> /// <param name="parameters"></param> /// <param name="commandType"></param> /// <param name="transaction"></param> /// <typeparam name="T"></typeparam> /// <returns></returns> public static T ExecuteScalarTo <T>(this MySqlConnection conn, string cmdText, MySqlParameter[] parameters, CommandType commandType, MySqlTransaction transaction) { conn.CheckNull(nameof(conn)); using var command = conn.CreateCommand(cmdText, commandType, transaction, parameters); return(command.ExecuteScalar().CastTo <T>()); }
/// <summary> /// Execute NonQuery /// </summary> /// <param name="conn"></param> /// <param name="cmdText"></param> /// <param name="parameters"></param> /// <param name="transaction"></param> public static Task ExecuteNonQueryAsync(this MySqlConnection conn, string cmdText, MySqlParameter[] parameters, MySqlTransaction transaction) { conn.CheckNull(nameof(conn)); return(conn.ExecuteNonQueryAsync(cmdText, parameters, CommandType.Text, transaction)); }
/// <summary> /// Execute Scalar to... /// </summary> /// <param name="conn"></param> /// <param name="cmdText"></param> /// <param name="parameters"></param> /// <param name="commandType"></param> /// <typeparam name="T"></typeparam> /// <returns></returns> public static Task <T> ExecuteScalarToAsync <T>(this MySqlConnection conn, string cmdText, MySqlParameter[] parameters, CommandType commandType) { conn.CheckNull(nameof(conn)); return(conn.ExecuteScalarToAsync <T>(cmdText, parameters, commandType, null)); }
/// <summary> /// Execute NonQuery /// </summary> /// <param name="conn"></param> /// <param name="commandFactory"></param> public static void ExecuteNonQuery(this MySqlConnection conn, Action <MySqlCommand> commandFactory) { conn.CheckNull(nameof(conn)); using var command = conn.CreateCommand(commandFactory); command.ExecuteNonQuery(); }
/// <summary> /// Execute Scalar to... /// </summary> /// <param name="conn"></param> /// <param name="cmdText"></param> /// <typeparam name="T"></typeparam> /// <returns></returns> public static T ExecuteScalarTo <T>(this MySqlConnection conn, string cmdText) { conn.CheckNull(nameof(conn)); return(conn.ExecuteScalarTo <T>(cmdText, null, CommandType.Text, null)); }
/// <summary> /// Execute NonQuery /// </summary> /// <param name="conn"></param> /// <param name="cmdText"></param> /// <param name="commandType"></param> /// <param name="transaction"></param> public static void ExecuteNonQuery(this MySqlConnection conn, string cmdText, CommandType commandType, MySqlTransaction transaction) { conn.CheckNull(nameof(conn)); conn.ExecuteNonQuery(cmdText, null, commandType, transaction); }
/// <summary> /// Execute Reader /// </summary> /// <param name="conn"></param> /// <param name="cmdText"></param> /// <param name="transaction"></param> /// <returns></returns> public static Task <MySqlDataReader> ExecuteReaderAsync(this MySqlConnection conn, string cmdText, MySqlTransaction transaction) { conn.CheckNull(nameof(conn)); return(conn.ExecuteReaderAsync(cmdText, null, CommandType.Text, transaction)); }
/// <summary> /// Execute NonQuery /// </summary> /// <param name="conn"></param> /// <param name="cmdText"></param> /// <param name="parameters"></param> public static void ExecuteNonQuery(this MySqlConnection conn, string cmdText, MySqlParameter[] parameters) { conn.CheckNull(nameof(conn)); conn.ExecuteNonQuery(cmdText, parameters, CommandType.Text, null); }
/// <summary> /// Execute Reader /// </summary> /// <param name="conn"></param> /// <param name="commandFactory"></param> /// <returns></returns> public static MySqlDataReader ExecuteReader(this MySqlConnection conn, Action <MySqlCommand> commandFactory) { conn.CheckNull(nameof(conn)); using var command = conn.CreateCommand(commandFactory); return(command.ExecuteReader()); }
/// <summary> /// Execute a set of expando object /// </summary> /// <param name="conn"></param> /// <param name="cmdText"></param> /// <param name="transaction"></param> /// <returns></returns> public static Task <IEnumerable <dynamic> > ExecuteExpandoObjectsAsync(this MySqlConnection conn, string cmdText, MySqlTransaction transaction) { conn.CheckNull(nameof(conn)); return(conn.ExecuteExpandoObjectsAsync(cmdText, null, CommandType.Text, transaction)); }
/// <summary> /// Execute Reader /// </summary> /// <param name="conn"></param> /// <param name="cmdText"></param> /// <param name="parameters"></param> /// <returns></returns> public static MySqlDataReader ExecuteReader(this MySqlConnection conn, string cmdText, MySqlParameter[] parameters) { conn.CheckNull(nameof(conn)); return(conn.ExecuteReader(cmdText, parameters, CommandType.Text, null)); }
/// <summary> /// Execute DataTable /// </summary> /// <param name="conn"></param> /// <param name="cmdText"></param> /// <param name="parameters"></param> /// <param name="commandType"></param> /// <param name="transaction"></param> /// <returns></returns> public static DataTable ExecuteDataTable(this MySqlConnection conn, string cmdText, MySqlParameter[] parameters, CommandType commandType, MySqlTransaction transaction) { conn.CheckNull(nameof(conn)); using var command = conn.CreateCommand(cmdText, commandType, transaction, parameters); return(command.ExecuteFirstDataTable()); }