Account.DAL.MonthlyDAL.GetMonthlys C# (CSharp) Метод

        public IEnumerable<Monthly> GetMonthlys(string start, string end)
        {
            string sql = @"SELECT NEWID() ID, DATENAME(YEAR, DATE) + '-' + DATENAME(MONTH, DATE) MONTH, SUM(COST) COST
                           FROM DAILY
                           WHERE DATENAME(YEAR, DATE) + '-' + DATENAME(MONTH, DATE) BETWEEN @START AND @END
                           GROUP BY DATENAME(YEAR, DATE) + '-' + DATENAME(MONTH, DATE)
                           ORDER BY DATENAME(YEAR, DATE) + '-' + DATENAME(MONTH, DATE) ASC";
            Dictionary<string, object> parameters = new Dictionary<string, object>();
            parameters.Add("START", start);
            parameters.Add("END", end);

            return _database.GetList<Monthly>(sql, parameters);
        }