/// <summary>
/// データ登録
/// </summary>
/// <param name="query">SQL文字列</param>
/// <param name="args">パラメータ</param>
/// <returns>True:正常終了 / False:エラー</returns>
public static int Save(string query, params SQLiteParameter[] args)
{
using (var connector = new SqliteConnector())
using (var command = new SQLiteCommand(query, connector.Connection))
{
SqliteCommander.SetParameters(command, args);
connector.Open();
int result = 0;
using (var tran = new TransactionScope())
{
result = command.ExecuteNonQuery();
if (0 < result)
{
tran.Complete();
}
}
connector.Close();
return result;
}
}
/// <summary>
/// データ登録
/// </summary>
/// <param name="query">SQL文字列</param>
/// <param name="args">パラメータ</param>
/// <returns>True:正常終了 / False:エラー</returns>
public static int Save(string query, params SQLiteParameter[] args)
{
using (var connector = new SqliteConnector())
using (var command = new SQLiteCommand(query, connector.Connection))
{
SqliteCommander.SetParameters(command, args);
connector.Open();
int result = 0;
using (var tran = new TransactionScope())
{
result = command.ExecuteNonQuery();
if (0 < result)
{
tran.Complete();
}
}
connector.Close();
return(result);
}
}
/// <summary>
/// テーブル作成クエリ実行
/// </summary>
/// <param name="query">テーブル作成クエリ</param>
/// <returns>True:成功</returns>
/// <exception cref="System.Data.SQLite.SQLiteException">
/// クエリ実行に失敗した場合、例外をスローします。
/// </exception>
public static bool ExecuteCreateTable(string query)
{
try
{
using (var connector = new SqliteConnector())
using (var command = new SQLiteCommand(query, connector.Connection))
{
connector.Open();
using (var tran = new TransactionScope())
{
command.ExecuteNonQuery();
tran.Complete();
}
connector.Close();
}
return(true);
}
catch
{
throw new SQLiteException("テーブル作成に失敗しました。");
}
}
/// <summary>
/// 単一行取得
/// </summary>
/// <param name="query">SQL文字列</param>
/// <param name="args">パラメータ</param>
/// <returns>件数</returns>
public static int Scalor(string query, params SQLiteParameter[] args)
{
using (var connector = new SqliteConnector())
using (var command = new SQLiteCommand(query, connector.Connection))
{
SqliteCommander.SetParameters(command, args);
connector.Open();
int count = (int)command.ExecuteScalar();
connector.Close();
return(count);
}
}
public static DataTable Select(string query, params SQLiteParameter[] args)
{
using (var connector = new SqliteConnector())
using (var command = new SQLiteCommand(query, connector.Connection))
{
SqliteCommander.SetParameters(command, args);
using (var adapt = new SQLiteDataAdapter(command))
{
var table = new DataTable();
adapt.Fill(table);
return table;
}
}
}
public static DataTable Select(string query, params SQLiteParameter[] args)
{
using (var connector = new SqliteConnector())
using (var command = new SQLiteCommand(query, connector.Connection))
{
SqliteCommander.SetParameters(command, args);
using (var adapt = new SQLiteDataAdapter(command))
{
var table = new DataTable();
adapt.Fill(table);
return(table);
}
}
}
/// <summary>
/// テーブル作成クエリ実行
/// </summary>
/// <param name="query">テーブル作成クエリ</param>
/// <returns>True:成功</returns>
/// <exception cref="System.Data.SQLite.SQLiteException">
/// クエリ実行に失敗した場合、例外をスローします。
/// </exception>
public static bool ExecuteCreateTable(string query)
{
try
{
using (var connector = new SqliteConnector())
using (var command = new SQLiteCommand(query, connector.Connection))
{
connector.Open();
using (var tran = new TransactionScope())
{
command.ExecuteNonQuery();
tran.Complete();
}
connector.Close();
}
return true;
}
catch
{
throw new SQLiteException("テーブル作成に失敗しました。");
}
}
/// <summary>
/// 単一行取得
/// </summary>
/// <param name="query">SQL文字列</param>
/// <param name="args">パラメータ</param>
/// <returns>件数</returns>
public static int Scalor(string query, params SQLiteParameter[] args)
{
using (var connector = new SqliteConnector())
using (var command = new SQLiteCommand(query, connector.Connection))
{
SqliteCommander.SetParameters(command, args);
connector.Open();
int count = (int)command.ExecuteScalar();
connector.Close();
return count;
}
}