public void Can_create_master_connection()
{
using var connection = new SqlServerConnection(CreateDependencies());
using var master = connection.CreateMasterConnection();
Assert.Equal(@"Data Source=(localdb)\MSSQLLocalDB;Initial Catalog=master", master.ConnectionString);
Assert.Equal(60, master.CommandTimeout);
}
public void Can_create_master_connection_string()
{
using (var connection = new SqlServerConnection(CreateOptions(), new LoggerFactory()))
{
using (var master = connection.CreateMasterConnection())
{
Assert.Equal(@"Data Source=(localdb)\v11.0;Initial Catalog=master;Integrated Security=True", master.ConnectionString);
}
}
}
public void Can_create_master_connection_string()
{
using (var connection = new SqlServerConnection(CreateConfiguration(), new ConnectionStringResolver(null)))
{
using (var master = connection.CreateMasterConnection())
{
Assert.Equal(@"Data Source=""(localdb) 11.0"";Initial Catalog=master;Integrated Security=True", master.ConnectionString);
}
}
}
public void Can_create_master_connection_string()
{
using (var connection = new SqlServerConnection(CreateOptions(), new LoggerFactory()))
{
using (var master = connection.CreateMasterConnection())
{
Assert.Equal(@"Data Source=(localdb)\MSSQLLocalDB;Initial Catalog=master;Integrated Security=True", master.ConnectionString);
}
}
}
public void Can_create_master_connection_string()
{
using (var connection = new SqlServerConnection(CreateConfiguration(), new ConnectionStringResolver(null)))
{
using (var master = connection.CreateMasterConnection())
{
Assert.Equal(@"Data Source=""(localdb) 11.0"";Initial Catalog=master;Integrated Security=True", master.ConnectionString);
}
}
}
public void Can_create_master_connection()
{
using (var connection = new SqlServerConnection(CreateOptions(), new Logger <SqlServerConnection>(new LoggerFactory())))
{
using (var master = connection.CreateMasterConnection())
{
Assert.Equal(@"Data Source=(localdb)\MSSQLLocalDB;Initial Catalog=master", master.ConnectionString);
Assert.Equal(SqlServerConnection.DefaultMasterConnectionCommandTimeout, master.CommandTimeout);
}
}
}
public void Master_connection_string_none_default_command_timeout()
{
var options = new DbContextOptionsBuilder()
.UseSqlServer(
@"Server=(localdb)\MSSQLLocalDB;Database=SqlServerConnectionTest",
b => b.CommandTimeout(55))
.Options;
using var connection = new SqlServerConnection(CreateDependencies(options));
using var master = connection.CreateMasterConnection();
Assert.Equal(55, master.CommandTimeout);
}
public void Master_connection_string_contains_filename()
{
var options = new DbContextOptionsBuilder()
.UseSqlServer(
@"Server=(localdb)\MSSQLLocalDB;Database=SqlServerConnectionTest;AttachDBFilename=C:\Narf.mdf",
b => b.CommandTimeout(55))
.Options;
using var connection = new SqlServerConnection(CreateDependencies(options));
using var master = connection.CreateMasterConnection();
Assert.Equal(@"Data Source=(localdb)\MSSQLLocalDB;Initial Catalog=master", master.ConnectionString);
}
public void Master_connection_string_contains_filename()
{
var optionsBuilder = new DbContextOptionsBuilder();
optionsBuilder.UseSqlServer(@"Server=(localdb)\MSSQLLocalDB;Database=SqlServerConnectionTest;AttachDBFilename=C:\Narf.mdf");
using (var connection = new SqlServerConnection(optionsBuilder.Options, new Logger <SqlServerConnection>(new LoggerFactory())))
{
using (var master = connection.CreateMasterConnection())
{
Assert.Equal(@"Data Source=(localdb)\MSSQLLocalDB;Initial Catalog=master", master.ConnectionString);
}
}
}
public void Master_connection_string_none_default_command_timeout()
{
var optionsBuilder = new DbContextOptionsBuilder();
optionsBuilder.UseSqlServer(@"Server=(localdb)\MSSQLLocalDB;Database=SqlServerConnectionTest;Trusted_Connection=True;")
.CommandTimeout(55);
using (var connection = new SqlServerConnection(optionsBuilder.Options, new Logger <SqlServerConnection>(new LoggerFactory())))
{
using (var master = connection.CreateMasterConnection())
{
Assert.Equal(55, master.CommandTimeout);
}
}
}
