SqlClientFactory.CreateDataSourceEnumerator Metodo

Definizione

Restituisce un nuovo SqlDataSourceEnumerator oggetto .

public:
 override System::Data::Common::DbDataSourceEnumerator ^ CreateDataSourceEnumerator();
public override System.Data.Common.DbDataSourceEnumerator CreateDataSourceEnumerator ();
abstract member CreateDataSourceEnumerator : unit -> System.Data.Common.DbDataSourceEnumerator
override this.CreateDataSourceEnumerator : unit -> System.Data.Common.DbDataSourceEnumerator
override this.CreateDataSourceEnumerator : unit -> System.Data.Common.DbDataSourceEnumerator
Public Overrides Function CreateDataSourceEnumerator () As DbDataSourceEnumerator

Restituisce

Nuovo enumeratore di origine dati.

Esempio

Nell'esempio seguente viene visualizzato un elenco di tutte le origini dati disponibili SQL Server, usando codice che potrebbe enumerare le origini dati per qualsiasi provider.

// <Snippet1>
using System;
using System.Data;
using System.Data.Common;
using Microsoft.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"]);
            }
        }
    }
}
// </Snippet1>

Si applica a