I am planning an app that is to have a .NET front end and a VFP back end, and have many questions. :)

1) Let's say the .NET front end makes a call to a stored procedure in the DBC through OleDB and the stored procedure performs a SQL SELECT. Does the SELECT command get executed in the machine with the DBC or in the client machine? In other words does all the data needed for the SELECT get transferred to the client machine or only the result set?

2) I would like to use the VFP back end as a calculator for the front end with tables remaining open in the back end from one call to the next. The .NET app would make a call to stored procedure via OleDb. The stored procedure then opens an app (if not already open) and passes the requested command as well as id of calling session. VFP app then figures out which datasession to select, performs call and returns result, leaving tables open ready for next call.

Is this feasible? I would appreciate comments.

TIA,

Alex