protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder) { V_0 = MixService.GetConnectionString("MixCmsConnection"); if (!string.IsNullOrEmpty(V_0)) { switch (Enum.Parse <MixEnums.DatabaseProvider>(MixService.GetConfig <string>("DatabaseProvider"))) { case 0: { dummyVar0 = SqlServerDbContextOptionsExtensions.UseSqlServer(optionsBuilder, V_0, null); return; } case 1: { dummyVar1 = MySqlDbContextOptionsExtensions.UseMySql(optionsBuilder, V_0, null); return; } case 2: { dummyVar2 = NpgsqlDbContextOptionsExtensions.UseNpgsql(optionsBuilder, V_0, null); break; } default: { return; } } } return; }
private ICityService getCityService() { DbContextOptions options = MySqlDbContextOptionsExtensions.UseMySql(new DbContextOptionsBuilder(), ConnectionString).Options; SakilaDbContext ctx = new SakilaDbContext(options); ICityService cityService = new CityService(ctx); return(cityService); }
public void testFindById() { DbContextOptions options = MySqlDbContextOptionsExtensions.UseMySql(new DbContextOptionsBuilder(), ConnectionString).Options; SakilaDbContext ctx = new SakilaDbContext(options); IFilmService filmService = new FilmService(ctx); Film film = filmService.findById(83); Assert.Equal("BLUES INSTINCT", film.Title); }
public void testListAll() { DbContextOptions options = MySqlDbContextOptionsExtensions.UseMySql(new DbContextOptionsBuilder(), ConnectionString).Options; SakilaDbContext ctx = new SakilaDbContext(options); IFilmService filmService = new FilmService(ctx); List <Film> filmsList = filmService.listAll(); Assert.Equal(1000, filmsList.Count); }
public void testListAll() { // restauração do banco DbContextOptions options = MySqlDbContextOptionsExtensions .UseMySql(new DbContextOptionsBuilder(), "server=172.16.99.230;userid=root;pwd=1q2w3e4r;port=3308;database=sakila;sslmode=none;").Options; SakilaDbContext ctx = new SakilaDbContext(options); filmService = new FilmService(ctx); var list = filmService.listAll(); Assert.Equal(1000, list.Count); Assert.NotNull(list[45].Language); }
public void UseMySql_ThrowsIfServiceNameNull() { var optionsBuilder = new DbContextOptionsBuilder(); var goodBuilder = new DbContextOptionsBuilder <GoodDbContext>(); var config = new ConfigurationBuilder().Build(); string serviceName = null; var ex2 = Assert.Throws <ArgumentException>(() => MySqlDbContextOptionsExtensions.UseMySql(optionsBuilder, config, serviceName)); Assert.Contains(nameof(serviceName), ex2.Message); var ex4 = Assert.Throws <ArgumentException>(() => MySqlDbContextOptionsExtensions.UseMySql <GoodDbContext>(goodBuilder, config, serviceName)); Assert.Contains(nameof(serviceName), ex4.Message); }
public void testSaveOrUpdate_atualizacao() { DbContextOptions options = MySqlDbContextOptionsExtensions.UseMySql(new DbContextOptionsBuilder(), ConnectionString).Options; SakilaDbContext ctx = new SakilaDbContext(options); IFilmService filmService = new FilmService(ctx); Film film = new Film() { Id = 2, Title = "Filme Teste2", Description = "Description2", ReleaseYear = 2019 }; filmService.saveOrUpdate(film); Assert.Equal("Filme Teste2", filmService.findById(2).Title); }
protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder) { if (!optionsBuilder.get_IsConfigured()) { V_0 = MixService.GetConnectionString("MixCmsConnection"); if (!string.IsNullOrEmpty(V_0)) { if (MixService.GetConfig <bool>("IsMysql")) { dummyVar0 = MySqlDbContextOptionsExtensions.UseMySql(optionsBuilder, V_0, null); return; } dummyVar1 = SqlServerDbContextOptionsExtensions.UseSqlServer(optionsBuilder, V_0, null); } } return; }
public void testSaveOrUpdate_insercao() { DbContextOptions options = MySqlDbContextOptionsExtensions.UseMySql(new DbContextOptionsBuilder(), ConnectionString).Options; SakilaDbContext ctx = new SakilaDbContext(options); IFilmService filmService = new FilmService(ctx); Film film = new Film() { Title = "Filme Teste", Description = "Description", ReleaseYear = 2018 }; filmService.saveOrUpdate(film); Assert.Equal(film, filmService.findById(1001)); Assert.Equal(1001, filmService.listAll().Count); }
public void UseMySql_ThrowsIfConfigurationNull() { var optionsBuilder = new DbContextOptionsBuilder(); var goodBuilder = new DbContextOptionsBuilder <GoodDbContext>(); IConfigurationRoot config = null; var ex = Assert.Throws <ArgumentNullException>(() => MySqlDbContextOptionsExtensions.UseMySql(optionsBuilder, config)); Assert.Contains(nameof(config), ex.Message); var ex2 = Assert.Throws <ArgumentNullException>(() => MySqlDbContextOptionsExtensions.UseMySql(optionsBuilder, config, "foobar")); Assert.Contains(nameof(config), ex2.Message); var ex3 = Assert.Throws <ArgumentNullException>(() => MySqlDbContextOptionsExtensions.UseMySql <GoodDbContext>(goodBuilder, config)); Assert.Contains(nameof(config), ex3.Message); var ex4 = Assert.Throws <ArgumentNullException>(() => MySqlDbContextOptionsExtensions.UseMySql <GoodDbContext>(goodBuilder, config, "foobar")); Assert.Contains(nameof(config), ex4.Message); }
public void UseMySql_ThrowsIfDbContextOptionsBuilderNull() { // Arrange DbContextOptionsBuilder optionsBuilder = null; DbContextOptionsBuilder <GoodDbContext> goodBuilder = null; IConfigurationRoot config = null; // Act and Assert var ex = Assert.Throws <ArgumentNullException>(() => MySqlDbContextOptionsExtensions.UseMySql(optionsBuilder, config)); Assert.Contains(nameof(optionsBuilder), ex.Message); var ex2 = Assert.Throws <ArgumentNullException>(() => MySqlDbContextOptionsExtensions.UseMySql(optionsBuilder, config, "foobar")); Assert.Contains(nameof(optionsBuilder), ex2.Message); var ex3 = Assert.Throws <ArgumentNullException>(() => MySqlDbContextOptionsExtensions.UseMySql <GoodDbContext>(goodBuilder, config)); Assert.Contains(nameof(optionsBuilder), ex3.Message); var ex4 = Assert.Throws <ArgumentNullException>(() => MySqlDbContextOptionsExtensions.UseMySql <GoodDbContext>(goodBuilder, config, "foobar")); Assert.Contains(nameof(optionsBuilder), ex4.Message); }
private static DbContextOptions GetOptions(string connectionString) { return(MySqlDbContextOptionsExtensions.UseMySql(new DbContextOptionsBuilder(), connectionString).Options); }
// This method gets called by the runtime. Use this method to add services to the container. public void ConfigureServices(IServiceCollection services) { var mysql = true; if (!mysql) { string connectionString = "Server=tcp:nerdish.database.windows.net,1433;Initial Catalog=sigma;Persist Security Info=False;User ID=api;Password='******';MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;"; services.AddDbContext <SigmaContext>(x => x.UseSqlServer(connectionString)); } else { MySqlConnectionStringBuilder connectionString = new MySqlConnectionStringBuilder() { UserID = "api", Server = "204.48.19.107", Port = 3306, Password = "******", Database = "sigma" }; services.AddDbContext <SigmaContext>(x => MySqlDbContextOptionsExtensions.UseMySql(x, connectionString.ToString())); } services.AddTransient <IRepository <Turno>, RTurno>(); services.AddTransient <IRepository <Materia>, RMateria>(); services.AddTransient <IRepository <Orientacion>, ROrientacion>(); services.AddTransient <IRepository <Grupo>, RGrupo>(); services.AddTransient <IUserRepository <Docente>, RDocente>(); services.AddTransient <IRepository <GrupoDocente>, RGrupoDocente>(); services.AddTransient <IRepository <ParcialGrupo>, RParcialGrupo>(); services.AddTransient <IRepository <EscritoGrupo>, REscritoGrupo>(); services.AddTransient <IRepository <TareaGrupo>, RTareaGrupo>(); services.AddTransient <IRepository <Tarea>, RTarea>(); services.AddTransient <IUserRepository <Alumno>, RAlumno>(); services.AddTransient <IRepository <Imagen>, RImagen>(); services.AddTransient <IRepository <Pregunta>, RPregunta>(); services.AddTransient <IRepository <PreguntaOpcion>, RPreguntaOpcion>(); services.AddTransient <IRepository <Alerta>, RAlerta>(); services.AddTransient <IRepository <Token>, RToken>(); services.AddTransient <IRepository <Parcial>, RParcial>(); services.AddTransient <IRepository <EncuestaGlobal>, REncuestaGlobal>(); services.AddTransient <IRepository <CambioDeSalon>, RCambioDeSalon>(); services.AddTransient <IRepository <Salon>, RSalon>(); services.AddTransient <IRepository <HoraMateria>, RHoraMateria>(); services.AddTransient <IUserRepository <Adscripto>, RAdscripto>(); services.AddTransient <IRepository <Escrito>, REscrito>(); services.AddIdentity <AppUser, IdentityRole>(options => { options.User.AllowedUserNameCharacters = "abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789"; options.User.RequireUniqueEmail = false; }).AddEntityFrameworkStores <SigmaContext>().AddDefaultTokenProviders(); services.AddMvc(); services.Configure <IdentityOptions>(options => { options.Password.RequireDigit = false; options.Password.RequiredLength = 1; options.Password.RequireLowercase = false; options.Password.RequireNonAlphanumeric = false; options.Password.RequireUppercase = false; }); JwtSecurityTokenHandler.DefaultInboundClaimTypeMap.Clear(); // => remove default claims services .AddAuthentication(options => { options.DefaultAuthenticateScheme = JwtBearerDefaults.AuthenticationScheme; options.DefaultScheme = JwtBearerDefaults.AuthenticationScheme; options.DefaultChallengeScheme = JwtBearerDefaults.AuthenticationScheme; }) .AddJwtBearer(cfg => { cfg.RequireHttpsMetadata = false; cfg.SaveToken = true; cfg.TokenValidationParameters = new TokenValidationParameters { ValidIssuer = Configuration["JwtIssuer"], ValidAudience = Configuration["JwtIssuer"], IssuerSigningKey = new SymmetricSecurityKey(Encoding.UTF8.GetBytes(Configuration["JwtKey"])), ClockSkew = TimeSpan.Zero // remove delay of token when expire }; }); services.AddCors(options => { options.AddPolicy("CorsPolicy", builder => builder .AllowAnyOrigin() .AllowAnyMethod() .AllowAnyHeader() .AllowCredentials()); }); }
private static DbContextOptions <DBEntities> GetOptions() { return(MySqlDbContextOptionsExtensions.UseMySql(new DbContextOptionsBuilder <DBEntities>(), Startup.ConnectionString).Options); }
private static DbContextOptions GetOptions() { return(MySqlDbContextOptionsExtensions.UseMySql(new DbContextOptionsBuilder(), "Server=78.102.218.164;Port=7688;Database=chatter;User=conApp;Password=igR7DqL3HcvnHJ2q;CharSet=utf8;").Options); }