public static void CheckResultRecordExists(String sTestName, String sStatus) { try { using (SQLCompactDBEntities entity = new SQLCompactDBEntities()) { string runName = conf.get("RunName"); var recordCount = entity.Test_Results.Count(a => a.Test_Name.Equals(sTestName) && a.Run_Name.Equals(runName) && a.Execution_Date.Equals(DateTime.Today) && a.Test_Result.Equals(sStatus)); if (recordCount != 0) { entity.Test_Results.SqlQuery("delete from Test_Results where TEST_NAME like '" + sTestName + "' and EXECUTION_DATE like " + DateTime.Today + " and TEST_RESULT like '" + sStatus + "' and RUN_Name like '" + conf.get("RunName") + "'"); DbSqlQuery<Test_Results> db = entity.Test_Results.SqlQuery("delete from Test_Results where TEST_NAME like '" + sTestName + "' and TEST_RESULT like '" + sStatus + "' and RUN_Name like '" + conf.get("RunName") + "'"); foreach (Test_Results check in db) { } IEnumerator<Test_Results> enu = db.GetEnumerator(); var c = enu.Current; } } } catch (Exception e) { Console.WriteLine(e.Message); } }
public static void UpdateResult(String query) { try { using (SQLCompactDBEntities entity = new SQLCompactDBEntities()) { DbSqlQuery<Test_Results> db = entity.Test_Results.SqlQuery(query); foreach (Test_Results check in db) { } IEnumerator<Test_Results> enu = db.GetEnumerator(); var c = enu.Current; } } catch (Exception e) { Console.WriteLine(e.Message); } }
public static void UpdateRecord(String query) { try { using (SQLCompactDBEntities entity = new SQLCompactDBEntities()) { DbSqlQuery<Siebel_TestData> db = entity.Siebel_TestData.SqlQuery(query); foreach (Siebel_TestData check in db) { } IEnumerator<Siebel_TestData> enu = db.GetEnumerator(); var c = enu.Current; } } catch (Exception e) { Console.WriteLine(e.Message); } }