.NET中的Visual FoxPro数据
我们正在将旧的VFP应用程序迁移到带有SQL Server的.NET WPF应用程序中。 在此过程中，我们仍然需要读/写入DBF文件，以使我们的业务正常工作。
为此，我们使用可用的标准OLEDB适配器。但是，我们的Sysadmin询问我们是否有访问DBF文件的替代方法。 从网络/安全性角度来看，让每个用户连接到文件不是最佳选择。特别是从家中通过VPN连接时。
我已经尝试通过通过API公开数据将连接移动到单个服务器。但这太放慢了应用程序。在某些情况下，我们通过后台作业（Hangfire实施）同步数据。但这可能很耗时。
在迁移VFP应用程序时，是否有人使用其他任何技术来做类似的事情？
We are in the process of migrating an old VFP application into a .NET WPF application with SQL server.
During the process we still need to read/write to the DBF files to keep our business working properly.
To do this, we use the standard OLEDB adapter that is available. However, our sysadmin is asking if we have an alternative way to access the DBF files.
Having each user connect to the files is not the best option from a network/security perspective. Specially when connecting from home through a VPN.
I've already tried to move the connection to a single server by exposing the data through an API. But that was slowing down the application too much. In some situations we synchronise the data through background jobs (Hangfire implementation). But this can be time consuming to implement.
Has anybody used any other techniques to do something similar while migrating a VFP application?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
OLEDB仍然是最好的选择。在应用程序中，您可以模仿具有访问文件的特定用户。
Sybase Advantage服务器也可以连接并使用VFP数据文件。本地模式为免费，服务器模式已付费。您也可以尝试检查一下。
OLEDB is still the best option. Within the application, you could impersonate a specific user that has access to files.
Also Sybase Advantage Server can connect and work with VFP data files. Local mode is (was) for free and server mode paid. You might try checking that too.
在单个PC上找到数据作为服务器。通过RDP访问 - 可用于支持多个连接的Kludges。通过连接VPN-然后将RDP连接到需要时，请提高安全性。
Locate data on single PC as server. Access via RDP - kludges available to support multiple connections. Increase security if needed by connecting over VPN - then RDP.