StrataFrame Forum

Map business object to Visual Foxpro remote view

http://forum.strataframe.net/Topic1862.aspx

By Wang Tong Yin - 7/16/2006

I can map my business object to Visual Foxpro database table. How can I map the business object to Visual Foxpro remote view?
By Wang Tong Yin - 7/16/2006

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...
By Wang Tong Yin - 7/16/2006

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?
By StrataFrame Team - 7/17/2006

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.
By Wang Tong Yin - 7/18/2006

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?
By Trent L. Taylor - 7/18/2006

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.
By Keith Chisarik - 7/16/2009

Was this addressed, I am unable to see VFP views. Thanks.
By Trent L. Taylor - 7/16/2009

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



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