public async Task IncorrectParameterType() { var connectionFactory = new Mock <IDbConnectionFactory>(); var connection = new MockDbConnection(); var repository = new SampleRepository(connectionFactory.Object); connectionFactory .Setup(f => f.OpenConnection()) .Returns(connection); await repository.GetCarAsync("reg"); try { connection.Verify(c => c.QuerySingleAsync <Car>(@"select * from [Cars] where Registration = @registration", new { registration = 1 }, It.IsAny <IDbTransaction>(), null, null)); } catch (MockException exc) { Assert.That(exc.Message.Trim(), Is.EqualTo(@"Expected invocation on the mock at least once, but was never performed: c => c.QuerySingleAsync<Car>(Match.Create<string>(Predicate<string>, () => ""select * from [Cars] where Registration = @registration""), Match.Create<object>(Predicate<object>, () => { registration = 1 }), It.IsAny<IDbTransaction>(), null, null) Performed invocations: Mock<MockDatabase:2> (c): MockDatabase.QuerySingleAsync<Car>(""select * from [Cars] where Registration = @registration"", { registration = reg }, null, null, null)").Using(_comparer)); } }
public async Task VerifyTwoDifferentGenericCallsWithSameSqlWhenSettingEnabled() { var settings = new Settings { ResetDapperCachePerCommand = true }; var connectionFactory = new Mock <IDbConnectionFactory>(); var connection = new MockDbConnection(settings); var repository = new SampleRepository(connectionFactory.Object); connectionFactory .Setup(f => f.OpenConnection()) .Returns(connection); await repository.GetCarAsync("reg"); await repository.GetCarCountAsync("reg"); connection.Verify(c => c.QuerySingleAsync <Car>(@"select * from [Cars] where Registration = @registration", It.IsAny <object>(), It.IsAny <IDbTransaction>(), null, null)); connection.Verify(c => c.QuerySingleAsync <int>(@"select * from [Cars] where Registration = @registration", It.IsAny <object>(), It.IsAny <IDbTransaction>(), null, null)); }
public async Task VerifyTwoDifferentGenericCallsWithSameSql() { var connectionFactory = new Mock <IDbConnectionFactory>(); var connection = new MockDbConnection(); var repository = new SampleRepository(connectionFactory.Object); connectionFactory .Setup(f => f.OpenConnection()) .Returns(connection); await repository.GetCarAsync("reg"); Assert.That( async() => await repository.GetCarCountAsync("reg"), Throws.InvalidOperationException.And.Message.EqualTo(@"Unable to detect the required response type for the command, it could be one of 2 possible options. Command: 'select * from [Cars] where Registration = @registration' Parameters: `registration = reg` CommandType: Text To be able to Verify the Dapper call accurately the Command and Parameters (and return type) must be unique for every invocation of a Dapper method. Possible options: `Dapper.MoqTests.Samples.Car`, `System.Int32` If this issue cannot be resolved, consider setting `Dapper.MoqTests.Settings.ResetDapperCachePerCommand` to `true`, note this is not a thread-safe approach").Using(_comparer)); connection.Verify(c => c.QuerySingleAsync <Car>(@"select * from [Cars] where Registration = @registration", It.IsAny <object>(), It.IsAny <IDbTransaction>(), null, null)); try { connection.Verify(c => c.QuerySingleAsync <int>(@"select * from [Cars] where Registration = @registration", It.IsAny <object>(), It.IsAny <IDbTransaction>(), null, null)); } catch (System.Exception exc) { Assert.That(exc.Message.Trim(), Is.EqualTo(@"Expected invocation on the mock at least once, but was never performed: c => c.QuerySingleAsync<int>(Match.Create<string>(Predicate<string>, () => ""select * from [Cars] where Registration = @registration""), It.IsAny<object>(), It.IsAny<IDbTransaction>(), null, null) Performed invocations: Mock<MockDatabase:6> (c): MockDatabase.QuerySingleAsync<Car>(""select * from [Cars] where Registration = @registration"", { registration = reg }, null, null, null)").Using(_comparer)); } }
public async Task VerifyQueryAsyncWithParameters() { var connectionFactory = new Mock <IDbConnectionFactory>(); var connection = new MockDbConnection(); var repository = new SampleRepository(connectionFactory.Object); connectionFactory .Setup(f => f.OpenConnection()) .Returns(connection); await repository.GetCarAsync("reg"); connection.Verify(c => c.QuerySingleAsync <Car>(@"select * from [Cars] where Registration = @registration", new { registration = "reg" }, It.IsAny <IDbTransaction>(), null, null)); }