The new OLE DB provide will work correctly with the CommandBuilder when it is released. It will not support the Data Wizards that you can use with SQL Server but at least it will help create the Update/Insert/Delete statements.

>I have seen numerous posts regarding VFP oledb's driver and it's lack of
>schema information. I have also read info on people who have tried manually
>defining the primary key for command builder but still failed. There still seems like there in no easy way to update a Foxpro Table in Dotnet
>
>I have 100+ dbf files, I cant be manually writing update, Insert and Delete
>routines for all the dbf(s). It seems to me that if I can point to the primary key, or manually define the schema then the rest of the Ado.net's auto SQL generation puzzle should work.
>
>I have successfully used ADO 2.6 with foxpro tables under VB6 with no
>problems. The recordsets knew how to update the data, why does ado.net only support these "Disconnected" recordsets.
>
>Where is the VFP team in providing a newer driver. I expected VFP8 would of solved the schema problem.
>
>Am I missing something?
>
>Thanks in advance.
>Mike Pisano