TeamDataContext.cs 2.1 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849
  1. using Microsoft.EntityFrameworkCore;
  2. using System;
  3. using Repository.Entiies;
  4. using Microsoft.EntityFrameworkCore.Metadata.Builders;
  5. namespace Repository
  6. {
  7. public class TeamDataContext : DbContext
  8. {
  9. protected override void OnConfiguring(DbContextOptionsBuilder options)
  10. {
  11. options.EnableSensitiveDataLogging();
  12. var connetionString = $"Data Source={AppDomain.CurrentDomain.BaseDirectory}data.db";
  13. options.UseSqlite(connetionString).UseQueryTrackingBehavior(QueryTrackingBehavior.NoTracking);
  14. base.OnConfiguring(options);
  15. }
  16. public DbSet<TestResult> ProductResult { get; set; }
  17. public DbSet<ParamLog> ParamLogs { get; set; }
  18. public DbSet<StatisticsLog> StatisticsLogs { get; set; }
  19. public DbSet<Information> Informations { get; set; }
  20. public DbSet<SopFile> SopFiles { get; set; }
  21. public DbSet<LocalFileDb> LocalFile { get; set; }
  22. public DbSet<LocalFile2Db> LocalFile2 { get; set; }
  23. public DbSet<LocalFile3Db> LocalFile3 { get; set; }
  24. public DbSet<Account> Accounts { get; set; }
  25. public DbSet<Person> Persons { get; set; }
  26. public DbSet<House> Houses { get; set; }
  27. public DbSet<Quality> Qualitys { get; set; }
  28. public DbSet<OutofWork> OutofWorks { get; set; }
  29. }
  30. public class CustomerDataContext : DbContext
  31. {
  32. protected override void OnConfiguring(DbContextOptionsBuilder options)
  33. {
  34. options.EnableSensitiveDataLogging();
  35. var connetionString = $"Data Source=124.71.173.222;Initial Catalog=AIS20220504021055;Persist Security Info=True;User ID=sa;Password=jlkj123@;Encrypt=False";
  36. //$"Data Source=124.71.173.222;Initial Catalog=AIS20220504021055;User ID=sa;Password=jlkj123@;Encrypt=True;TrustServerCertificate=True";
  37. options.UseSqlServer(connetionString).UseQueryTrackingBehavior(QueryTrackingBehavior.NoTracking);
  38. base.OnConfiguring(options);
  39. }
  40. public DbSet<Table> Table { get; set; }//查看别人的数据库不能有s
  41. public DbSet<ICMO> ICMO { get; set; }
  42. }
  43. }