Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Integration of SQL Anywhere 16 into Visual Studio 2013

Hi

I'm trying to use Visual Studio 2013 to create an entity model with Entity Framework 6 and I just can't get the SQL Anywhere driver into list of drivers, so I can't choose it for connection. I tried to follow instructions from http://sqlanywhere-forum.sap.com/questions/22161/entity-framework-6-provider  and also from SQLA17 documentation as closely as possible - with no luck. Some details:

SQL Anywhere 16.0.0.2178, both 32-bit and 64-bit installed.

Visual Studio Express Edition Update 5

Entity Framework 6.1.3

Output from the run of SetupVSPackage.exe:

C:\Program Files\SQL Anywhere 16\Assembly\V4>SetupVSPackage.exe /i /v EF6

SQL Anywhere Package for Visual Studio .NET Setup Utility Version 16.0.0.21784

Copyright (c) 2015 SAP SE or an SAP affiliate company. All rights reserved.

Installing SQL Anywhere Package for Visual Studio 2010......

Succeeded

Replaced part of Web.config:

  <entityFramework>

  <defaultConnectionFactory type="iAnywhere.Data.SQLAnywhere.SAConnectionFactory, Sap.Data.SQLAnywhere.EF6, Version=16.0.0.21784, Culture=neutral, PublicKeyToken=f222fc4333e0d400">

  </defaultConnectionFactory>

    <providers>

      <provider invariantName="System.Data.SqlClient" type="System.Data.Entity.SqlServer.SqlProviderServices, EntityFramework.SqlServer" />

      <provider invariantName="iAnywhere.Data.SQLAnywhere" type="iAnywhere.Data.SQLAnywhere.SAProviderServices, iAnywhere.Data.SQLAnywhere.EF6, Version=16.0.0.21784, Culture=neutral, PublicKeyToken=f222fc4333e0d400" />

    </providers>

  </entityFramework>

After all this, I still see only SQL Server drivers in the list when I try to add ADO.NET Entity Data Model.

Thanks in advance

Leonid Gvirtz

Tags:
Former Member
Not what you were looking for? View more on this topic or Ask a question