/// <summary>
/// データ追加クエリ (コマンドパラメータ無し)
/// </summary>
public void TestNonExcuteQuery()
{
using (IDBManeger db = unitOfWark.DBManeger)
{
db.ExecuteNonQuery("Insert into Test1Table values(3,'test')");
}
}
/// <summary>
/// データ追加クエリ (コマンドパラメータあり)
/// </summary>
public void TestNonExcuteQuery2()
{
using (IDBManeger db = unitOfWark.DBManeger)
{
var param = new Dictionary <string, object>();
param.Add("@Id", 4);
db.ExecuteNonQuery("Insert into Test1Table values(@Id,'test')", param);
}
}
/// <summary>
/// データ追加クエリ (コマンドパラメータあり)
/// </summary>
public void TestNonExcuteQuery3()
{
using (IDBManeger db = unitOfWark.DBManeger)
{
var model = new TestModel()
{
Id = 1, Name = "test"
};
db.ExecuteNonQuery("Insert into Test1Table values(@Id,@Name)", model);
}
}
