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