Guest User

Untitled

a guest
Mar 12th, 2018
105
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.91 KB | None | 0 0
  1. internal class DatabaseController
  2. {
  3. private readonly DatabaseContext _databaseContext;
  4.  
  5. public DatabaseController(DatabaseContext dbContext)
  6. {
  7. _databaseContext = dbContext;
  8. }
  9.  
  10. public DatabaseContext GetContext() => _databaseContext;
  11. }
  12.  
  13. public class DatabaseContext : DbContext
  14. {
  15. private readonly string _connectionString;
  16.  
  17. public DatabaseContext(string connectionString)
  18. {
  19. _connectionString = connectionString;
  20. }
  21.  
  22. protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
  23. {
  24. // server=localhost;database=peach;user=root;password=
  25. optionsBuilder.UseMySQL(_connectionString);
  26. }
  27.  
  28. public virtual DbSet<User> Users { get; set; }
  29. }
  30.  
  31. var user = new User
  32. {
  33. Id = 1,
  34. Username = "John",
  35. };
  36.  
  37. using (var dbContext = Program.DatabaseController.GetContext())
  38. {
  39. dbContext.Users.Add(user);
  40. dbContext.SaveChanges();
  41. }
Add Comment
Please, Sign In to add comment