I still have trouble conceptualizing how to write unit tests for data access.
That's an integration test, really, not a unit test.
What I do is set up data sets of VFP tables or SQL Server and then zip\unzip the one that applies to the test, as part of the test.