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