Sql anywhere integration with visual studio to add new entity framework model(.edmx)

Former Member — Thu, 21 Jul 2016 17:04:04 GMT

I want to connect to sql anywhere database from visual studio entity framework.I am not able to add .edmx file i do not have correct info about entity framework connection details we give in web.config.For example the details for sql anywhere 16 are <entityframework> <defaultconnectionfactory type="iAnywhere.Data.SQLAnywhere.SAProviderServices, iAnywhere.Data.SQLAnywhere.EF6"></defaultconnectionfactory> <providers> <provider invariantname="iAnywhere.Data.SQLAnywhere" type="iAnywhere.Data.SQLAnywhere.SAProviderServices, iAnywhere.Data.SQLAnywhere.EF6, Version=16.0.0.20434, Culture=neutral, PublicKeyToken=f222fc4333e0d400"/> </providers> </entityframework>

Can anybody please provide me the details for sql anywhere 17 driver,specially the provider name.

Re: Sql anywhere integration with visual studio to add new entity framework model(.edmx)

Former Member — Thu, 21 Jul 2016 17:23:44 GMT

Examples of what the app.config file should look like can be found at the bottom of any of the 4 DCX articles with titles like

"{Model|Code|Database} First to a[n] {new|existing} Database"

including this Database First one; usually found in step #6 (#5 in one case).

Do note that the provider and component names now begin with 'SAP.'. As before, you will also need to adjust the version and build inforamtion to match what you have installed.

Question Re: Sql anywhere integration with visual studio to add new entity framework model(.edmx) in Technology Q&A

Sql anywhere integration with visual studio to add new entity framework model(.edmx)

Re: Sql anywhere integration with visual studio to add new entity framework model(.edmx)