-
I have a query that is erroring on a column named "Group". How could I go about fixing it? I can't change the design of the table. invoices = new DataTable (); invoices = new SubSonic. Select ( Aggregate .GroupBy( Claim .InvNumberColumn.ColumnName, "Invoice Num" ) , Aggregate...
-
I'm using SqlQuery and the below syntax (field and table names changed) Table with 4 columns: myGuidField, myDateField, myNumberField, myStringField SqlQuery qry = new Select( Aggregate.Avg(myTable.Columns.myNumberField), Aggregate.GroupBy(myTable.Columns.myStringField)) .From(myTable.Schema) .Where...
-
Okay, I think that I've figured it out. SubSonic.SqlQuery qry = new SubSonic.Select( SubSonic.Aggregate.GroupBy(myTable.Columns.Item), SubSonic.Aggregate.Count(myTable.Columns.Item, "Total")). From(myTable.Schema); myGridView.DataSource = qry.ExecuteReader(); I also figured out how to add...