Esempio n. 1
0
        public void SqlClauseBuilderTest()
        {
            var selectBuilder = new SqlSelectClauseBuilder(this._tableName, SelectClauseBuildMode.StringWithAlias);
            foreach (var field in this._fields)
                selectBuilder.AddField(field.Item1, field.Item2);

            var whereBuilder = new SqlWhereClauseBuilder();
            this._operators.ForEach(o =>
            {
                whereBuilder.AddParameterValue(o.Item1, o.Item2, o.Item3);
            });

            var sqlResult = selectBuilder.ToString() + whereBuilder.ToString();
            Assert.IsNull(sqlResult, sqlResult);
        }
Esempio n. 2
0
        public void SqlSelectClauseBuilderTest()
        {
            var selectBuilder = new SqlSelectClauseBuilder(this._tableName, SelectClauseBuildMode.StringWithAlias);
            foreach (var field in this._fields)
                selectBuilder.AddField(field.Item1, field.Item2);

            var selectResult = selectBuilder.ToString();
            Assert.IsTrue(String.IsNullOrWhiteSpace(selectResult), selectResult);
        }