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