在Visual Studio中的C# .net 5程序中,我正在测试使用SqlDataSourceEnumerator的代码。
public static List<SqlServerInstance> LocateSqlInstances()
{
List<SqlServerInstance> results = new List<SqlServerInstance>();
using (DataTable sqlSources = SqlDataSourceEnumerator.Instance.GetDataSources())
{
foreach (DataRow source in sqlSources.Rows)
{
string servername;
string instancename = source["InstanceName"].ToString();
if (!string.IsNullOrEmpty(instancename))
{
servername = source["ServerName"].ToString() + '\\' + instancename;
}
else
{
servername = source["ServerName"].ToString();
}
results.Add(new SqlServerInstance() { ServerInstance = servername, Version = source["Version"].ToString() });
}
}
return results;
}
尽管我使用了System.Data;,但我遇到了以下错误:
Error CS0103 The name 'SqlDataSourceEnumerator' does not exist in the current context
为什么会发生这种情况?
using System.Data.Sql;
? SqlDataSourceEnumerator 类 - user12031933