DBProviderInfo.ProviderType Properti
Definisi
Penting
Beberapa informasi terkait produk prarilis yang dapat diubah secara signifikan sebelum dirilis. Microsoft tidak memberikan jaminan, tersirat maupun tersurat, sehubungan dengan informasi yang diberikan di sini.
DTSProviderType Mengembalikan enumerasi yang menjelaskan jenis penyedia dalam hal penyedia menjadi penyedia sumber atau tujuan. Bidang ini hanya-baca.
public:
property Microsoft::SqlServer::Dts::Runtime::DTSProviderType ProviderType { Microsoft::SqlServer::Dts::Runtime::DTSProviderType get(); };
public Microsoft.SqlServer.Dts.Runtime.DTSProviderType ProviderType { get; }
member this.ProviderType : Microsoft.SqlServer.Dts.Runtime.DTSProviderType
Public ReadOnly Property ProviderType As DTSProviderType
Nilai Properti
Enumerasi DTSProviderType .
Contoh
Contoh berikut menghitung properti penyedia database yang tersedia di komputer.
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