C# (CSharp) System.Data.SQLite SQLiteConnection.CheckNull Examples

Example #1

File: Extensions.SQLiteConnection.ExecuteExpandoObjects.cs Project: cosmos-loops/cosmos-data

 /// <summary>
 /// Execute ExpandoObjects
 /// </summary>
 /// <param name="conn"></param>
 /// <param name="cmdText"></param>
 /// <param name="commandType"></param>
 /// <param name="transaction"></param>
 /// <returns></returns>
 public static Task <IEnumerable <dynamic> > ExecuteExpandoObjectsAsync(this SQLiteConnection conn, string cmdText, CommandType commandType, SQLiteTransaction transaction)
 {
     conn.CheckNull(nameof(conn));
     return(conn.ExecuteExpandoObjectsAsync(cmdText, null, commandType, transaction));
 }

Example #2

File: Extensions.SQLiteConnection.ExecuteScalar.cs Project: cosmos-loops/cosmos-data

 /// <summary>
 /// Execute scalar
 /// </summary>
 /// <param name="conn"></param>
 /// <param name="cmdText"></param>
 /// <param name="parameters"></param>
 /// <param name="commandType"></param>
 /// <returns></returns>
 public static Task <object> ExecuteScalarAsync(this SQLiteConnection conn, string cmdText, SQLiteParameter[] parameters, CommandType commandType)
 {
     conn.CheckNull(nameof(conn));
     return(conn.ExecuteScalarAsync(cmdText, parameters, commandType, null));
 }

Example #3

File: Extensions.SQLiteConnection.ExecuteScalar.cs Project: cosmos-loops/cosmos-data

 /// <summary>
 /// Execute scalar
 /// </summary>
 /// <param name="conn"></param>
 /// <param name="cmdText"></param>
 /// <param name="transaction"></param>
 /// <returns></returns>
 public static object ExecuteScalar(this SQLiteConnection conn, string cmdText, SQLiteTransaction transaction)
 {
     conn.CheckNull(nameof(conn));
     return(conn.ExecuteScalar(cmdText, null, CommandType.Text, transaction));
 }

Example #4

File: Extensions.SQLiteConnection.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 Task <T> ExecuteScalarToAsync <T>(this SQLiteConnection conn, string cmdText, SQLiteParameter[] parameters, SQLiteTransaction transaction)
 {
     conn.CheckNull(nameof(conn));
     return(conn.ExecuteScalarToAsync <T>(cmdText, parameters, CommandType.Text, transaction));
 }

Example #5

File: Extensions.SQLiteConnection.ExecuteScalar.cs Project: cosmos-loops/cosmos-data

 /// <summary>
 /// Execute scalar
 /// </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 object ExecuteScalar(this SQLiteConnection conn, string cmdText, SQLiteParameter[] parameters, CommandType commandType, SQLiteTransaction transaction)
 {
     conn.CheckNull(nameof(conn));
     using var command = conn.CreateCommand(cmdText, commandType, transaction, parameters);
     return(command.ExecuteScalar());
 }

Example #6

 /// <summary>
 /// Execute DataTable
 /// </summary>
 /// <param name="conn"></param>
 /// <param name="commandFactory"></param>
 /// <returns></returns>
 public static DataTable ExecuteDataTable(this SQLiteConnection conn, Action <SQLiteCommand> commandFactory)
 {
     conn.CheckNull(nameof(conn));
     using var command = conn.CreateCommand(commandFactory);
     return(command.ExecuteFirstDataTable());
 }

Example #7

 /// <summary>
 /// Execute DataTable
 /// </summary>
 /// <param name="conn"></param>
 /// <param name="cmdText"></param>
 /// <param name="commandType"></param>
 /// <param name="transaction"></param>
 /// <returns></returns>
 public static DataTable ExecuteDataTable(this SQLiteConnection conn, string cmdText, CommandType commandType, SQLiteTransaction transaction)
 {
     conn.CheckNull(nameof(conn));
     return(conn.ExecuteDataTable(cmdText, null, commandType, transaction));
 }

Example #8

 /// <summary>
 /// Execute ExpandoObject
 /// </summary>
 /// <param name="conn"></param>
 /// <param name="cmdText"></param>
 /// <param name="parameters"></param>
 /// <param name="transaction"></param>
 /// <returns></returns>
 public static Task <dynamic> ExecuteExpandoObjectAsync(this SQLiteConnection conn, string cmdText, SQLiteParameter[] parameters, SQLiteTransaction transaction)
 {
     conn.CheckNull(nameof(conn));
     return(conn.ExecuteExpandoObjectAsync(cmdText, parameters, CommandType.Text, transaction));
 }

Example #9

 /// <summary>
 /// Execute ExpandoObject
 /// </summary>
 /// <param name="conn"></param>
 /// <param name="cmdText"></param>
 /// <returns></returns>
 public static dynamic ExecuteExpandoObject(this SQLiteConnection conn, string cmdText)
 {
     conn.CheckNull(nameof(conn));
     return(conn.ExecuteExpandoObject(cmdText, null, CommandType.Text, null));
 }

Example #10

 /// <summary>
 /// Execute ExpandoObject
 /// </summary>
 /// <param name="conn"></param>
 /// <param name="cmdText"></param>
 /// <param name="parameters"></param>
 /// <param name="commandType"></param>
 /// <returns></returns>
 public static dynamic ExecuteExpandoObject(this SQLiteConnection conn, string cmdText, SQLiteParameter[] parameters, CommandType commandType)
 {
     conn.CheckNull(nameof(conn));
     return(conn.ExecuteExpandoObject(cmdText, parameters, commandType, null));
 }

Example #11

 /// <summary>
 /// Execute ExpandoObject
 /// </summary>
 /// <param name="conn"></param>
 /// <param name="cmdText"></param>
 /// <param name="commandType"></param>
 /// <returns></returns>
 public static Task <dynamic> ExecuteExpandoObjectAsync(this SQLiteConnection conn, string cmdText, CommandType commandType)
 {
     conn.CheckNull(nameof(conn));
     return(conn.ExecuteExpandoObjectAsync(cmdText, null, commandType, null));
 }

Example #12

File: Extensions.SQLiteConnection.ExecuteScalarAs.cs Project: cosmos-loops/cosmos-data

 /// <summary>
 /// Execute scalar as
 /// </summary>
 /// <param name="conn"></param>
 /// <param name="cmdText"></param>
 /// <param name="parameters"></param>
 /// <typeparam name="T"></typeparam>
 /// <returns></returns>
 public static T ExecuteScalarAs <T>(this SQLiteConnection conn, string cmdText, SQLiteParameter[] parameters)
 {
     conn.CheckNull(nameof(conn));
     return(conn.ExecuteScalarAs <T>(cmdText, parameters, CommandType.Text, null));
 }

Example #13

File: Extensions.SQLiteConnection.ExecuteExpandoObjects.cs Project: cosmos-loops/cosmos-data

 /// <summary>
 /// Execute ExpandoObjects
 /// </summary>
 /// <param name="conn"></param>
 /// <param name="cmdText"></param>
 /// <param name="transaction"></param>
 /// <returns></returns>
 public static IEnumerable <dynamic> ExecuteExpandoObjects(this SQLiteConnection conn, string cmdText, SQLiteTransaction transaction)
 {
     conn.CheckNull(nameof(conn));
     return(conn.ExecuteExpandoObjects(cmdText, null, CommandType.Text, transaction));
 }

Example #14

File: Extensions.SQLiteConnection.ExecuteExpandoObjects.cs Project: cosmos-loops/cosmos-data

 /// <summary>
 /// Execute ExpandoObjects
 /// </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 SQLiteConnection conn, string cmdText, SQLiteParameter[] parameters, CommandType commandType)
 {
     conn.CheckNull(nameof(conn));
     return(conn.ExecuteExpandoObjectsAsync(cmdText, parameters, commandType, null));
 }

Example #15

 /// <summary>
 /// Execute DataTable
 /// </summary>
 /// <param name="conn"></param>
 /// <param name="cmdText"></param>
 /// <param name="commandType"></param>
 /// <returns></returns>
 public static Task <DataTable> ExecuteDataTableAsync(this SQLiteConnection conn, string cmdText, CommandType commandType)
 {
     conn.CheckNull(nameof(conn));
     return(conn.ExecuteDataTableAsync(cmdText, null, commandType, null));
 }

Example #16

 /// <summary>
 /// Execute ExpandoObject
 /// </summary>
 /// <param name="conn"></param>
 /// <param name="cmdText"></param>
 /// <param name="commandType"></param>
 /// <param name="transaction"></param>
 /// <returns></returns>
 public static dynamic ExecuteExpandoObject(this SQLiteConnection conn, string cmdText, CommandType commandType, SQLiteTransaction transaction)
 {
     conn.CheckNull(nameof(conn));
     return(conn.ExecuteExpandoObject(cmdText, null, commandType, transaction));
 }

Example #17

 /// <summary>
 /// Execute DataTable
 /// </summary>
 /// <param name="conn"></param>
 /// <param name="cmdText"></param>
 /// <param name="parameters"></param>
 /// <returns></returns>
 public static Task <DataTable> ExecuteDataTableAsync(this SQLiteConnection conn, string cmdText, SQLiteParameter[] parameters)
 {
     conn.CheckNull(nameof(conn));
     return(conn.ExecuteDataTableAsync(cmdText, parameters, CommandType.Text, null));
 }

Example #18

File: Extensions.SQLiteConnection.ExecuteEntity.cs Project: cosmos-loops/cosmos-data

 /// <summary>
 /// Execute Entity
 /// </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 ExecuteEntity <T>(this SQLiteConnection conn, string cmdText, SQLiteParameter[] parameters, SQLiteTransaction transaction) where T : new()
 {
     conn.CheckNull(nameof(conn));
     return(conn.ExecuteEntity <T>(cmdText, parameters, CommandType.Text, transaction));
 }

Example #19

 /// <summary>
 /// Execute DataTable
 /// </summary>
 /// <param name="conn"></param>
 /// <param name="cmdText"></param>
 /// <returns></returns>
 public static DataTable ExecuteDataTable(this SQLiteConnection conn, string cmdText)
 {
     conn.CheckNull(nameof(conn));
     return(conn.ExecuteDataTable(cmdText, null, CommandType.Text, null));
 }

Example #20

File: Extensions.SQLiteConnection.ExecuteEntity.cs Project: cosmos-loops/cosmos-data

 /// <summary>
 /// Execute Entity
 /// </summary>
 /// <param name="conn"></param>
 /// <param name="cmdText"></param>
 /// <typeparam name="T"></typeparam>
 /// <returns></returns>
 public static Task <T> ExecuteEntityAsync <T>(this SQLiteConnection conn, string cmdText) where T : new()
 {
     conn.CheckNull(nameof(conn));
     return(conn.ExecuteEntityAsync <T>(cmdText, null, CommandType.Text, null));
 }

Example #21

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

 /// <summary>
 /// Execute scalar to
 /// </summary>
 /// <param name="conn"></param>
 /// <param name="cmdText"></param>
 /// <param name="commandType"></param>
 /// <typeparam name="T"></typeparam>
 /// <returns></returns>
 public static Task <T> ExecuteScalarToAsync <T>(this SQLiteConnection conn, string cmdText, CommandType commandType)
 {
     conn.CheckNull(nameof(conn));
     return(conn.ExecuteScalarToAsync <T>(cmdText, null, commandType, null));
 }

Example #22

File: Extensions.SQLiteConnection.ExecuteEntity.cs Project: cosmos-loops/cosmos-data

 /// <summary>
 /// Execute Entity
 /// </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> ExecuteEntityAsync <T>(this SQLiteConnection conn, string cmdText, SQLiteParameter[] parameters, CommandType commandType) where T : new()
 {
     conn.CheckNull(nameof(conn));
     return(conn.ExecuteEntityAsync <T>(cmdText, parameters, commandType, null));
 }

Example #23

File: Extensions.SQLiteConnection.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 SQLiteConnection conn, string cmdText)
 {
     conn.CheckNull(nameof(conn));
     return(conn.ExecuteScalarTo <T>(cmdText, null, CommandType.Text, null));
 }

Example #24

File: Extensions.SQLiteConnection.ExecuteEntity.cs Project: cosmos-loops/cosmos-data

 /// <summary>
 /// Execute Entity
 /// </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 ExecuteEntity <T>(this SQLiteConnection conn, string cmdText, CommandType commandType, SQLiteTransaction transaction) where T : new()
 {
     conn.CheckNull(nameof(conn));
     return(conn.ExecuteEntity <T>(cmdText, null, commandType, transaction));
 }

Example #25

File: Extensions.SQLiteConnection.ExecuteScalar.cs Project: cosmos-loops/cosmos-data

 /// <summary>
 /// Execute scalar
 /// </summary>
 /// <param name="conn"></param>
 /// <param name="cmdText"></param>
 /// <param name="commandType"></param>
 /// <param name="transaction"></param>
 /// <returns></returns>
 public static Task <object> ExecuteScalarAsync(this SQLiteConnection conn, string cmdText, CommandType commandType, SQLiteTransaction transaction)
 {
     conn.CheckNull(nameof(conn));
     return(conn.ExecuteScalarAsync(cmdText, null, commandType, transaction));
 }

Example #26

 /// <summary>
 /// Execute DataTable
 /// </summary>
 /// <param name="conn"></param>
 /// <param name="cmdText"></param>
 /// <param name="parameters"></param>
 /// <param name="commandType"></param>
 /// <returns></returns>
 public static DataTable ExecuteDataTable(this SQLiteConnection conn, string cmdText, SQLiteParameter[] parameters, CommandType commandType)
 {
     conn.CheckNull(nameof(conn));
     return(conn.ExecuteDataTable(cmdText, parameters, commandType, null));
 }

Example #27

File: Extensions.SQLiteConnection.ExecuteScalar.cs Project: cosmos-loops/cosmos-data

 /// <summary>
 /// Execute scalar
 /// </summary>
 /// <param name="conn"></param>
 /// <param name="commandFactory"></param>
 /// <returns></returns>
 public static object ExecuteScalar(this SQLiteConnection conn, Action <SQLiteCommand> commandFactory)
 {
     conn.CheckNull(nameof(conn));
     using var command = conn.CreateCommand(commandFactory);
     return(command.ExecuteScalar());
 }

Example #28

 /// <summary>
 /// Execute DataTable
 /// </summary>
 /// <param name="conn"></param>
 /// <param name="cmdText"></param>
 /// <param name="transaction"></param>
 /// <returns></returns>
 public static Task <DataTable> ExecuteDataTableAsync(this SQLiteConnection conn, string cmdText, SQLiteTransaction transaction)
 {
     conn.CheckNull(nameof(conn));
     return(conn.ExecuteDataTableAsync(cmdText, null, CommandType.Text, transaction));
 }

Example #29

File: Extensions.SQLiteConnection.ExecuteScalar.cs Project: cosmos-loops/cosmos-data

 /// <summary>
 /// Execute scalar
 /// </summary>
 /// <param name="conn"></param>
 /// <param name="cmdText"></param>
 /// <param name="commandType"></param>
 /// <returns></returns>
 public static object ExecuteScalar(this SQLiteConnection conn, string cmdText, CommandType commandType)
 {
     conn.CheckNull(nameof(conn));
     return(conn.ExecuteScalar(cmdText, null, commandType, null));
 }

Example #30

 /// <summary>
 /// Execute Entities
 /// </summary>
 /// <param name="conn"></param>
 /// <param name="cmdText"></param>
 /// <param name="commandType"></param>
 /// <typeparam name="T"></typeparam>
 /// <returns></returns>
 public static IEnumerable <T> ExecuteEntities <T>(this SQLiteConnection conn, string cmdText, CommandType commandType) where T : new()
 {
     conn.CheckNull(nameof(conn));
     return(conn.ExecuteEntities <T>(cmdText, null, commandType, null));
 }