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!
Printable View
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!
The cons are that it is a ridiculous idea - no offense. :)
SQL *exists* to manipulate data. Bypassing that to do it in VB is simply ludicrous. They should keep their resumes up-to-date.
Sorry,
- Chris