I am building a simple Window Forms application that pulls data from a remote SQL DB.
I have been using SQLConnection with SQL data Adapter and SQL Commands to pull data from the DB via stored procedures instead of building SQL statements in the application.
Some of these SP are just select all statements, so i was thinking, it might be easier to use a view...
however, you cannot use a view with a SQL command.
I have been avoiding doing direct data binding to the form, is there a reason why I would be better off doing data binding to the form and using a SQL view rather than using the SP?
The view and the SP are running identical select statements.