No errors are generated. However just loading the table does not work.
[Test]
public void TestDataConnectionFox()
{
Categories ct = new Categories();
DataTable dt = ct.GetAllData();
Assert.IsTrue(dt.Rows.Count > 0);
}

Looks like the DataAccess is not being generated for the FoxPro. For the Accounts table it generates Aaccont.cs, Aaccont.Partial.cs, AaccontEntity.cs, AaccontRules.cs, AaccontRules.Partial.cs for Fox, but for SQL server it adds a DataAccess.cs file.