How do I generate a different DB instance name for different tests

See more:

C#

I have some tests on xUnit where during the test a DBInstance is created based on a randomly generated name

private static readonly string _databaseInstanceName = Guid.NewGuid().ToString("N")

private static readonly string _databaseConnection = $@"Server=(localdb)\{_databaseInstanceName};Integrated Security=true";

Then an instance is created as follows

public LocalDbManager LocalDbManager = new LocalDbManager(_databaseInstanceName);

At the time being as the code is a random GUID is generated only once, but now I need that this random GUID is generated for every DB instance I create.

What I have tried:

But my problem is that some tests are failing with this approach

private static string _databaseInstanceName;

private static string GetDbInstanceName()
{
	_databaseInstanceName = Guid.NewGuid().ToString("N");
	return _databaseInstanceName;
}

public LocalDbManager LocalDbManager = new LocalDbManager(GetDbInstanceName());

private string DatabaseConnection => $@"Server=(localdb)\{_databaseInstanceName};Integrated Security=true";