DBProviderInfo.SupportsNullColumns Eigenschaft

  • Referenz

Definition

Namespace:
Microsoft.SqlServer.Dts.Runtime
Assembly:
Microsoft.SqlServer.ManagedDTS.dll

Gibt einen booleschen Wert zurück, der angibt, ob die Tabelle Nullspalten unterstützt. Dieses Feld ist schreibgeschützt.

public:
 property bool SupportsNullColumns { bool get(); };
public bool SupportsNullColumns { get; }
member this.SupportsNullColumns : bool
Public ReadOnly Property SupportsNullColumns As Boolean

Eigenschaftswert

Boolean

Ein boolescher Wert, der angibt, ob die Tabelle Nullspalten unterstützt. Ein Wert von true gibt an, dass Nullspalten unterstützt werden.

Beispiele

Im folgenden Beispiel werden die Eigenschaften der datenbankanbieter aufgelistet, die auf dem Computer verfügbar sind.

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

Beispielausgabe:

Description = MediaCatalogDB OLE DB Provider, Name = MediaCatalogDB OLE DB Provider, ParseName = {09E767A66-4481-4791-86A5-A739E5290E4C}

ProviderSubType =None, ProviderType = OleDb

SupportsNullColumns = True, UseFullTableName = True

Beschreibung = Microsoft OLE DB-Anbieter für SQL Server, Name = SQLOLEDB, ParseName = {0C7FF16C-38E3-11d0-97AB-00C04FC2AD98}

ProviderSubType =SqlServer, ProviderType = OleDb

SupportsNullColumns = True, UseFullTableName = True

Gilt für: