public IDbCommandResult Execute(string command)
{
try
{
_dbConnection.Open();
var query = new SchemaQuery(command);
var schema = GetSchemaFrom(query);
var result = new QueryResult();
foreach (DataColumn column in schema.Columns)
{
if (query.SelectAll || query.ColumnNames.Contains(column.ColumnName.ToLowerInvariant()))
{
result.AddColumn(column.ColumnName, column.DataType);
}
}
foreach (DataRow row in schema.Rows)
{
result.AddRow(row.ItemArray);
}
return result;
}
finally
{
_dbConnection.Close();
}
}
public IDbCommandResult Execute(string command)
{
try
{
_dbConnection.Open();
var query = new SchemaQuery(command);
var schema = GetSchemaFrom(query);
var result = new QueryResult();
foreach (DataColumn column in schema.Columns)
{
if (query.SelectAll || query.ColumnNames.Contains(column.ColumnName.ToLowerInvariant()))
{
result.AddColumn(column.ColumnName, column.DataType);
}
}
foreach (DataRow row in schema.Rows)
{
result.AddRow(row.ItemArray);
}
return(result);
}
finally
{
_dbConnection.Close();
}
}
private DataTable GetSchemaFrom(SchemaQuery query)
{
return query.HasNoCollectionName
? _dbConnection.GetSchema()
: _dbConnection.GetSchema(query.CollectionName);
}
private DataTable GetSchemaFrom(SchemaQuery query)
{
return(query.HasNoCollectionName
? _dbConnection.GetSchema()
: _dbConnection.GetSchema(query.CollectionName));
}