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); }