/// <summary> /// 更新実行 /// </summary> /// <param name="id"></param> /// <param name="name"></param> /// <param name="job"></param> public virtual void Update(string id, string name, string job) { // トランザクション処理単品で実行(戻り値なし) var parameters = new Dictionary <string, object>(); parameters["Id"] = id; parameters["Name"] = name; parameters["Job"] = job; Tx.Execute(tx => tx.Update(SQL_UPDATE, parameters)); }
/// <summary> /// 挿入実行 /// </summary> /// <param name="name"></param> /// <param name="job"></param> public virtual void Insert(string name, string job) { var parameters = new Dictionary <string, object>(); parameters["Name"] = name; parameters["Job"] = job; // 他のDecoratorを適用しつつトランザクション処理実行1 QScope <LogDecorator> .Execute(() => { Tx.Execute(tx => tx.Update(SQL_INSERT, parameters)); }); }
public void ExecuteTest() { // Arrange QM.ComponentCreator = CreateComponentCreator(); var sql = "SELECT Name FROM Hoge WHERE ID=/* id */123"; var parameters = new Dictionary <string, object>(); parameters["name"] = "test"; parameters["id"] = 256; var scopeArgs = new Dictionary <string, object>(); scopeArgs[QuillKey.DATA_SOURCE_NAME] = "HogeSource"; // Act var actual = Tx.Execute(tx => tx.Select <TestEntity>(sql, parameters), scopeArgs); // Assert Assert.IsNotNull(actual); }
/// <summary> /// 検索実行 /// </summary> /// <returns></returns> public virtual List <Employ> Select() { // トランザクション処理単品で実行(戻り値あり) return(Tx.Execute(tx => tx.Select <Employ>(SQL_SELECT))); }