//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);
}
