コード例 #1
0
        public void ExecuteShouldExecuteSuccessfullyWithFilter()
        {
            // Arrange
            const string expectedSql = "SELECT [Articles].[Id] FROM [Articles] WHERE (([Articles].[Id] = @Id_0))";
            var          filter      = new ArticleFilter {
                ArticleId = 1
            };

            var dataReaderMock = CreateDataReaderMock();

            var parameters     = new List <IDbDataParameter>();
            var parametersMock = new Mock <IDataParameterCollection>(MockBehavior.Strict);

            parametersMock.Setup(p => p.Contains("Id_0")).Returns(() => parameters.Count == 1);
            parametersMock.Setup(p => p.Add(It.IsAny <IDbDataParameter>())).Returns((object p) => { parameters.Add((IDbDataParameter)p); return(parameters.Count - 1); });
            parametersMock.SetupGet(p => p.Count).Returns(() => parameters.Count);
            parametersMock.Setup(p => p.GetEnumerator()).Returns(() => parameters.GetEnumerator());

            var commandMock = CreateCommandMock(dataReaderMock, expectedSql, parametersMock);

            var connectionMock = CreateConnectionMock(commandMock);

            var selectQuery = _queryBuilder.Select <Article>(a => a.Id);

            // Act
            selectQuery.Execute(filter, connectionMock.Object);

            // Assert
            commandMock.VerifySet(c => c.CommandText = expectedSql, Times.Once);
            commandMock.Verify(c => c.CreateParameter(), Times.Once);
            parametersMock.Verify(p => p.Add(It.IsAny <IDbDataParameter>()), Times.Once);
        }
コード例 #2
0
        public void GetQueryShouldGetQueryWithFilter()
        {
            // Arrange
            var filter = new ArticleFilter {
                ArticleId = 1
            };

            // Act
            var selectQuery = _queryBuilder.Select <Article>(a => a.Id);
            var query       = selectQuery.GetQuery(filter);

            // Assert
            query.Text.Should().Be("SELECT [Articles].[Id] FROM [Articles] WHERE (([Articles].[Id] = @Id_0))");
            query.Parameters.Should().HaveCount(1);
        }
コード例 #3
0
        public void GetQueryShouldGetQueryWithJoinAndFilter()
        {
            // Arrange
            var filter = new ArticleFilter {
                ArticleId = 1
            };

            // Act
            var selectQuery = _queryBuilder
                              .Select <Article>(a => a.Id)
                              .Join <ArticleType>(at => at.Name);
            var query = selectQuery.GetQuery(filter);

            // Assert
            query.Text.Should().Be("SELECT [Articles].[Id], [ArticleTypes].[Name] AS [ArticleTypeName] FROM [Articles] INNER JOIN [ArticleTypes] ON [Articles].[ArticleTypeId] = [ArticleTypes].[Id] WHERE (([Articles].[Id] = @Id_0))");
            query.Parameters.Should().HaveCount(1);
        }