Our developers want to retrieve simple datasets from our SQL Server database and execute joins in Visual Basic, instead of using SQL (or T-SQL to do the joins on the database.

What are the pros and cons of this approach?

Thanks!