public void Creates_SQL_Server_connection_string()
{
using (var connection = new SqlServerConnection(CreateOptions(), new Logger<SqlServerConnection>(new LoggerFactory())))
{
Assert.IsType<SqlConnection>(connection.DbConnection);
}
}
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 optionsBuilder = new DbContextOptionsBuilder();
optionsBuilder.UseSqlServer(
@"Server=(localdb)\MSSQLLocalDB;Database=SqlServerConnectionTest",
b => b.CommandTimeout(55));
using (var connection = new SqlServerConnection(optionsBuilder.Options, new Logger<SqlServerConnection>(new LoggerFactory())))
{
using (var master = connection.CreateMasterConnection())
{
Assert.Equal(55, master.CommandTimeout);
}
}
}