public List <T> ExecuteSelectObject <T>(string sql) where T : new()
{
List <T> lst = new List <T>();
var rows = ExecuteSelect(sql);
foreach (var el in rows)
{
T ob = new T();
CMySQLConnector.FillClassFields <T>(el, ob);
lst.Add(ob);
}
return(lst);
}
public List <T> ExecuteSelectObjectProcedureName <T>(string procedure, Dictionary <string, object> paramList = null) where T : new()
{
List <T> lst = new List <T>();
var rows = ExecuteProcedure(procedure, paramList);
foreach (var el in rows)
{
T ob = new T();
CMySQLConnector.FillClassFields <T>(el, ob);
lst.Add(ob);
}
return(lst);
}
public CDBSynchronizer(string fromHost, string fromDB, string fromUser, string fromPassword,
string toHost, string toDB, string toUser, string toPassword,
IClientDatabaseConnector dbClient,
IAlarmable alarmer)
{
_conFrom = new CMySQLConnector(fromHost, fromDB, fromUser, fromPassword, alarmer, dbClient);
_conTo = new CMySQLConnector(toHost, toDB, toUser, toPassword, alarmer, dbClient);
_conFrom.Connect();
_conFrom.GenTablesSchemas();
_conTo.Connect();
_conTo.GenTablesSchemas();
}
public CMySQLProcedureBuilder(string procedure, CMySQLConnector mySQLConnector)
{
_mySQLConnector = mySQLConnector;
_command = new MySqlCommand(procedure, _mySQLConnector.Connection);
_command.CommandType = CommandType.StoredProcedure;
}
