DBProviderInfo.SupportsNullColumns Properti

Definisi

Ruang nama:

Microsoft.SqlServer.Dts.Runtime

Rakitan:

Microsoft.SqlServer.ManagedDTS.dll

Mengembalikan Boolean yang menunjukkan apakah tabel mendukung kolom null. Bidang ini hanya-baca.

public:
 property bool SupportsNullColumns { bool get(); };

public bool SupportsNullColumns { get; }

member this.SupportsNullColumns : bool

Public ReadOnly Property SupportsNullColumns As Boolean

Nilai Properti

Boolean

Boolean yang menunjukkan apakah tabel mendukung kolom null. Nilai true menunjukkan bahwa kolom null didukung.

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