public DatabaseList GetDatabaseList(GetDatabasesRequest request)
{
const string query = "SELECT name FROM sys.databases;";
var dbRequest = new CommonDbRequest
{
Connection = ResolveConnectionWithCache(request.Connection),
CommandText = query
};
return(SqlHelper.DoQueryOperation <CommonDbRequest, DatabaseList>(dbRequest, (req, response, reader) =>
{
var databaseList = new List <string>();
while (reader.Read())
{
var name = reader.GetValue(0).ToString();
databaseList.Add(name);
}
response.Databases = databaseList;
//response.State = ResponseState.Success;
}));
}
public TableList GetTableList(GetTablesRequest request)
{
const string query = "SELECT table_name from INFORMATION_SCHEMA.tables;";
request.Connection.Database = request.Database;
var dbRequest = new CommonDbRequest
{
Connection = ResolveConnectionWithCache(request.Connection),
CommandText = query
};
return(SqlHelper.DoQueryOperation <CommonDbRequest, TableList>(dbRequest, (req, response, reader) =>
{
var tableList = new List <string>();
while (reader.Read())
{
var name = reader.GetValue(0).ToString();
tableList.Add(name);
}
response.Tables = tableList;
}));
}