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.

asked 21 Jul '16, 17:04

madhukar's gravatar image

madhukar
11224
accept rate: 0%

edited 21 Jul '16, 17:06


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.

permanent link

answered 21 Jul '16, 17:23

Nick%20Elson%20SAP%20SQL%20Anywhere's gravatar image

Nick Elson S...
7.3k35107
accept rate: 31%

edited 22 Jul '16, 08:52

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×85
×65
×2

question asked: 21 Jul '16, 17:04

question was seen: 511 times

last updated: 22 Jul '16, 08:52