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