예제 #1
0
        private void PutDataToDb()
        {
            using (OddsDbContext db = new OddsDbContext())
            {
                List <OddValue> valuesList = _scrapper.OddValues;

                var duelLinks = valuesList.Select(x => x.DuelLink).Distinct();
                foreach (var duelLink in duelLinks)
                {
                    db.DuelLinks.Add(duelLink);
                }

                var matchLinks = valuesList.Select(x => x.DuelLink.MatchLink).Distinct();
                foreach (var matchLink in matchLinks)
                {
                    db.MatchLinks.Add(matchLink);
                }

                var countryLinks = valuesList.Select(x => x.DuelLink.MatchLink.CountryLink).Distinct();
                foreach (var countryLink in countryLinks)
                {
                    db.CountryLinks.Add(countryLink);
                }

                foreach (var oddValue in valuesList)
                {
                    db.OddValues.Add(oddValue);
                }

                db.SaveChanges();
            }
        }
        public void TestDbContext()
        {
            DuelLink duelLink = new DuelLink()
            {
                MatchLink = null, Url = "dfdf", DuelLinkId = 6, Name = "Name"
            };
            OddsDbContext db = new OddsDbContext();

            db.DuelLinks.Add(duelLink);
        }