public void TestInsert()
{
//Arrange
var commandMock = new Mock <IDbCommand>();
commandMock
.Setup(m => m.ExecuteNonQuery())
.Verifiable();
var connectionMock = new Mock <IDbConnection>();
connectionMock
.Setup(m => m.CreateCommand())
.Returns(commandMock.Object);
var connectionFactoryMock = new Mock <IDbConnectionFactory>();
connectionFactoryMock
.Setup(m => m.CreateConnection())
.Returns(connectionMock.Object);
var sut = new MyDataAccessClass(connectionFactoryMock.Object);
var firstName = "John";
var lastName = "Doe";
//Act
sut.Insert(firstName, lastName);
//Assert
commandMock.Verify();
}
public void TestInsert()
{
//Arrange
var commandMock = new Mock <IDbCommand>();
commandMock
.Setup(m => m.ExecuteNonQuery())
.Verifiable();
var connectionMock = new Mock <IDbConnection>();
connectionMock
.Setup(m => m.CreateCommand())
.Returns(commandMock.Object);
var connectionFactoryMock = new Mock <IDbConnectionFactory>();
connectionFactoryMock
.Setup(m => m.CreateConnection())
.Returns(connectionMock.Object);
var sut = new MyDataAccessClass(connectionFactoryMock.Object);
var name = "Apple Pie";
var numServe = 8;
var category = "dessert";
var prepTime = 50;
var ingredient = "apple, butter, flour";
var methods = "Not available";
//Act
sut.Insert(name, numServe, category, prepTime, ingredient, methods);
//Assert
commandMock.Verify();
}
public void TestRunStoredProc()
{
//Arrange
var connectionFactory = new Mock <IDbConnectionFactory>();
//..Setup...
var sut = new MyDataAccessClass(connectionFactory.Object);
//Act
var actual = sut.RunStoredProc();
//Assert
//...
}
public void TestFilter()
{
//Arrange
var readerMock = new Mock <IDataReader>();
var commandMock = new Mock <IDbCommand>();
commandMock.Setup(m => m.ExecuteReader())
.Returns(readerMock.Object)
.Verifiable();
var parameterMock = new Mock <IDbDataParameter>();
commandMock.Setup(m => m.CreateParameter())
.Returns(parameterMock.Object);
commandMock.Setup(m => m.Parameters.Add(It.IsAny <IDbDataParameter>()))
.Verifiable();
var connectionMock = new Mock <IDbConnection>();
connectionMock
.Setup(m => m.CreateCommand())
.Returns(commandMock.Object);
var connectionFactoryMock = new Mock <IDbConnectionFactory>();
connectionFactoryMock
.Setup(m => m.CreateConnection())
.Returns(connectionMock.Object);
var sut = new MyDataAccessClass(connectionFactoryMock.Object);
var input = "some value";
//Act
var data = sut.GetData(input);
//Assert
commandMock.Verify();
}
