public SkipperDataSet.SensorReadingsDataTable GetSensorReadings(DateTime?start, DateTime?end) { SkipperDataSet.SensorReadingsDataTable dt = new SkipperDataSet.SensorReadingsDataTable(); List <SensorFile> files = new List <SensorFile>(); var query = from r in Persistance.Data.BoatFile.AsEnumerable() join f in Persistance.Data.SensorReadings.AsEnumerable() on r.sensorfile_id equals f.sensorfile_id where r.boat_id == _id && (start == null || f.datetime >= start) && (end == null || f.datetime <= end) orderby f.datetime ascending select f; foreach (SkipperDataSet.SensorReadingsRow r in query) { dt.ImportRow(r); } return(dt); }
public SkipperDataSet.SensorReadingsDataTable GetSensorReadings(DateTime? start,DateTime? end) { SkipperDataSet.SensorReadingsDataTable dt = new SkipperDataSet.SensorReadingsDataTable(); List<SensorFile> files = new List<SensorFile>(); var query = from r in Persistance.Data.BoatFile.AsEnumerable() join f in Persistance.Data.SensorReadings.AsEnumerable() on r.sensorfile_id equals f.sensorfile_id where r.boat_id == _id && (start==null || f.datetime >=start) && (end == null || f.datetime <= end) orderby f.datetime ascending select f; foreach (SkipperDataSet.SensorReadingsRow r in query) { dt.ImportRow(r); } return dt; }