>The SQLDataAdapter is for use with SQL Server. You can continue to use the OleDBDataAdapter with SQL Server. It will go through OLEDB (COM) to access SQL Server and will not perform as well as the SQLDataAdapter.

So, if I want to have maximum performance, there is no global data class I can have. I better continue to use the OleDBDataAdapter for VFP backend and do another one for SQLDataAdapter for SQL Server.