C# (CSharp) DistinctModifier Examples

Example #1

        public void RenderAggregateFunctionWidthDistinctModifier()
        {
            Column            column            = new Column("Column1");
            DistinctModifier  distinctModifier  = new DistinctModifier();
            AggregateFunction aggregateFunction = new AggregateFunction(FunctionType.Count, distinctModifier, column);

            Assert.AreEqual("COUNT(DISTINCT [Column1])", sqlClientRenderer.Render(aggregateFunction));
        }

Example #2

        public void CreateAggregateFunctionWithDistinctModifier()
        {
            Column            column            = new Column("Column1");
            DistinctModifier  distinctModifier  = new DistinctModifier();
            AggregateFunction aggregateFunction = new AggregateFunction(FunctionType.Count, distinctModifier, column);

            Assert.AreEqual(FunctionType.Count, aggregateFunction.FunctionType);
            Assert.AreEqual(distinctModifier, aggregateFunction.DistinctModifier);
            Assert.AreEqual(column, aggregateFunction.Expression);
        }

Example #3

File: SqlUnion.cs Project: vanloc0301/mychongchong

 public void Add(SelectQuery query, DistinctModifier repeatingAction)
 {
     this.items.Add(new SqlUnionItem(query, repeatingAction));
 }

Example #4

 /// <summary>
 /// Adds a query to the UNION clause with the specified DistinctModifier
 /// </summary>
 /// <param name="query">SelectQuery to be added</param>
 /// <param name="repeatingAction">Distinct modifier</param>
 public void Add(SelectQuery query, DistinctModifier repeatingAction)
 {
     items.Add(new SqlUnionItem(query, repeatingAction));
 }

Example #5

File: SqlUnionItem.cs Project: shumtn/skynet-cloud

 public SqlUnionItem(SelectQuery query, DistinctModifier repeatingAction)
 {
     Query           = query;
     RepeatingAction = repeatingAction;
 }

Example #6

 public AggregateFunction(FunctionType functionType, DistinctModifier distinctModifier, IQueryValueExpression expression) : base(expression)
 {
     FunctionType     = functionType;
     DistinctModifier = distinctModifier;
 }

Example #7

 public override string Render(DistinctModifier distinctModifier)
 {
     return("DISTINCT");
 }

Example #8

File: BaseRenderer.cs Project: aleripe/QueryBuilder

 public abstract string Render(DistinctModifier distinctModifier);

Example #9

File: SqlUnionItem.cs Project: vanloc0301/mychongchong

 public SqlUnionItem(SelectQuery query, DistinctModifier repeatingAction)
 {
     this.Query = query;
     this.RepeatingAction = repeatingAction;
 }

Example #10

File: ModifierTests.cs Project: aleripe/QueryBuilder

        public void RenderDistinctModifier()
        {
            DistinctModifier distinctModifier = new DistinctModifier();

            Assert.AreEqual("DISTINCT", sqlClientRenderer.Render(distinctModifier));
        }