public void UpdateQuery()
{
// Arrange
int ElementsCountBeforeAct = queriesDbSet.Count();
int queryIdBeforeAct = queriesDbSet.First().SqlQueryId;
string queryNameBeforeAct = queriesDbSet.First().SqlQueryName;
string queryContentBeforeAct = queriesDbSet.First().SqlQueryContent;
string newQueryName = "Updated query name";
string newQueryContent = "one word select";
SqlQuery queryToUpdate = queriesDbSet.First();
queryToUpdate.SqlQueryName = newQueryName;
queryToUpdate.SqlQueryContent = newQueryContent;
// Act
queryRepo.Update(queryToUpdate);
SqlQuery updatedQuery = queriesDbSet.First();
// Assert
Assert.AreEqual(newQueryName, updatedQuery.SqlQueryName);
Assert.AreEqual(newQueryContent, updatedQuery.SqlQueryContent);
Assert.AreNotEqual(queryNameBeforeAct, updatedQuery.SqlQueryName);
Assert.AreNotEqual(queryContentBeforeAct, updatedQuery.SqlQueryContent);
Assert.AreEqual(queryIdBeforeAct, updatedQuery.SqlQueryId);
Assert.AreEqual(ElementsCountBeforeAct, queriesDbSet.Count());
}
public void Update(Query query)
{
_queryRepository.Update(query);
}
