/// <summary> /// /// </summary> /// <param name="name">used to display and search</param> /// <param name="type"></param> /// <param name="connectionString"></param> /// <returns></returns> private static ConnectionProvider RegisterOleDb(string name, ConnectionProviderType type, string connectionString) { ConnectionProvider pvd = new OleDbConnectionProvider(name, type, connectionString); ConnectionProviderManager.Register(pvd); return(pvd); }
/// <summary> /// /// </summary> /// <param name="name">used to display and search</param> /// <param name="type"></param> /// <param name="connectionString"></param> /// <returns></returns> private static ConnectionProvider RegisterOleDb(string name, ConnectionProviderType type, string connectionString) { ConnectionProvider pvd = new OleDbConnectionProvider(name, type, connectionString); ConnectionProviderManager.Register(pvd); return pvd; }
public static ConnectionProvider Register(string serverName, string connectionString) { DbConnectionStringBuilder conn = new DbConnectionStringBuilder(); conn.ConnectionString = connectionString.ToLower(); string providerName = "sqldb"; object value; if (conn.TryGetValue("provider", out value)) { if (value is string) providerName = (string)value; } ConnectionProvider pvd = null; switch (providerName) { case "xmlfile": pvd = new XmlDbConnectionProvider(serverName, connectionString); break; case "riadb": //Remote Invoke Agent pvd = new RiaDbConnectionProvider(serverName, connectionString); break; case "Microsoft.ACE.OLEDB.12.0": //Excel 2010 case "Microsoft.Jet.OLEDB.4.0": //Excel 2007 or Access case "MySqlProv": //MySql case "MSDAORA": //Oracle case "sqloledb": pvd = new OleDbConnectionProvider(serverName, connectionString); break; case "sqldb": //Sql Server pvd = new SqlDbConnectionProvider(serverName, connectionString); break; } if (pvd != null) Register(pvd); else throw new Exception($"invlaid connection string {connectionString}"); return pvd; }