cancel
Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos
5,407

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.

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member

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.