public List<Daily> GetDailys(DateTime start, DateTime end)
{
List<Daily> result = null;
DataTable dt = new DataTable();
string sql = @"SELECT D.* FROM DAILY D WHERE D.DATE BETWEEN @START AND @END ORDER BY D.DATE ASC";
using (DbCommand cmd = _database.GetSqlStringCommand(sql))
{
_database.AddInParameter(cmd, "@START", DbType.Date, start);
_database.AddInParameter(cmd, "@END", DbType.Date, end);
using (IDataReader reader = _database.ExecuteReader(cmd))
{
dt.Load(reader);
}
}
if (dt != null && dt.Rows.Count > 0)
{
result = dt.ToList<Daily>();
}
return result;
}