如何使用实体框架从SQL Server实例获取数据库名称列表? [英] How to get a list of database names from a SQL Server instance using Entity Framework?
本文介绍了如何使用实体框架从SQL Server实例获取数据库名称列表?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我想使用实体框架(EF)查询SQL Server实例并返回该实例上的数据库名称列表.
I would like to use Entity Framework (EF) to query a SQL Server instance and return a list of database names on that instance.
我可以使用以下代码来执行此操作,但想知道EF是否有办法?
I can do this using the following code, but wondered if there was a way with EF?
public static string[] GetDatabaseNames(SqlConnection masterConn)
{
List<string> databases = new List<string>();
// retrieve the name of all the databases from the sysdatabases table
using (SqlCommand cmd = new SqlCommand("SELECT [name] FROM sysdatabases", masterConn))
{
using (SqlDataReader rdr = cmd.ExecuteReader())
{
while (rdr.Read())
{
databases.Add((string)rdr["name"]);
}
}
}
return databases.ToArray();
}
我应该提到我是EF及其功能/限制的新手.
I should mention that I am new to EF and its capabilities / limitations.
推荐答案
您可以简单地通过Entity Framework将原始查询发送到SQL Server:
You could simply send a raw query to your SQL Server through Entity Framework :
using (var context = new MyContext())
{
var dbNames = context.Database.SqlQuery<string>(
"SELECT name FROM master.dbo.sysdatabases").ToList();
}
来源: https://msdn.microsoft.com/en-us/library/jj592907(v = vs.113).aspx 和 https://stackoverflow.com/a/147662/2699126
这篇关于如何使用实体框架从SQL Server实例获取数据库名称列表?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文