public static string GetSourceDisplayName(
IServiceProvider serviceProvider,
IVsDataSource dataSource)
{
string displayName = null;
string resourceId = null;
Guid provider = dataSource.DefaultProvider;
if (provider != Guid.Empty)
{
resourceId = dataSource.GetProperty(provider, "DisplayName") as string;
}
if (resourceId == null)
{
foreach (Guid providerId in dataSource.GetProviders())
{
resourceId = dataSource.GetProperty(
providerId, "DisplayName") as string;
if (resourceId != null)
{
provider = providerId;
break;
}
}
}
if (provider != Guid.Empty && resourceId != null)
{
IVsDataProviderManager providerManager = serviceProvider.GetService(
typeof(IVsDataProviderManager)) as IVsDataProviderManager;
IVsDataProvider dataProvider = providerManager.Providers[provider];
displayName = dataProvider.GetString(resourceId);
}
return(displayName);
}
internal static bool DDEXProviderIsInstalled(Guid id)
{
IVsDataProvider provider = null;
var objIVsDataProviderManager = SqlCeToolboxPackage.GetGlobalService(typeof(IVsDataProviderManager)) as IVsDataProviderManager;
return(objIVsDataProviderManager.Providers.TryGetValue(id, out provider));
}
public static Stream GetProviderString(IVsDataProvider provider,
string resourceName, string assemblyString)
{
Assembly assembly = provider.GetAssembly(assemblyString);
return(assembly.GetManifestResourceStream(resourceName));
}
public static IVsDataObjectSelector CreateObjectSelector(
IVsDataProvider provider, string objectSelectorTypeName)
{
Type objectSelectorType = provider.GetType(objectSelectorTypeName);
return(Activator.CreateInstance(objectSelectorType)
as IVsDataObjectSelector);
}
public static bool AllowDelete(IVsDataProvider provider,
IVsDataExplorerNode node)
{
if (!provider.IsOperationSupported(StandardCommands.Delete, node))
{
MessageBox.Show(provider.GetUnsupportedReason(
StandardCommands.Delete, node));
return(false);
}
return(true);
}
public static void Example(
IVsDataProvider provider)
{
Guid source1 = provider.DeriveSource("Provider=SQLOLEDB.1");
Trace.WriteLine(source1); // MSSqlServerDataSource
Guid source2 = provider.DeriveSource(
"Provider=Microsoft.Jet.OLEDB.4.0");
Trace.WriteLine(source2); // MSAccessDBFileDataSource
}
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 void OutputSupportingProviders(
IServiceProvider serviceProvider,
IVsDataSource dataSource)
{
IVsDataProviderManager providerManager =
serviceProvider.GetService(typeof(IVsDataProviderManager))
as IVsDataProviderManager;
foreach (Guid providerGuid in dataSource.GetProviders())
{
IVsDataProvider provider = providerManager.Providers[providerGuid];
Trace.WriteLine(provider.Name);
}
}
internal static IVsDataProvider GetVsProvider(IVsDataProviderManager dataProviderManager, IVsDataConnection dataConnection)
{
if (dataConnection == null)
{
throw new ArgumentNullException("dataConnection");
}
IVsDataProvider vsDataProvider = null;
dataProviderManager.Providers.TryGetValue(dataConnection.Provider, out vsDataProvider);
Debug.Assert(
vsDataProvider != null, "Data provider identified by guid '{0}' could not be loaded" + dataConnection.Provider.ToString());
return(vsDataProvider);
}
public static IVsDataConnectionProperties CreateConnectionProperties(
IVsDataProvider provider)
{
IVsDataConnectionProperties connProperties = null;
try
{
connProperties = provider.CreateObject <IVsDataConnectionProperties>();
}
catch (DataProviderException e)
{
MessageBox.Show(e.Message);
}
return(connProperties);
}
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);
}
public static void UseDataProvider(
IServiceProvider serviceProvider,
Guid providerGuid)
{
IVsDataProviderManager providerManager =
serviceProvider.GetService(typeof(IVsDataProviderManager))
as IVsDataProviderManager;
IVsDataProvider provider = providerManager.Providers[providerGuid];
Trace.WriteLine(provider.DisplayName);
Trace.WriteLine(provider.Description);
IVsDataConnectionProperties connectionProperties =
provider.CreateObject <IVsDataConnectionProperties>();
connectionProperties.Parse("Test connection string");
}
public static void OutputDataSource(
IServiceProvider serviceProvider,
Guid dataSourceGuid)
{
IVsDataSourceManager sourceManager =
serviceProvider.GetService(typeof(IVsDataSourceManager))
as IVsDataSourceManager;
IVsDataSource source = sourceManager.Sources[dataSourceGuid];
Trace.WriteLine(source.DisplayName);
Trace.WriteLine(source.Description);
IVsDataProviderManager providerManager =
serviceProvider.GetService(typeof(IVsDataProviderManager))
as IVsDataProviderManager;
foreach (Guid providerGuid in source.GetProviders())
{
IVsDataProvider provider = providerManager.Providers[providerGuid];
Trace.WriteLine(provider.Name);
}
}
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);
}
public static IVsDataConnectionProperties CreateConnectionProperties(
IVsDataProvider provider)
{
return(provider.TryCreateObject <IVsDataConnectionProperties>());
}
public static bool HasSpecialConnectForUI(
IVsDataProvider provider, Guid source)
{
return(provider.SupportsObject(
source, typeof(IVsDataConnectionUIConnector)));
}
