DBProviderInfo.UseFullTableName 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.
Mengembalikan Boolean yang menunjukkan apakah penyedia dapat menggunakan nama tabel dalam bentuk database_name.owner_name.table_name atau schema_name.owner_name.table_name.
public:
property bool UseFullTableName { bool get(); };
public bool UseFullTableName { get; }
member this.UseFullTableName : bool
Public ReadOnly Property UseFullTableName As Boolean
Nilai Properti
Boolean yang menunjukkan apakah penyedia dapat membaca nama tabel yang diberikan dalam format database_name.owner_name.table_name.
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