I like to use stored procedures with optional parameters. I once wrote about it here.