Account.DAL.YearlyDAL.GetYearlys C# (CSharp) Метод

        public IEnumerable<Yearly> GetYearlys(string start, string end)
        {
            string sql = @"SELECT NEWID() ID, DATENAME(YEAR, DATE) YEAR, SUM(COST) COST
                           FROM DAILY
                           WHERE DATENAME(YEAR, DATE) BETWEEN @START AND @END
                           GROUP BY DATENAME(YEAR, DATE)
                           ORDER BY DATENAME(YEAR, DATE) ASC";
            Dictionary<string, object> parameters = new Dictionary<string, object>()
            {
                {"START", start },
                { "END", end}
            };

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