C# (CSharp) SpartaDatabase Examples

Example #1

File: Cohort.cshtml.cs Project: Lidinh26/Sparta-C-Sharp-Course

 public void OnGet()
 {
     using (var db = new SpartaDatabase())
     {
         CohortList = db.Cohort.ToList();
     }
 }

Example #2

 public void OnGet()
 {
     using (var db = new SpartaDatabase())
     {
         RoleList = db.Role.ToList();
     }
 }

Example #3

File: User.cshtml.cs Project: Lidinh26/Sparta-C-Sharp-Course

 public void OnGet()
 {
     using (var db = new SpartaDatabase())
     {
         UserList = db.User.ToList();
     }
 }

Example #4

File: Specialisation.cshtml.cs Project: Lidinh26/Sparta-C-Sharp-Course

 public void OnGet()
 {
     using (var db = new SpartaDatabase())
     {
         SpecialisationList = db.Specialisation.ToList();
     }
 }

Example #5

File: User.cshtml.cs Project: Lidinh26/Sparta-C-Sharp-Course

 public IActionResult OnPost()
 {
     using (var db = new SpartaDatabase())
     {
         if (ModelState.IsValid)
         {
             db.User.Add(NewUser);
             db.SaveChanges();
             return(RedirectToPage("/User"));
         }
     }
     return(Page());
 }

Example #6

File: NewUser.cshtml.cs Project: Lidinh26/Sparta-C-Sharp-Course

 public NewUserModel(SpartaDatabase injectedcontext)
 {
     db = injectedcontext;
 }