且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

如何使用实体框架从SQL Server实例获取数据库名称列表?

更新时间:2023-02-04 09:45:10

您可以简单地通过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://***.com/a/147662/2699126