Export (0) Print
Expand All

SqlClientFactory.CreateDataSourceEnumerator Method

Returns a new SqlDataSourceEnumerator.

Namespace:  System.Data.SqlClient
Assembly:  System.Data (in System.Data.dll)

public override DbDataSourceEnumerator CreateDataSourceEnumerator()

Return Value

Type: System.Data.Common.DbDataSourceEnumerator
A new data source enumerator.

The following example displays a list of all available SQL Server data sources, using code that could enumerate data sources for any provider.

using System;
using System.Data;
using System.Data.Common;
using System.Data.SqlClient;

class Program
{
    static void Main()
    {
        // List all SQL Server instances:
        ListServers(SqlClientFactory.Instance);

        Console.WriteLine();
        Console.WriteLine("Press any key to continue...");
        Console.ReadKey();
    }
    private static void ListServers(DbProviderFactory factory)
    {
        // This procedure is provider-agnostic, and can list 
        // instances of any provider's servers. Of course,  
        // not all providers can create a data source enumerator, 
        // so it's best to check the CanCreateDataSourceEnumerator  
        // property before attempting to list the data sources. 
        if (factory.CanCreateDataSourceEnumerator)
        {
            DbDataSourceEnumerator instance =
                factory.CreateDataSourceEnumerator();
            DataTable table = instance.GetDataSources();

            foreach (DataRow row in table.Rows)
            {
                Console.WriteLine("{0}\\{1}",
                    row["ServerName"], row["InstanceName"]);
            }
        }
    }
}

.NET Framework

Supported in: 4.6, 4.5, 4, 3.5, 3.0, 2.0

.NET Framework Client Profile

Supported in: 4, 3.5 SP1
Show:
© 2015 Microsoft