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)); }