C# (CSharp) MySql.Data.MySqlClient MySqlConnection.CheckNull Examples

Example #1

 /// <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));
 }

Example #2

File: Extensions.MySqlConnection.ExecuteReader.cs Project: cosmos-loops/cosmos-data

 /// <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));
 }

Example #3

File: Extensions.MySqlConnection.ExecuteReader.cs Project: cosmos-loops/cosmos-data

 /// <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));
 }

Example #4

File: Extensions.MySqlConnection.ExecuteScalarTo.cs Project: cosmos-loops/cosmos-data

 /// <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>());
 }

Example #5

File: Extensions.MySqlConnection.ExecuteScalarTo.cs Project: cosmos-loops/cosmos-data

 /// <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));
 }

Example #6

File: Extensions.MySqlConnection.ExecuteScalarTo.cs Project: cosmos-loops/cosmos-data

 /// <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));
 }

Example #7

File: Extensions.MySqlConnection.ExecuteScalarTo.cs Project: cosmos-loops/cosmos-data

 /// <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));
 }

Example #8

File: Extensions.MySqlConnection.ExecuteNonQuery.cs Project: cosmos-loops/cosmos-data

 /// <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());
 }

Example #9

File: Extensions.MySqlConnection.ExecuteNonQuery.cs Project: cosmos-loops/cosmos-data

 /// <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));
 }

Example #10

 /// <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));
 }

Example #11

 /// <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));
 }

Example #12

 /// <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));
 }

Example #13

 /// <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));
 }

Example #14

 /// <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());
 }

Example #15

 /// <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));
 }

Example #16

File: Extensions.MySqlConnection.ExecuteNonQuery.cs Project: cosmos-loops/cosmos-data

 /// <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();
 }

Example #17

 /// <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));
 }

Example #18

File: Extensions.MySqlConnection.ExecuteNonQuery.cs Project: cosmos-loops/cosmos-data

 /// <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));
 }

Example #19

File: Extensions.MySqlConnection.ExecuteScalarTo.cs Project: cosmos-loops/cosmos-data

 /// <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>());
 }

Example #20

File: Extensions.MySqlConnection.ExecuteNonQuery.cs Project: cosmos-loops/cosmos-data

 /// <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));
 }

Example #21

File: Extensions.MySqlConnection.ExecuteScalarTo.cs Project: cosmos-loops/cosmos-data

 /// <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));
 }

Example #22

File: Extensions.MySqlConnection.ExecuteNonQuery.cs Project: cosmos-loops/cosmos-data

 /// <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();
 }

Example #23

File: Extensions.MySqlConnection.ExecuteScalarTo.cs Project: cosmos-loops/cosmos-data

 /// <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));
 }

Example #24

File: Extensions.MySqlConnection.ExecuteNonQuery.cs Project: cosmos-loops/cosmos-data

 /// <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);
 }

Example #25

File: Extensions.MySqlConnection.ExecuteReader.cs Project: cosmos-loops/cosmos-data

 /// <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));
 }

Example #26

File: Extensions.MySqlConnection.ExecuteNonQuery.cs Project: cosmos-loops/cosmos-data

 /// <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);
 }

Example #27

File: Extensions.MySqlConnection.ExecuteReader.cs Project: cosmos-loops/cosmos-data

 /// <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());
 }

Example #28

 /// <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));
 }

Example #29

File: Extensions.MySqlConnection.ExecuteReader.cs Project: cosmos-loops/cosmos-data

 /// <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));
 }

Example #30

 /// <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());
 }