DTSProviderType Enum

Definisi

Ruang nama:

Microsoft.SqlServer.Dts.Runtime

Rakitan:

Microsoft.SqlServer.ManagedDTS.dll

Menjelaskan jenis penyedia yang disimpan.

public enum class DTSProviderType

public enum DTSProviderType

type DTSProviderType = 

Public Enum DTSProviderType

Warisan

Enum

DTSProviderType

Bidang

Nama	Nilai	Deskripsi
DtsDestination	-4	Penyedia adalah tujuan.
DtsSource	-3	Penyedia adalah sumber data.
Odbc	-2	Penyedia adalah penyedia ODBC.
OleDb	-1	Penyedia adalah penyedia OLEDB.
Unknown	0	Penyedia berjenis tidak dikenal.

Contoh

Contoh berikut menghitung properti penyedia database yang tersedia di komputer termasuk DTSProviderType.

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  

Contoh output:

Deskripsi = Penyedia MediaCatalogDB OLE DB, Nama = Penyedia MediaCatalogDB OLE DB, ParseName = {09e767A6-4481-4791-86A5-A739e5290e4c}

ProviderSubType =None, ProviderType = OleDb

SupportsNullColumns = True, UseFullTableName = True

Deskripsi = Penyedia Microsoft OLE DB untuk SQL Server, Nama = SQLOLEDB, ParseName = {0C7FF16C-38E3-11d0-97AB-00C04FC2AD98}

ProviderSubType =SqlServer, ProviderType = OleDb

SupportsNullColumns = True, UseFullTableName = True

Keterangan

Enumerasi ini digunakan oleh DBProviderInfo kelas , di ProviderType properti , untuk menunjukkan jenis penyedia kelas yang dikandung.