/// <summary>
/// 取得クエリテスト (DBスネークケースでモデルがパスカルの場合)
/// </summary>
/// <returns></returns>
public void TestExcuteQuery7()
{
using (IDBManeger db = unitOfWark.DBManeger)
{
var result = db.ExecuteQuery <TestSnakeCaseModel>("select * from Test2SnakeCase");
}
}
/// <summary>
/// 取得クエリテスト (コマンドパラメータあり)
/// </summary>
/// <returns></returns>
public void TestExcuteQuery4()
{
using (IDBManeger db = unitOfWark.DBManeger)
{
var result = db.ExecuteQuery <TestModel>("select * from Test1Table");
}
}
/// <summary>
/// 取得クエリテスト (基本)
/// </summary>
/// <returns></returns>
public void TestExcuteQuery()
{
using (IDBManeger db = unitOfWark.DBManeger)
{
var result = new DataTable();
db.ExecuteQuery(result, "select * from Test1Table");
}
}
/// <summary>
/// 取得クエリテスト (コマンドパラメータあり)
/// </summary>
/// <returns></returns>
public void TestExcuteQuery5()
{
using (IDBManeger db = unitOfWark.DBManeger)
{
var param = new Dictionary <string, object>();
param.Add("@Id", 1);
var result = db.ExecuteQuery <TestModel>("select * from Test1Table where id = @Id", param);
}
}
/// <summary>
/// 取得クエリテスト (コマンドパラメータあり (辞書型))
/// </summary>
/// <returns></returns>
public void TestExcuteQuery2()
{
using (IDBManeger db = unitOfWark.DBManeger)
{
var param = new Dictionary <string, object>();
param.Add("@Id", 2);
var result = new DataTable();
db.ExecuteQuery(result, "select * from Test1Table where Id = @Id", param);
}
}
/// <summary>
/// 取得クエリテスト (コマンドパラメータあり)
/// </summary>
/// <returns></returns>
public void TestExcuteQuery6()
{
using (IDBManeger db = unitOfWark.DBManeger)
{
var model = new TestModel()
{
Id = 1, Name = "test"
};
var result = db.ExecuteQuery <TestModel>("select * from Test1Table where id = @Id", model);
}
}
/// <summary>
/// 取得クエリテスト (コマンドパラメータあり (モデル))
/// </summary>
/// <returns></returns>
public void TestExcuteQuery3()
{
using (IDBManeger db = unitOfWark.DBManeger)
{
var model = new TestModel()
{
Id = 1, Name = "test"
};
var result = new DataTable();
db.ExecuteQuery(result, "select * from Test1Table where Id = @Id", model);
}
}