//Add-Migration lmcom-serv-001 -c NewData.NewLMComContext_SqlServer //Update-Database lmcom-serv-002 -c NewData.NewLMComContext_SqlServer protected override void OnConfiguring(DbContextOptionsBuilder options) { base.OnConfiguring(options); var config = ConfigurationManager.ConnectionStrings["Container"]; var conn = new SqlConnection(config.ConnectionString); //var conn = new SqlConnection("Data Source=localhost\\SQLEXPRESS;Initial Catalog=NewLMCom_ef7;Integrated Security=False;User ID=lmcomdatatest;Password=lmcomdatatest;"); options.UseSqlServer(conn); }
public ContextRegistry() { optionsBuilder = new DbContextOptionsBuilder<ProductContext>(); optionsBuilder.UseInMemoryDatabase(); For<IContext>().Use("Create new instance of data context", x => new ProductContext(optionsBuilder.Options)); }
private static IInMemoryDatabase CreateStore(IServiceProvider serviceProvider, bool persist) { var optionsBuilder = new DbContextOptionsBuilder(); optionsBuilder.UseInMemoryDatabase(); return InMemoryTestHelpers.Instance.CreateContextServices(serviceProvider, optionsBuilder.Options).GetRequiredService<IInMemoryDatabase>(); }
public void Is_configured_when_configuration_contains_associated_extension() { var optionsBuilder = new DbContextOptionsBuilder(); optionsBuilder.UseSqlServer("Database=Crunchie"); Assert.True(new DatabaseProvider<SqlServerDatabaseProviderServices, SqlServerOptionsExtension>().IsConfigured(optionsBuilder.Options)); }
protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder) { var connString = Startup.Configuration["Data:WorldContextConnection"]; optionsBuilder.UseSqlServer(connString); base.OnConfiguring(optionsBuilder); }
public void It_enforces_foreign_key(bool suppress) { var builder = new DbContextOptionsBuilder(); var sqliteBuilder = builder.UseSqlite(_testStore.Connection.ConnectionString); if (suppress) { sqliteBuilder.SuppressForeignKeyEnforcement(); } var options = builder.Options; using (var context = new MyContext(options)) { context.Database.EnsureCreated(); context.Add(new Child { ParentId = 4 }); if (suppress) { context.SaveChanges(); } else { var ex = Assert.Throws<DbUpdateException>(() => { context.SaveChanges(); }); Assert.Contains("FOREIGN KEY constraint failed", ex.InnerException.Message); } } }
protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder) { if (!string.IsNullOrEmpty(ConnectionString)) { optionsBuilder.UseSqlServer(ConnectionString); } }
public void Is_configured_when_configuration_contains_associated_extension() { var optionsBuilder = new DbContextOptionsBuilder(); optionsBuilder.UseInMemoryDatabase(); Assert.True(new DatabaseProvider<InMemoryDatabaseProviderServices, InMemoryOptionsExtension>().IsConfigured(optionsBuilder.Options)); }
public void It_allows_foreign_key_to_unique_index() { var builder = new DbContextOptionsBuilder(); var sqliteBuilder = builder.UseSqlite(_testStore.Connection.ConnectionString); var options = builder.Options; _testStore.ExecuteNonQuery(@" CREATE TABLE User ( Id INTEGER PRIMARY KEY, AltId INTEGER NOT NULL UNIQUE ); CREATE TABLE Comment ( Id INTEGER PRIMARY KEY, UserAltId INTEGER NOT NULL, Comment TEXT, FOREIGN KEY (UserAltId) REFERENCES User (AltId) );"); long id; using (var context = new BloggingContext(options)) { var entry = context.User.Add(new User { AltId = 1356524 }); context.Comments.Add(new Comment { User = entry.Entity }); context.SaveChanges(); id = entry.Entity.Id; } using (var context = new BloggingContext(options)) { var comment = context.Comments.Include(u => u.User).Single(); Assert.Equal(id, comment.User.Id); } }
protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder) { base.OnConfiguring(optionsBuilder); //var connectionString = @"Data Source=SERENITY\EXPRESS2014;Initial Catalog=TicketSystem;Integrated Security=True"; var connectionString = @"Data Source=ENTERPRISE1\EXPRESS2014;Initial Catalog=code_louisville_dotnet;Integrated Security=True"; optionsBuilder.UseSqlServer(connectionString); }
protected override DbContextOptions CreateOptions(string databaseName) { var optionsBuilder = new DbContextOptionsBuilder(); optionsBuilder.UseInMemoryDatabase(); return optionsBuilder.Options; }
protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder) { base.OnConfiguring(optionsBuilder); var connectionString = @"Server=(LocalDb)\MSSQLLocalDb;Database=AspNetBlog"; optionsBuilder.UseSqlServer(connectionString); }
public HomeControllerTests() { // Database setup var services = new ServiceCollection(); services.AddEntityFramework() .AddSqlServer() .AddInMemoryDatabase() .AddDbContext<DataDbContext>(options => options.UseInMemoryDatabase() ); // Dependencies initializations _pageConfiguration = new FakePageConfiguration(); var optionsBuilder = new DbContextOptionsBuilder<DataDbContext>(); optionsBuilder.UseInMemoryDatabase(); _dataDbContext = new DataDbContext(optionsBuilder.Options); _contentRepository = new ContentRepository(_dataDbContext); _humanReadableContentService = new HumanReadableContentService(_pageConfiguration, _contentRepository); _languageManipulationService = new LanguageManipulationService(); // Controller initialization _homeController = new PersonalWebsite.Controllers.HomeController( _pageConfiguration, _humanReadableContentService, _languageManipulationService ); }
// This method gets called by the runtime. Use this method to add services to the container. // For more information on how to configure your application, visit http://go.microsoft.com/fwlink/?LinkID=398940 public void ConfigureServices(IServiceCollection services) { string connectionString = @"Server= (localhost); Database =DESKTOP-S516B9C.CodeBlog;Trusted_Connection=True;"; DbContextOptionsBuilder dbOpt = new DbContextOptionsBuilder<Context>(); services.AddDbContext<Context>( options => options.UseSqlServer(connectionString)); services.AddMvc(); }
private static DbContextOptions CreateOptions(IDbContextOptionsExtension extension) { var optionsBuilder = new DbContextOptionsBuilder(); ((IDbContextOptionsBuilderInfrastructure)optionsBuilder).AddOrUpdateExtension(extension); return optionsBuilder.Options; }
private static SqlServerOptionsExtension GetOrCreateExtension(DbContextOptionsBuilder optionsBuilder) { var existing = optionsBuilder.Options.FindExtension<SqlServerOptionsExtension>(); return existing != null ? new SqlServerOptionsExtension(existing) : new SqlServerOptionsExtension(); }
// Estabelecendo conexão com o banco. protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder) { string stringConexao = ConfigurationManager.ConnectionStrings["EstudosEntityConnectionString"].ConnectionString; optionsBuilder.UseSqlServer(stringConexao); base.OnConfiguring(optionsBuilder); }
protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder) { if (!optionsBuilder.IsConfigured) { optionsBuilder.UseSqlServer(@"Server=(localdb)\mssqllocaldb;Database=SpyStoreData;Trusted_Connection=True;MultipleActiveResultSets=true;"); } }
protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder) { optionsBuilder.UseSqlServer(@"Server=(localdb)\mssqllocaldb;Database=Demo.ReplacingServices;Trusted_Connection=True;"); // TODO Register our custom type mapper }
protected override void OnConfiguring(DbContextOptionsBuilder options) { var config = new Configuration() .AddJsonFile("config.json"); var constr = config.Get("Data:DefaultConnection:ConnectionString"); options.UseSqlServer(constr); }
protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder) { // Visual Studio 2015 | Use the LocalDb 12 instance created by Visual Studio optionsBuilder.UseSqlServerWithMaterialization(@"Server=(localdb)\mssqllocaldb;Database=Ef7Tests;Trusted_Connection=True;"); // Visual Studio 2013 | Use the LocalDb 11 instance created by Visual Studio //optionsBuilder.UseSqlServer(@"Server=(localdb)\mssqllocaldb;Database=Ef7Tests;Trusted_Connection=True;"); }
protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder) { base.OnConfiguring(optionsBuilder); SqliteConnectionStringBuilder sb = new SqliteConnectionStringBuilder(); sb.DataSource = filename; optionsBuilder.UseSqlite(sb.ToString()); }
public static void Main(string[] args) { Logger.Info("Update Batch Starting"); var builder = new ConfigurationBuilder() .SetBasePath(Directory.GetCurrentDirectory()) .AddJsonFile("appsettings.json") .AddEnvironmentVariables(); Configuration = builder.Build(); DbContextOptionsBuilder<BddContext> options = new DbContextOptionsBuilder<BddContext>(); options.UseSqlite(Program.Configuration["Data:DefaultConnection:ConnectionString"]); Options = options.Options; string[] equipe = new string[] { "equipe1", "equipe2", "equipe3"}; // Parsing classement ParseClassement(equipe); // Parsing des actualités ParseActus(); // Parsing des pages Agendas ParseAgendas(); // Parsing des pages par journées ParseJournees(); Logger.Info("Update Batch End"); }
public static IDbContextOptions CreateOptions() { var optionsBuilder = new DbContextOptionsBuilder(); optionsBuilder.UseSqlServer(@"Server=(localdb)\MSSQLLocalDB;Database=SqlServerConnectionTest"); return optionsBuilder.Options; }
protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder) { #if DEBUG ConnectionString = "Server=(localdb)\\MSSQLLocalDB;Database=Health;Trusted_Connection=True;"; #endif optionsBuilder.UseSqlServer(ConnectionString); }
protected override void OnConfiguring(DbContextOptionsBuilder options) { base.OnConfiguring(options); options.UseSqlServer("Server=(localdb)\\ProjectsV12;Database=EF7;Trusted_Connection=true;MultipleActiveResultSets=True"). MaxBatchSize(20); }
protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder) { base.OnConfiguring(optionsBuilder); //optionsBuilder.Options. }
public override CrossStoreContext CreateContext(TestStore testStore) { var inMemoryTestStore = testStore as InMemoryTestStore; if (inMemoryTestStore != null) { var optionsBuilder = new DbContextOptionsBuilder(); optionsBuilder.UseInMemoryStore(); return new CrossStoreContext(_serviceProvider, optionsBuilder.Options); } var sqlServerTestStore = testStore as SqlServerTestStore; if (sqlServerTestStore != null) { var optionsBuilder = new DbContextOptionsBuilder(); optionsBuilder.UseSqlServer(sqlServerTestStore.Connection); var context = new CrossStoreContext(_serviceProvider, optionsBuilder.Options); context.Database.EnsureCreated(); context.Database.AsRelational().Connection.UseTransaction(sqlServerTestStore.Transaction); return context; } throw new NotImplementedException(); }
protected abstract TDBContext Get(IConfigurationRoot configuration, DbContextOptionsBuilder <TDBContext> builder);
protected override void OnConfiguring(DbContextOptionsBuilder options) { options.UseMySQL($"Server=localhost;port={_port};Database={_database};user={_user};password={_password}"); }
protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder) => optionsBuilder .UseMySql(string.Format(@"Server=localhost;database={0};uid={1};", SecretStrings.database, SecretStrings.user));
protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder) { connectionString = "Data Source=192.168.50.95;Initial Catalog=sprathipati;Integrated Security=True;Persist Security Info=False;Pooling=False;MultipleActiveResultSets=False;Encrypt=False;TrustServerCertificate=False"; optionsBuilder.UseSqlServer(connectionString); }
protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder) { optionsBuilder.UseNpgsql(_connectionString); }
protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder) => optionsBuilder.UseSqlite(ConfigurationManager.ConnectionStrings["DbSqlite"].ConnectionString);
protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder) { var configuration = new ConfigurationBuilder().SetBasePath(Directory.GetCurrentDirectory()).AddJsonFile("appsettings.json").Build(); optionsBuilder.UseSqlServer(configuration.GetConnectionString("CharactersConnectionString")); }
protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder) { optionsBuilder.UseSqlite(_connString); }
protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder) { optionsBuilder.UseSqlServer("Data Source=DESKTOP-OH4MS2K\\SQLEXPRESS;Initial Catalog=fitness;Trusted_Connection=True;"); base.OnConfiguring(optionsBuilder); }
/// <summary> /// The OnConfiguring method. /// </summary> /// <param name="optionsBuilder">The optionsBuilder<see cref="DbContextOptionsBuilder"/>.</param> protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder) { optionsBuilder.UseSqlServer($@"Server=.\SQLEXPRESS;Database={DatabaseName}; Trusted_Connection = true;"); }
protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder) { optionsBuilder.UseSqlServer("Data Source=(LocalDB)\\MSSQLLocalDB;AttachDbFilename=C:\\git\\spaceways\\data-source\\DataBase.mdf;Integrated Security=True;"); }
protected override void OnConfiguring(DbContextOptionsBuilder options) { options.UseNpgsql(Properties.Settings.Default.brainly_info); }
//public DbSet<Favorito> Favoritos { get; set; } protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder) { optionsBuilder.UseSqlServer(Settings.ConnectionString); //base.OnConfiguring(optionsBuilder); }
protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder) { optionsBuilder.UseSqlServer(@"Server=localhost,master(sa); Database=Northwind; Trusted_Connection=true"); //192.168.65.0/24 }
protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder) { }
protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder) { optionsBuilder.UseSqlite("Data Source= Ciudades.db"); }
protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder) { optionsBuilder.UseLazyLoadingProxies(); }
protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder) { base.OnConfiguring(optionsBuilder); optionsBuilder.EnableSensitiveDataLogging(); }
protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder) { optionsBuilder.UseSqlServer(@"Server=(localdb)\mssqllocaldb;Database=ReCapProject;Trusted_Connection=true"); }
protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder) { optionsBuilder.UseSqlServer("Data Source=.;Initial Catalog=test; Trusted_Connection=True"); }
protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder) { optionsBuilder.UseSqlServer("Server=.\\SQLEXPRESS;Database=AppTrackerDb;Trusted_Connection=true"); }
protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder) { optionsBuilder.UseSqlServer(@"Server=DESKTOP-9B6VH46\SQLEXPRESS;Database=Northwind;Trusted_Connection=true"); //optionsBuilder.UseSqlServer(@"Server=(localdb)\mssqllocaldb;Database=Northwind;Trusted_Connection=true"); }
protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder) => optionsBuilder.UseNpgsql("Host=postgresql-oceanstudio.alwaysdata.net;Database=oceanstudio_phonebook;Username=oceanstudio;Password=bil442.ad");
protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder) { optionsBuilder.UseSqlServer(@"Data Source=(localdb)\MSSQLLocalDB;Initial Catalog=ContosoDDD;Integrated Security=True;Connect Timeout=30;Encrypt=False;TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False"); }
protected override void OnConfiguring(DbContextOptionsBuilder options) => options.UseSqlite("Data Source=VonageVideo.db");
protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder) { optionsBuilder.UseLazyLoadingProxies().UseSqlite(Option.ConnectionString); base.OnConfiguring(optionsBuilder); }
protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder) { optionsBuilder.UseSqlServer(_configuration.GetConnectionString("DefaultConnection")); }
protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder) { optionsBuilder.UseNpgsql("server=localhost;database=SuncoastMovies"); }
protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder) { optionsBuilder.UseMySQL("server=localhost;database=library;user=root;SslMode=none"); }
public override DbContextOptionsBuilder AddOptions(DbContextOptionsBuilder builder) => base.AddOptions(builder);
protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder) { if (!optionsBuilder.IsConfigured) { optionsBuilder.UseSqlServer(@"Server=(localdb)\mssqllocaldb;Database=EFProviders.InMemory;Trusted_Connection=True;"); } }
//Add-Migration vyzva-sqlite-001 -c NewData.Vyzva57Context_Sqlite //Update-Database vyzva-sqlite-001 -c NewData.Vyzva57Context_Sqlite protected override void OnConfiguring(DbContextOptionsBuilder options) { base.OnConfiguring(options); var config = ConfigurationManager.ConnectionStrings["Vyzva57-sqlite"]; var conn = new SqliteConnection(config.ConnectionString); //var conn = new SqliteConnection("Data Source=" + MachinesLow.rootDir + config.ConnectionString); options.UseSqlite(conn); }