-
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 just like to know if can create this sql i subsonic SELECT Id, Title, Body, Slug, CreatedOn FROM Posts WHERE (DATEPART(Month, CreatedOn) = 9) AND (DATEPART(Year, CreatedOn) = 2008) ORDER BY CreatedOn DESC