public static string GetProviderTypeAsString(DataSourceProviderType DBProvider)
{
switch (DBProvider)
{
case DataSourceProviderType.SQLServer2000:
return("DataSourceProviderType.SQLServer2000");
case DataSourceProviderType.SQLServer2005:
return("DataSourceProviderType.SQLServer2005");
case DataSourceProviderType.SQLServer2008:
return("DataSourceProviderType.SQLServer2008");
case DataSourceProviderType.Oracle:
return("DataSourceProviderType.Oracle");
case DataSourceProviderType.MySQL:
return("DataSourceProviderType.MySQL");
case DataSourceProviderType.Paradox:
return("DataSourceProviderType.Paradox");
case DataSourceProviderType.Progress:
return("DataSourceProviderType.Progress");
case DataSourceProviderType.Informix:
return("DataSourceProviderType.Informix");
case DataSourceProviderType.AS400:
return("DataSourceProviderType.AS400");
default:
throw (new Exception("Invalid provider type"));
}
}
private DBDataSourceConnectionHandler(string DBServerName, string DataBaseName, string UserID, string userPassword, DataSourceProviderType DBProvider)
{
this._DBServerName = DBServerName;
this._DataBaseName = DataBaseName;
this._userID = UserID;
this._userPassword = userPassword;
this._DBProvider = DBProvider;
this._DBConnection = null;
this._DBConnection.InfoMessage += this._DBConnection_InfoMessage;
this._DBConnection.StateChange += this._DBConnection_StateChange;
}
public static string GetConnectionString(DataSourceProviderType DBProvider, string DBServerName, string DataBaseName, string UserID, string UserPassword)
{
string cnnString = "";
switch (DBProvider)
{
case DataSourceProviderType.SQLServer2000:
cnnString = "Provider=SQLOLEDB;Data Source=" + DBServerName + ";Initial Catalog=" + DataBaseName + ";User Id=" + UserID + "; Password="******";";
return(cnnString);
case DataSourceProviderType.SQLServer2005:
cnnString = "Provider=SQLNCLI;Server=" + DBServerName + ";Database=" + DataBaseName + ";Uid=" + UserID + "; Pwd=" + UserPassword + ";";
return(cnnString);
case DataSourceProviderType.SQLServer2008:
cnnString = "Provider=SQLNCLI10;Server=" + DBServerName + ";Database=" + DataBaseName + ";Uid=" + UserID + "; Pwd=" + UserPassword + ";";
return(cnnString);
case DataSourceProviderType.Oracle:
cnnString = "Provider=OraOLEDB.Oracle;Password="******";Persist Security Info=True;User ID=" + UserID + ";Data Source=" + DBServerName + ";";
return(cnnString);
case DataSourceProviderType.MySQL:
cnnString = "Provider=MySQLProv;Data Source=" + DBServerName + ";User Id=" + UserID + ";Password="******";";
return(cnnString);
case DataSourceProviderType.Informix:
cnnString = "";
return(cnnString);
case DataSourceProviderType.Paradox:
cnnString = "";
return(cnnString);
case DataSourceProviderType.Progress:
cnnString = "";
return(cnnString);
case DataSourceProviderType.AS400:
cnnString = "";
return(cnnString);
default:
return(null);
}
}
public static DBDataSourceConnectionHandler GetDedicatedConnectionHandler(string DBServerName, string DataBaseName, string UserID, string userPassword, DataSourceProviderType DBProvider)
{
DBDataSourceConnectionHandler handler = new DBDataSourceConnectionHandler(DBServerName, DataBaseName, UserID, userPassword, DBProvider);
return(handler);
}
public static DBDataSourceConnectionHandler GetSharedConnectionHandler(string DBServerName, string DataBaseName, string UserID, string userPassword, DataSourceProviderType DBProvider)
{
string cnnString = "";
//crates the datasourder connection string
cnnString = GetConnectionString(DBProvider, DBServerName, DataBaseName, UserID, userPassword);
//verifies if there is a connection that matches the connection string
DBDataSourceConnectionHandler handler = null;
lock (_sharedConnectionsTable)
{
if (_sharedConnectionsTable.ContainsKey(cnnString))
{
handler = (DataBaseLibrary.DBDataSourceConnectionHandler)(_sharedConnectionsTable[cnnString]);
}
else
{
handler = new DBDataSourceConnectionHandler(DBServerName, DataBaseName, UserID, userPassword, DBProvider);
_sharedConnectionsTable.Add(cnnString, handler);
}
}
return(handler);
}
public void ResetDefaults()
{
SelectedProvider = DataSourceProviderType.Register;
}
private object FindProvider(DataSourceProviderType value)
{
return(DataProviderEdit.Items.Cast <DataProviderItem>().FirstOrDefault(i => i.Value == value));
}
private void AddProvider(string name, DataSourceProviderType value)
{
DataProviderEdit.Items.Add(new DataProviderItem {
Name = name, Value = value
});
}
