VS2017中首先使用EF6 SqlAnywhere提供程序的数据库 [英] Database first with EF6 SqlAnywhere provider in VS2017
问题描述
已经按照SAP网站文档中的建议安装了SQLAnywhere 17的开发人员版本，并且手动运行了此安装程序提供的VS集成安装程序，除了MSSQL之外，我仍然看不到其他任何提供程序在Visual Studio 2017中创建EF6模型时.
Having already followed the advice in the SAP website documentation and installed the developer edition of SQLAnywhere 17, and also having manually run the installer for VS integration that is provided by this installation I still could not see any providers other than the MSSQL ones while creating an EF6 model in Visual Studio 2017.
我找到了这个 https://www.nuget. org/packages/Sap.Data.SQLAnywhere.EF6/17.0.7.3399
有人知道在哪里可以找到如何使用它的文档吗? Nuget没有提供文档链接，也没有列出存储库.
Does anyone know where to find documentation on how to use it? Nuget provides no links to documentation and does not list a repo.
我安装该软件包时没有发生任何意外，它出现在项目引用中，但是当我尝试创建EF模型时，它没有出现在提供程序列表中.
I installed the package without incident and it appears in project references but it does not appear in the provider list when I try to create an EF model.
对包装作者的请求激起了此回应:
A request to the package author provoked this response:
彼得，
有关信息和文档，请访问: https://sqlanywhere-forum.sap.com/
For information and documentation go to: https://sqlanywhere-forum.sap.com/
or with SyBase http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc01776.1604/doc/html/san1357754863708.html
亲切的问候，欧文·巴克尔(Erwin Bakels)
Kind Regards, Erwin Bakels
虽然我感谢您的及时响应，但文档链接会提供有关使用其他版本执行其他操作的信息-EF4.3用于代码优先，而EF6用于库，我需要数据库优先.为了公平起见，我没有明确告诉他我要数据库优先，但这仍然不是一个有用的答案.
While I appreciate the prompt response, the documentation link leads to information about doing another thing with a different version -- it's for code-first with EF4.3 while the library is for EF6 and I need database-first. To be fair to Erwin, I didn't explicitly tell him I wanted database-first, but it's still not a usable answer.
进一步的研究表明，VS2017中的更改会阻止安装程序正确注册提供程序.这意味着在SAP更新安装程序以使其适合VS2017之前，设计人员不可能通过SQL Anywhere支持EF.
Further research suggests that changes in VS2017 prevent the installer from registering the provider correctly. This implies that until such time as SAP updates the installer to suit VS2017 there is no possibility of designer support for EF with SQL Anywhere.
推荐答案
我已确认具有SAP支持，VS2017不支持将SQL Anywhere ADO.NET与Visual Studio集成.您将必须使用VS2015或更早版本.
I have confirmed with SAP support, that Sql Anywhere ADO.NET integration with Visual Studio is not supported in VS2017. You will have to use VS2015 or earlier.
这篇关于VS2017中首先使用EF6 SqlAnywhere提供程序的数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
