public void When_Update_Is_Called_After_Inserting_InValid_Data_It_Should_Throw_Exception(string newName,
string newAddress, string updatedName, string updatedAddress)
{
var userDbOperation = new UserDbOperations();
var user = new User()
{
Name = newName, Address = newAddress
};
var id = userDbOperation.Create(user);
user.Name = updatedName;
user.Address = updatedAddress;
user.Id = id;
Assert.Throws <SqlException>(() => userDbOperation.Update(user));
}
public void When_Update_Is_Called_After_Setting_Data_Having_Exceeded_Length_It_Should_Throw_A_SqlException(string newName,
string newAddress, string updatedName, string updatedAddress)
{
var userDbOperation = new UserDbOperations();
var user = new User()
{
Name = newName, Address = newAddress
};
var id = userDbOperation.Create(user);
user.Name = updatedName;
user.Address = updatedAddress;
user.Id = id;
Assert.Throws <SqlException>(() => userDbOperation.Update(user));
using (var conn = new SqlConnection(UserDbOperations.ConnectionString))
{
conn.Execute($"DELETE FROM Users WHERE Id={id}");
}
}
public void When_Update_Is_Called_After_Inserting_Valid_Data_It_Should_Update()
{
var userDbOperation = new UserDbOperations();
var user = new User()
{
Name = "Rakesh", Address = "Bangalore"
};
var id = userDbOperation.Create(user);
user.Name = "Vijaya";
user.Address = "Mumbai";
user.Id = id;
userDbOperation.Update(user);
using (var conn = new SqlConnection(UserDbOperations.ConnectionString))
{
var createdUser = conn.Query <User>($"SELECT * FROM Users WHERE Id={id}").FirstOrDefault();
Assert.AreEqual(createdUser.Name, user.Name);
Assert.AreEqual(createdUser.Address, user.Address);
}
}
