Ejemplo n.º 1
0
        public override ISelectStatement <TEntity> CountAll()
        {
            var columns = Specification.Columns;
            var columnSpecification1 = new ColumnSpecification();

            columnSpecification1.Identifier  = "*";
            columnSpecification1.Aggregation = Aggregation.Count;
            columnSpecification1.EntityType  = typeof(TEntity);
            var columnSpecification2 = columnSpecification1;

            columns.Add(columnSpecification2);
            return(this);
        }
Ejemplo n.º 2
0
        protected override void AddJoinsColumnSelection <T>(string name, string alias = null)
        {
            var joinsColumns         = Specification.JoinsColumns;
            var columnSpecification1 = new ColumnSpecification();

            columnSpecification1.Aggregation = Aggregation.None;
            columnSpecification1.Alias       = alias;
            columnSpecification1.EntityType  = typeof(T);
            columnSpecification1.Identifier  = name;
            columnSpecification1.ColumnName  = GetColumnAlias <TEntity>(name);
            var columnSpecification2 = columnSpecification1;

            joinsColumns.Add(columnSpecification2);
        }
Ejemplo n.º 3
0
        protected override void AddColumnSelection <T>(
            string name,
            string showname         = "",
            string alias            = null,
            Aggregation aggregation = Aggregation.None)
        {
            var columns = Specification.Columns;
            var columnSpecification1 = new ColumnSpecification();

            columnSpecification1.Aggregation           = aggregation;
            columnSpecification1.Alias                 = alias;
            columnSpecification1.EntityType            = typeof(T);
            columnSpecification1.Identifier            = name;
            columnSpecification1.ColumnName            = GetColumnAlias <TEntity>(name);
            columnSpecification1.AggregationColumnName = showname == "" ? name : showname;
            var columnSpecification2 = columnSpecification1;

            columns.Add(columnSpecification2);
        }