public override void InsertAsync(TestScenario entity) { var sql = @"INSERT OR REPLACE INTO TFS_TestScenario AS TestScenario (TestScenarioId, ContractRequirementId, ScenarioDescription, ScenarioName, ApplicationArea, ApplicationProcess) VALUES (@TestScenarioId, @ContractRequirementId, @ScenarioDescription, @ScenarioName, @ApplicationArea, @ApplicationProcess)"; using (var conn = GetOpenConnection()) { try { conn.ExecuteAsync(sql, entity); if (entity.TestCases != null) { foreach (TestCase testCase in entity.TestCases) { TestScenarioTestCaseMap currMap = new TestScenarioTestCaseMap { TestCaseId = testCase.TestCaseId, TestScenarioId = entity.TestScenarioId }; InsertTestScenarioTestCaseMap(currMap); } } } catch { throw new Exception(); } } }
private void InsertTestScenarioTestCaseMap(TestScenarioTestCaseMap testScenarioTestCaseMap) { var sql = @"INSERT OR REPLACE INTO MP_TestScenarioTestCaseMap AS TestScenarioTestCaseMap (TestScenarioTestCaseId, TestScenarioId, TestCaseId) VALUES (@TestScenarioTestCaseId, @TestScenarioId, @TestCaseId)"; using (var conn = GetOpenConnection()) { conn.Execute(sql, testScenarioTestCaseMap); } }