In mysql there is something like a selectable stored procedure, eg.

Begin
Select * from table x
where x.ID = @PARAM;
End

You can call this procedure via DOTNET, pass paremeters en fill a
dataset with it easily

What's the best option to choose for in an firebird 2.0 environment

1. Query with :PARAM?
But can pass parameters to a stored query via DOTNET?
2. Procedure
3. View (with parameters??? didn't find this)

I especially want to avoid the SELECT into statement which i found in
many blogs as i really need the select all (*) option

Miel