Subsonic Aggregation Constraint (“Having”)

subsonic

I want to no if there any way to add an "Having" constrain to an aggregation select?
Example: if i need all sales sum by date having the sales sum > 1000.

Best Regards,
TheGodfather

Best Answer

SubSonic does have a "having" but you don't explicitly state it.

It is determined from you selecting an Aggregate and adding the Aggregate to the Where clause.

For example (paraphrased from SubSonic AggregateTests.cs)

        SubSonic.SqlQuery q = new
            Select(Aggregate.GroupBy("ProductID"), Aggregate.Avg("UnitPrice"))
            .From("Order Details")
            .Where(Aggregate.Avg("UnitPrice"))
            .IsGreaterThan(50);

The SubSonic query above will create a SQL statement with a "HAVING AVG(UnitPrice) > 50"

Related Solutions

SubSonic: What if something changes

I believe you use a command-line app to generate your mapping files, so that command-line app would have to be re-run for that to happen. Second, the mapping code would have to be compiled on the fly after insert...most .net application do not do this.

But the biggest reason you would not want the mappings to be generated on the fly: speed. It takes time to do that, several seconds at least. Then how would you time it? Not every call -- that would be insane. Once a day? when during the day?

So no, SubSonic only generates the mapping files when you ask it to. If you change the database you risk breaking your application.

Rename fields in SubSonic select statement

I believe Alias's are only available for aggregate columns. You could just add properties of the same names as your columns to your class or a partial and map them to the properties you do use ala calculated field:

public class Songs

{

private string _songTitle;
public string SongTitle {
    get { return _songTitle; }
    set { _songTitle = value; }
}

public string SongName {
    get { return _songTitle; }
    set { _songTitle = value; }
}

}

Best Answer

Related Solutions

SubSonic: What if something changes

Rename fields in SubSonic select statement

Related Topic