public List<string> GetAllBySystem(ConnexionSysteme sys)
{
var liste = new List<string>();
try
{
//construire le Connector
if (sys.ServerType.Equals("MSSQLSERVER"))
{
Connector = new MSSQLConnecctor(sys.CnxHelper);
}
var cnx = Connector.GetConnection();
var cmd = cnx.CreateCommand();
cmd.CommandText = "SELECT name FROM sys.views";
cnx.Open();
var dr = cmd.ExecuteReader();
while (dr.Read())
{
liste.Add(dr[0].ToString());
}
cnx.Close();
}
catch (Exception)
{}
return liste;
}
public static DbConnector GetConenctorByProvider(string provider)
{
DbConnector connector = null;
switch (provider.ToLower())
{
case "mssqlserver":
connector = new MSSQLConnecctor(new ConnectionHelper());
break;
case "oracle":
connector = new OracleConnector(new ConnectionHelper());
break;
}
return(connector);
}
