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