public IActionResult SaveStudent([Bind("Name,Surname,BirthDate,Enrollment,Email")] Student student)
 {
     student.ID = Guid.NewGuid();
     _Context.Students.Add(student);
     _Context.SaveChanges();
     return(View("Details", student));
 }
        private void btn1_Click(object sender, RoutedEventArgs e)
        {
            WebClient client = new WebClient();

            client.Encoding = Encoding.UTF8;
            string result = client.DownloadString("https://apidata.mos.ru/v1/datasets/2263/rows?$top=10&api_key=c941a998bbb9e1e374fc2d7a33f61ed0");
            List <ResultFromServer> resultServer = JsonConvert.DeserializeObject <List <ResultFromServer> >(result);
            var    optionsBuilder = new DbContextOptionsBuilder <InstituteContext>();
            string newPath        = System.IO.Path.GetFullPath(System.IO.Path.Combine(Directory.GetCurrentDirectory(), @"..\..\..\..\"));
            string newnewpath     = System.IO.Path.Combine(newPath, "MoscowInstitute.WebService", "MoscowInstitute.db");

            optionsBuilder.UseSqlite($"Data Source={newnewpath}");
            var context = new InstituteContext(options: optionsBuilder.Options);

            context.Database.ExecuteSqlRaw("DELETE FROM Institutes");
            using (context)
            {
                foreach (var item in resultServer)
                {
                    DomainObjects.Institute institute = new DomainObjects.Institute();
                    institute.ShortName            = item.Cells.ShortName;
                    institute.LegalAddress         = item.Cells.LegalAddress;
                    institute.WebSite              = item.Cells.WebSite;
                    institute.ChiefName            = item.Cells.ChiefName;
                    context.Entry(institute).State = EntityState.Added;
                    context.SaveChanges();
                }
            }
        }
 private void Save() => Context.SaveChanges();