DbHelper.cs 716 B

12345678910111213141516171819202122232425262728
  1. using System;
  2. using Database.Database;
  3. using Microsoft.EntityFrameworkCore;
  4. namespace CMS.Worker.Utils
  5. {
  6. public class DbHelper
  7. {
  8. private ModelContext _dbContext;
  9. private DbContextOptions<ModelContext> GetAllOptions(string connection)
  10. {
  11. DbContextOptionsBuilder<ModelContext> optionsBuilder =
  12. new DbContextOptionsBuilder<ModelContext>();
  13. string connectionString = connection;
  14. optionsBuilder.UseOracle(connectionString);
  15. return optionsBuilder.Options;
  16. }
  17. public ModelContext GetDbContext(string connection)
  18. {
  19. return new ModelContext(GetAllOptions(connection));
  20. }
  21. }
  22. }