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