DBProviderInfo.ProviderSubType Propriété

Définition

Espace de noms:

Microsoft.SqlServer.Dts.Runtime

Assembly:

Microsoft.SqlServer.ManagedDTS.dll

Retourne une valeur de l'énumération DTSProviderSubType qui décrit le type de fournisseur. Ce champ est en lecture seule.

public:
 property Microsoft::SqlServer::Dts::Runtime::DTSProviderSubType ProviderSubType { Microsoft::SqlServer::Dts::Runtime::DTSProviderSubType get(); };

public Microsoft.SqlServer.Dts.Runtime.DTSProviderSubType ProviderSubType { get; }

member this.ProviderSubType : Microsoft.SqlServer.Dts.Runtime.DTSProviderSubType

Public ReadOnly Property ProviderSubType As DTSProviderSubType

Valeur de propriété

DTSProviderSubType

Valeur d'énumération DTSProviderSubType.

Exemples

L’exemple suivant énumère les propriétés des fournisseurs de base de données disponibles sur l’ordinateur.

namespace dbproviderinfo  
{  
    class Program  
    {  
        static void Main(string[] args)  
        {  
            Application app = new Application();  
            DBProviderInfos dbis = app.DBProviderInfos;  
            foreach (DBProviderInfo dbi in dbis)  
            {  
                Console.WriteLine("Description = {0}, Name = {1}, ParseName = {2}", dbi.Description, dbi.Name, dbi.ParseName);  
                Console.WriteLine("ProviderSubType ={0}, ProviderType = {1}", dbi.ProviderSubType, dbi.ProviderType);  
                Console.WriteLine("SupportsNullColumns = {0}, UseFullTableName = {1}", dbi.SupportsNullColumns, dbi.UseFullTableName);  
            }  
        }  
    }  
}  

Namespace dbproviderinfo  
    Class Program  
        Shared  Sub Main(ByVal args() As String)  
            Dim app As Application =  New Application()   
            Dim dbis As DBProviderInfos =  app.DBProviderInfos   
            Dim dbi As DBProviderInfo  
            For Each dbi In dbis  
                Console.WriteLine("Description = {0}, Name = {1}, ParseName = {2}", dbi.Description, dbi.Name, dbi.ParseName)  
                Console.WriteLine("ProviderSubType ={0}, ProviderType = {1}", dbi.ProviderSubType, dbi.ProviderType)  
                Console.WriteLine("SupportsNullColumns = {0}, UseFullTableName = {1}", dbi.SupportsNullColumns, dbi.UseFullTableName)  
            Next  
        End Sub  
    End Class  
End Namespace  

Exemple de sortie :

Description = Fournisseur OLE DB MediaCatalogDB, Nom = Fournisseur OLE DB MediaCatalogDB, ParseName = {09E767A6-4481-4791-86A5-A739E5290E4C}

ProviderSubType =None, ProviderType = OleDb

SupportsNullColumns = True, UseFullTableName = True

Description = Fournisseur Microsoft OLE DB pour SQL Server, Name = SQLOLEDB, ParseName = {0C7FF16C-38E3-11d0-97AB-00C04FC2AD98}

ProviderSubType =SqlServer, ProviderType = OleDb

SupportsNullColumns = True, UseFullTableName = True