private static string GetConnectionStringName()
{
Console.WriteLine("Available connection strings: ");
var connectionStringNames = new List<string>();
for (var i = 0; i < ConfigurationManager.ConnectionStrings.Count; i++)
{
var connectionStringName = ConfigurationManager.ConnectionStrings[i].Name;
if (!connectionStringName.Equals("LocalSqlServer"))
{
connectionStringNames.Add(connectionStringName);
}
}
foreach (var name in connectionStringNames)
{
Console.WriteLine(name);
}
string givenConnectionString = null;
while (!connectionStringNames.Contains(givenConnectionString))
{
Console.Write("Enter one of the available connection strings: ");
givenConnectionString = Console.ReadLine();
}
return givenConnectionString;
}