Esempi in C# (CSharp) per SqlQueryBuilder.Query

Esempio n. 1

File: SqlQueryBuilder_Query.cs Progetto: nikhilsarvaiye/DotnetStandardQueryBuilder

        public void Query_IsValidSimpleFilterQuery_ReturnsSqlQuery()
        {
            var sqlQueryBuilder = new SqlQueryBuilder(SampleRequest.Full, "Test");

            var sqlQuery = sqlQueryBuilder.Query();

            var sqlCountQuery = sqlQueryBuilder.QueryCount();

            sqlQueryBuilder = new SqlQueryBuilder(SampleRequest.SimpleIn, "Test");

            sqlQuery = sqlQueryBuilder.Query();

            sqlCountQuery = sqlQueryBuilder.QueryCount();

            sqlQueryBuilder = new SqlQueryBuilder(SampleRequest.SimpleAnd, "Test");

            sqlQuery = sqlQueryBuilder.Query();

            sqlCountQuery = sqlQueryBuilder.QueryCount();

            sqlQueryBuilder = new SqlQueryBuilder(SampleRequest.SimpleOr, "Test");

            sqlQuery = sqlQueryBuilder.Query();

            sqlCountQuery = sqlQueryBuilder.QueryCount();

            sqlQueryBuilder = new SqlQueryBuilder(SampleRequest.SimpleCompositeAndOr, "Test");

            sqlQuery = sqlQueryBuilder.Query();

            sqlCountQuery = sqlQueryBuilder.QueryCount();

            sqlQueryBuilder = new SqlQueryBuilder(SampleRequest.SimpleContainsStartsWith, "Test");

            sqlQuery = sqlQueryBuilder.Query();

            sqlCountQuery = sqlQueryBuilder.QueryCount();

            sqlQueryBuilder = new SqlQueryBuilder(SampleRequest.SimpleSort, "Test");

            sqlQuery = sqlQueryBuilder.Query();

            sqlCountQuery = sqlQueryBuilder.QueryCount();

            Assert.AreEqual(3, 3);
        }