public static string GetDisplayName(
IVsDataProvider provider)
{
string displayName = String.Empty;
string resourceId = provider.GetProperty("DisplayName") as string;
if (resourceId != null)
{
displayName = provider.GetString(resourceId);
}
return(displayName);
}
public static DbConnection CreateAdoDotNetConnection(
IVsDataProvider provider)
{
string invariantName = provider.GetProperty("InvariantName") as string;
if (invariantName != null)
{
DbProviderFactory factory = DbProviderFactories.GetFactory(
invariantName);
if (factory != null)
{
return(factory.CreateConnection());
}
}
return(null);
}
internal static string GetProviderInvariantName(IVsDataProviderManager dataProviderManager, Guid provider)
{
var invariantName = String.Empty;
IVsDataProvider dataProvider = null;
Debug.Assert(dataProviderManager != null, "_dataProviderManager is not initialized!");
if (dataProviderManager != null)
{
dataProviderManager.Providers.TryGetValue(provider, out dataProvider);
Debug.Assert(dataProvider != null, "Invalid provider Guid");
if (dataProvider != null)
{
invariantName = (string)dataProvider.GetProperty("InvariantName");
}
}
Debug.Assert(
!String.IsNullOrEmpty(invariantName),
"provider " + dataProvider != null ? dataProvider.DisplayName : "(null)" + " has a null InvariantName");
return(invariantName);
}