score:3

Accepted answer
// given trend data has a single measurement referencing a single site.
var gaugedata = db.trend_data
    .where(x => x.trend_data_time >= sdate 
        && x.trend_data_time <= edate
        && x.measurement.site.site_name == insite))
    .select(x => new 
    {
        x.measurement.site.site_name,
        x.trend_data_time,
        x.trend_data_avg
    }).tolist()
    .select( x=> new gaugedata
    {
        siteid = site_name, 
        data_time = trend_data_time, 
        trend_data = convert.tosingle(trend_data_avg) 
    }).tolist();

score:0

trend_data = convert.tosingle(rainfall.trend_data_avg)

Related Query

More Query from same tag