C# (CSharp) SmartWay.Orm.Sql.Queries Aggregable Examples

Example #1

File: Aggregable.cs Project: sGeeK44/Orm

        public static Aggregable CreateSum(params ColumnValue[] columns)
        {
            var result = new Aggregable();

            result._aggregableFunction = columns.Select(_ => _.ToSumColumn()).ToArray();
            result._columns            = new ColumnValue[0];
            return(result);
        }

Example #2

        public int Count()
        {
            var countedEntity = Query.Entity;
            var columnValue   = Datastore.ToColumnValue(countedEntity, countedEntity.PrimaryKey.FieldName);

            SelectStatement = Aggregable.CreateColumnCount(columnValue);
            return(Datastore.ExecuteScalar(this));
        }

Example #3

 public IEnumerable <AggregableResultRow> Sum(params ColumnValue[] columns)
 {
     SelectStatement = Aggregable.CreateSum(columns);
     return(Datastore.ExecuteQuery(this));
 }