public int DeleteAll() { using (var context = new TreeMonDbContext(_dbConnectionKey)) { string table = context.GetTableName <LogEntry>(); return(context.ExecuteNonQuery("DELETE FROM " + table, null)); } }
public void TreeMonDbContext_Context_ExecuteNonQuery_MSSQL() { TreeMonDbContext context = new TreeMonDbContext("MSSQL_TEST"); _user = context.GetAll <User>().FirstOrDefault(); DynamicParameters parameters = new DynamicParameters();//dapper parameters.Add("@PROVIDER", "UPDATED_PROVIDER"); parameters.Add("@UUID", _user.UUID); // List<SqlParameter> parameters = new List<SqlParameter>(); // parameters.Add(new SqlParameter("@PROVIDER", "UPDATED_PROVIDER")); // parameters.Add(new SqlParameter("@UUID", _user.UUID)); int res = context.ExecuteNonQuery("UPDATE USERS SET ProviderName=@PROVIDER WHERE UUID=@UUID", parameters); Assert.AreEqual(res, 1); Assert.AreEqual(context.Get <User>(_user.Id).ProviderName, "UPDATED_PROVIDER"); }