C# (CSharp) UserTitleRate示例

示例#1

文件： RatingDataService.cs 项目： alihasan51214/ProjectPortfolio3_Group11

        public IList <TitleRateDto> CreateRating(UserTitleRate userTitleRate)
        {
            Raw11Context _db = new Raw11Context(_connectionString);

            var queery = _db.RatingTable.FromSqlInterpolated($"select * from rate({userTitleRate.UserId},{userTitleRate.TConst},{userTitleRate.TitleIndividRating})");

            _db.SaveChanges();

            return(queery
                   .ToList());
        }

示例#2

        public IList <TitleRateDto> CreateRating(UserTitleRate userTitleRate)
        {
            if (userTitleRate.TitleIndividRating > 10)
            {
                throw new System.ArgumentException("Rating cannot be above 10", "original");
            }

            var queery = _db.RatingTable.FromSqlInterpolated($"select * from rate({userTitleRate.UserId},{userTitleRate.TConst},{userTitleRate.TitleIndividRating})");

            _db.SaveChanges();

            return(queery
                   .ToList());
        }