private static void InitializeDB()
{
var credentials = DBCredentials.ParseFromJsonFile(@"Resources\dbcredentials.json");
db = DBConnection.Instance();
db.SetDBCredentials(credentials);
}
private void Initialize(DBCredentials _credentials)
{
if (_credentials.Port <= 0)
{
_credentials.Port = 27017;
}
//TODO - Fix so uses ServiceCredentials
MongoCredential credential = MongoCredential.CreateCredential(_credentials.AuthenticationDBName,
_credentials.UserName,
_credentials.Password);
List <MongoServerAddress> serverAddresses = new List <MongoServerAddress>();
foreach (string serverName in _credentials.Servers)
{
MongoServerAddress msa = new MongoServerAddress(serverName, _credentials.Port);
serverAddresses.Add(msa);
}
MongoClientSettings mcs = new MongoClientSettings
{
Servers = serverAddresses,
Credentials = new[] { credential }
};
m_MongoClient = new MongoClient(mcs);
m_MongoServer = m_MongoClient.GetServer();
MongoDB = m_MongoServer.GetDatabase(_credentials.DBName);
}
public MySQL_DBManager(DBCredentials dBCredentials)
{
if (dBCredentials != null)
{
configDB(dBCredentials.Url, dBCredentials.DBName, dBCredentials.Login, dBCredentials.Password);
}
}
protected AbstractMongoManager(IEnumerable <string> _servers,
int _port,
string _userName,
string _password,
string _database)
{
DBCredentials credentials = new DBCredentials
{
Servers = _servers,
Port = _port,
UserName = _userName,
Password = _password,
DBName = _database
};
Initialize(credentials);
}
public static DBCredentials GetCredentials(string _name)
{
DBCredentials credentials = new DBCredentials();
string[] tempServers = Config.GetSettingValue(_name + "_DBServers", "localhost")
.Split(",".ToCharArray(), StringSplitOptions.RemoveEmptyEntries);
credentials.Servers = new List <string>(tempServers);
credentials.Port = Config.GetIntValue(_name + "_DBPort", 0);
credentials.DBName = Config.GetSettingValue(_name + "_DBName");
credentials.AuthenticationDBName = Config.GetSettingValue(_name + "_AuthDBName", "admin");
credentials.UseServiceCredentials = Config.GetBooleanValue(_name + "_UseServiceCredentials", true);
//TODO - Replace windows Authentication
//Can't store clear text passwords.
credentials.UserName = Config.GetSettingValue(_name + "_DBUser");
credentials.Password = Config.GetSettingValue(_name + "_DBPassword");
return(credentials);
}
public static DbConnection GetClientConnection(DBCredentials dbCredentials)
{
var dbConnectionString = "Data Source=" + dbCredentials.DBServer + "; Initial Catalog = " + dbCredentials.DBName + "; Persist Security Info = True; User ID = " + dbCredentials.DBUserId + "; Password = "******"; MultipleActiveResultSets = True; Application Name = EntityFramework";
// DbConnectionStringBuilder csb;
//var entityCnxStringBuilder = new EntityConnectionStringBuilder
//{
// ProviderConnectionString = new SqlConnectionStringBuilder(System.Configuration.ConfigurationManager
// .ConnectionStrings["PCROnBoard"].ConnectionString).ConnectionString
//};
//entityCnxStringBuilder.Provider = "System.Data.SqlClient";
//var sqlCnxStringBuilder = new SqlConnectionStringBuilder(entityCnxStringBuilder.ProviderConnectionString);
//csb = new DbConnectionStringBuilder { ConnectionString = sqlCnxStringBuilder.ConnectionString };
string providerName = "System.Data.SqlClient";
var factory = DbProviderFactories.GetFactory(providerName);
var dbConnection = factory.CreateConnection();
dbConnection.ConnectionString = dbConnectionString;
dbConnection.Open();
return(dbConnection);
}
protected AbstractMongoManager(DBCredentials _credentials)
{
Initialize(_credentials);
}
protected AbstractMongoManager(string _name)
{
DBCredentials credentials = CredentialHelper.GetCredentials(_name);
Initialize(credentials);
}
