public List <Dictionary <string, dynamic> > GetData(string tableName)
{
var queryStrings = HttpContext.Request.Query;
SqlDBConnection sql = new SqlDBConnection(ConnectionString);
return(Utils.ConvertTodictionary(sql.GetData(tableName)));
}
public static DBConnection GetDBConnection(string ConnectionString)
{
DBConnection dBConnection = null;
var providerName = System.Configuration.ConfigurationManager.ConnectionStrings[ConnectionString].ProviderName;
switch (providerName)
{
case "Oracle.DataAccess.Client":
dBConnection = new OracleDBConnection(ConnectionString);
break;
case "System.Data.SqlClient":
dBConnection = new SqlDBConnection(ConnectionString);
break;
default:
break;
}
return(dBConnection);
}
public List <Dictionary <string, dynamic> > GetAllData(string tableName)
{
SqlDBConnection sql = new SqlDBConnection(ConnectionString);
return(Utils.ConvertTodictionary(sql.GetData(tableName)));
}
public IEnumerable <TableMeta> GetColumns(string tableName)
{
SqlDBConnection sql = new SqlDBConnection(ConnectionString);
return(sql.GetColumns(tableName));
}
public IEnumerable <DatabaseMeta> GetTables()
{
SqlDBConnection sql = new SqlDBConnection(ConnectionString);
return(sql.GetTables());
}
