public IEnumerable<ViewInfo> GetViews(FbConnection con)
{
using (var command = con.CreateCommand())
{
command.CommandText = @"select trim(rdb$relation_name) AS Name, rdb$view_source Source from rdb$relations where rdb$relation_type = 1 and rdb$system_flag = 0 order by rdb$relation_name asc";
var reader = command.ExecuteReader();
while (reader.Read())
{
yield return new ViewInfo((string)reader["Name"], ((string)reader["Source"]).Trim(' ', '\r', '\n'));
}
}
}