private DbConnection GetConnection(Entitron.Entity.Nexus.ExtDB row)
{
switch (row.DB_Type)
{
case Entitron.Entity.Nexus.ExtDBType.MySQL:
{
string cs = string.Format("Server={0}; Port={1}; Database={2}; Uid={3}; Pwd={4}; SslMode=Preferred;",
row.DB_Server, row.DB_Port, row.DB_Name, row.DB_User, row.DB_Password
);
DbConnection conn = new MySql.Data.MySqlClient.MySqlConnection(cs);
return(conn);
}
case Entitron.Entity.Nexus.ExtDBType.MSSQL:
{
string cs = string.Format("Server={0};Database={1};User Id={2};Password={3};",
row.DB_Server, row.DB_Name, row.DB_User, row.DB_Password
);
DbConnection conn = new System.Data.SqlClient.SqlConnection(cs);
return(conn);
}
default: {
throw new Exception("Formát connection stringu nebyl nalezen");
}
}
}
private void Connect(Entitron.Entity.Nexus.ExtDB info)
{
dbName = info.DB_Name;
c = r.Connection()
.Hostname(info.DB_Server)
.Port(Convert.ToInt32(info.DB_Port))
.Timeout(60)
.Connect();
}
public NexusExtDBRethingService(int extDBId)
{
var context = COREobject.i.Context;
Entitron.Entity.Nexus.ExtDB info = context.ExtDBs.Where(d => d.Id == extDBId).SingleOrDefault();
if (info == null)
{
throw new Exception("Nexus RethinkDB service: Cannot connect to database. Integration is not defined.");
}
Connect(info);
}
public ExtDB(string serverName, string dbName)
{
DBEntities e = COREobject.i.Context;
Entitron.Entity.Nexus.ExtDB row = e.ExtDBs.Single(m => m.DB_Server == serverName && m.DB_Alias == dbName);
if (row == null)
{
throw new Exception(string.Format("Konfigurace pro server {0} a databázi {1} nebyla nalezena", serverName, dbName));
}
DbConnection conn = GetConnection(row);
conn.Open();
db = new Database(conn);
}
public NexusExtDBRethingService(Entitron.Entity.Nexus.ExtDB info)
{
Connect(info);
}
