如何通过 asp.net mvc4 中的 webconfig 获取数据库名称列表

Question

>我在登录屏幕中有一个组合框。在该组合框中，我需要数据库的名称。我该怎么做？请帮忙

Answer 1

可以使用 System.Configuration.ConfigurationManager.ConnectionString 属性获取 .config 文件中定义的连接字符串的列表：

// Get the ConnectionStrings section.         
// This function uses the ConnectionStrings  
// property to read the connectionStrings 
// configuration section. 
public static void ReadConnectionStrings()
{
  // Get the ConnectionStrings collection.
  ConnectionStringSettingsCollection connections =
      ConfigurationManager.ConnectionStrings;
  if (connections.Count != 0)
  {
    Console.WriteLine();
    Console.WriteLine("Using ConnectionStrings property.");
    Console.WriteLine("Connection strings:");
    // Get the collection elements. 
    foreach (ConnectionStringSettings connection in 
      connections)
    {
      string name = connection.Name;
      string provider = connection.ProviderName;
      string connectionString = connection.ConnectionString;
      Console.WriteLine("Name:               {0}", 
        name);
      Console.WriteLine("Connection string:  {0}", 
        connectionString);
     Console.WriteLine("Provider:            {0}", 
        provider);
    }
  }
  else
  {
    Console.WriteLine();
    Console.WriteLine("No connection string is defined.");
    Console.WriteLine();
  }
}

请记住添加对程序集System.Configuration引用。