>See Calvin's blog for a very exciting message (at least to me) about how to interop between .NET and VFP. This technique will let me do something I need. May be old news to many here, but to me it's pure gold.


Hi Alex.

And don't forget some techniques we can use with StrataFrame.
We create a database that only contains local views of the VFP tables. In the views we change field names and add field triggers if needed. For example, if we have a character field that a “P” represents a primary insurance company and an “S” represents a secondary we add a new integer field that is an enum value in .NET.

The second step is to create a faux table, that matches the view precisely, in the DatabaseToolkit to be used in the BO mapper. Eventually it will be deployed to SQL server. All forms are created in .NET and use SF BOs.
I know that the guys have also created a class that converts SQL syntax to VFP OLEDB syntax.