-
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
-
Guys, how can I do a select statement in subsonic like this: select OneTable.ID as [ID One], OneTable.Name as [Name One], TwoTable.ID as [ID Two], TwoTable.Name as [Name Two] from OneTable inner join TwoTable on OneTable.ID = TwoTable.OneTableID I tried this: using (IDataReader rdr = DB.Select("OneTable...
-
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...