I can map my business object to Visual Foxpro database table. How can I map the business object to Visual Foxpro remote view?

I will like to add on the above. What we are trying to achieve is enable our app in Strataframe to support current and new version releases of the main app. Future releases may require newly added of fields and changed field names. So we are figuring whether possible to use remote view or cursoradapter where we only need to change this for future releases...

I cannot see the view and romote view of my foxpro database when using business object mapper. I only see the tables. Did I made any mistake?

No, within the .NET DbConnection.GetSchema() method, the SQL Server connection returns views as if they were tables, so you can easily map a business object to a view in SQL Server.  However, it is more difficult to map a business object to a view in FoxPro.  I will test to determine if it is possible at all and let you know.

I can connect to foxpro local view using OLEDB connection string in Visual Studio .Net. For example, my connection string is "Provider=VFPOLEDB.1;Data Source=C:\data\test1.DBC". How to use StrataFrame business object mapper connect to foxpro local view?

We are working on this as we speak.  There is an issue with the OLE DB provider giving us the views.  We will let you know as soon as we have a fix.  Sorry for any trouble.

Was this addressed, I am unable to see VFP views. Thanks.

Keith Chisarik

I would assume so....that was a long time ago!!!



I will have to set this up as I honestly haven't tried this in a very long time.