升级路径Windows窗体/企业库/ SQL Server / Access数据库 [英] Upgrade Path Windows Forms / Enterprise Library / SQL Server / Access DB

问题描述

我们目前支持在vb.Net上构建的Windows Forms应用程序（最初于2005年，目前在VS2017中运行），通过Enterprise Library 5.0访问SQL Server数据库，并使用OLEDB将数据导出到Access ACCDB。  我们在我们的环境中禁用了TLS1.0 / SSL，因此我们希望从OLEDB Access转移。 在禁用TLS1.0 / SSL的情况下，SQL似乎没问题。 此外，不再支持企业库。 我正在寻找有关升级的建议，而不确定
将走向何方。 

We currently support a Windows Forms application that is built (originally in 2005, currently functioning in VS2017) on vb.Net accessing a SQL Server Database through Enterprise Library 5.0 and also exports data to an Access ACCDB using OLEDB.  We are disabling TLS1.0/SSL in our environment so we'd like to move from OLEDB Access.  SQL seems to be fine with TLS1.0/SSL disabled.  Additionally, Enterprise Library is no longer supported.  I'm looking for recommendations on upgrading and not sure what direction to go. 

• 我们是否从Enterprise Library迁移到EF6或EFCore或??
• 我们为SQL数据访问构建了对象类，所以我应该只使用System.Data.SQLClient
  
  
• 我们是否应该使用Enterprise Library，因为它基本上可以工作（使用数据和日志记录）
• 我们使用OLEDB的数据集功能可以有效地将数据从SQL Server传输到Access，当我们从OLEDB移动时可以使用哪些选项

我愿意赶上阅读，但坦率地说，互联网搜索没有提供指示或保证我们正在采取适当的步骤使我们及时更新并为下一章的发展做好准备。 谢谢！

I'm willing to catch up with reading but frankly internet searches have not provided the direction or assurance that we're taking the appropriate steps to bring us up-to-date and prepared for the next chapter of development.  Thank you!

推荐答案

您好，

如果一切正常，我会说'然后没有令人信服的理由离开这个图书馆。

I would say if everything is working 'as is' then there is no compelling reason to move away from this library.

离开企业库的唯一原因是当您遇到障碍时，库无法有效地执行任务，这是一个双刃剑，例如考虑使用Entity Framework 6或更高版本（EF Core），乍一看它很容易学习
但是为了让'事情'正确并且了解EF的细微差别，架构以及EF如何与表单控件交互可能需要时间主。从那个（或一个团队）需要问'这个解决方案的EF是否合适？'

The only reason to move away from the Enterprise library is when you run into roadblocks were the library does not do task efficiently which is a double edge sword e.g. consider using Entity Framework 6 or above (EF Core), at first glance it's easy to learn but to get 'things' right and learn the nuances of EF, architecture and how EF interacts with form controls can take time to master. From that one (or a team) needs to ask 'is EF right for this solution?'

如果您使用Entity Framework并使用DataGridView控件，请务必查看此

sortable BindingList 组件，因为没有它你不能排序。

If you do go with Entity Framework and work with DataGridView controls be sure to check out this sortable BindingList component as without it you can't sort.

这篇关于升级路径Windows窗体/企业库/ SQL Server / Access数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！