Upgrading EF to 6 with SQL Anywhere 17. Edmx giving invalid cast exception

entity-framework-5 entity-framework-6 sqlanywhere

Question

I am upgrading from EF 5 to EF 6. Previously I was using SQL Anywhere 12, and now I am using SQL Anywhere 17. I upgraded EF version, upgraded SQL anywhere version, but when I build, I get this error

Unable to cast object of type 'Sap.Data.SQLAnywhere.SAProviderServices' to type 'System.Data.Common.DbProviderServices'.

I have followed this tutorial

http://dcx.sap.com/index.html#sqla170/en/html/37fb9e8558e94547b66156b9298be16f.html

I installed SQL Anywhere provider which is required by EF 6. It is integrated to VS. I can make a connection using server explorer. But my edmx is not working fine. I removed my existing edmx and created a new one. But I still get this error. How to fix this error?

1
2
8/4/2015 9:46:06 AM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Popular Answer

Please note that this is the XML given on the link http://dcx.sap.com/index.html#sqla170/en/html/37fb9e8558e94547b66156b9298be16f.html

  <system.data>      
      <DbProviderFactories>
          <clear />
          <add name="SQL Anywhere 17 Data Provider" invariant="Sap.Data.SQLAnywhere" description=".Net Framework Data Provider for SQL Anywhere 17" type="Sap.Data.SQLAnywhere.SAFactory, Sap.Data.SQLAnywhere.EF6, Version=17.0.0.10094, Culture=neutral, PublicKeyToken=f222fc4333e0d400" />
      </DbProviderFactories>
  </system.data>
  <entityFramework>
    <defaultConnectionFactory type="Sap.Data.SQLAnywhere.SAConnectionFactory, Sap.Data.SQLAnywhere.EF6, Version=17.0.0.10094, Culture=neutral, PublicKeyToken=f222fc4333e0d400">
    </defaultConnectionFactory>
    <providers>
        <provider invariantName="Sap.Data.SQLAnywhere" type="Sap.Data.SQLAnywhere.SAProviderServices, Sap.Data.SQLAnywhere.EF6, Version=17.0.0.10094, Culture=neutral, PublicKeyToken=f222fc4333e0d400" />
    </providers>
  </entityFramework>

In my case, to resolve the exception I found that I had to change it to this when you open the *.edmx file and choose "Update Model from Database...":

https://ibb.co/kOhapv enter image description here

Next, pick to create a New Connection:

https://ibb.co/cq7Qpv enter image description here

Then, choose your data source:

http://ibb.co/iXaOba enter image description here

After you perform these, steps, Visual Studio will update your app.config for you:

  <system.data>  
    <DbProviderFactories>
      <remove invariant="Sap.Data.SQLAnywhere" />
      <add name="SQL Anywhere 17 Data Provider" invariant="Sap.Data.SQLAnywhere" description=".Net Framework Data Provider for SQL Anywhere 17" type="Sap.Data.SQLAnywhere.SAFactory, Sap.Data.SQLAnywhere.EF6, Version=17.0.7.33824, Culture=neutral, PublicKeyToken=f222fc4333e0d400" />
    </DbProviderFactories>
  </system.data>
  <entityFramework>
    <defaultConnectionFactory type="Sap.Data.SQLAnywhere.SAConnectionFactory, EntityFramework" />
    <providers>
      <provider invariantName="Sap.Data.SQLAnywhere" type="Sap.Data.SQLAnywhere.SAProviderServices, Sap.Data.SQLAnywhere.EF6, Version=17.0.7.33824, Culture=neutral, PublicKeyToken=f222fc4333e0d400" />
    </providers>
  </entityFramework>
0
8/15/2017 10:10:29 PM

Related Questions

Using multiple edmx file vs. one large edmx file?

I'm going to go against the grain here. I've built 2 large applications with EF now, one with a single edmx and one with several. There are pros and cons but generally I found life to be much easier with one edmx. The reason is that there is almost never a real separation of domains within an app, even if there appears to be from the start. New req...
ado.net-entity-data-model entity-framework
asked by Mindstorm Interactive

Upgrade EF 4 EDMX to EF 6

In addition to the answers given here by Rand Random and Dean Oliver, let me mention the following ...MSDN link..., describing general steps ...for upgrading to EF6.... Don't underestimate the manual steps required......The road map is (see details in the link given above):...Preparation:... Install the ...Entity Framework 6 Tools for Visual Studio...
entity-framework entity-framework-4 entity-framework-6
asked by Matt

Cast() exception: LINQ to Entities only supports casting EDM primitive or enumeration types

Enumerable.Cast<TResult>... is trying to cast every element in the collection. And it fails in your scenario (no surprise) because you are trying to cast instances of ...parent... (...AIM.Police.DB.CriminalEvent...) class to objects of ...child... (...InvestigationSimulator.Models.CriminalEvent...) class. You cannot do such casting in C#....In orde...
asp.net-mvc c# casting entity-framework linq-to-entities
asked by SergeyS

exception after upgrade ASP.NET Identity to 2.0

You need to disable the schema consistency by doing what the error says. This is one time thing that happens when you upgrade from version 1.0 to 2.0....public ApplicationDbContext() : base("MyConnection", throwIfV1Schema:false) ...Next step - do the migrations. ...Everything should work after that and you can remove this ...throwIfV1Schema:false..
asp.net asp.net-identity asp.net-identity-2 entity-framework
asked by dima

Why does EF 6.01 not give me a DbEntityValidationException Exception?

This exception you're getting is coming directly from SQL, being passed through Entity Framework. From MSDN about ...DbEntityValidationException...:...Represents an exception thrown from SaveChanges() when the ...validation of entities fails.......(emphasis my own). The validation from Entity Framework is passing, but the actual SQL statement is fa...
entity-framework-6 sqlexception
asked by Steven V

Entity framework throwing invalid operation exception - Connection string in app.config not found

If you are using ...DbContext... from referencing Projects, you also need to register the connection string on the project configuration file. ...For example, if you are using the ...DbContext... on a web project, check if the connection string is on the web.config.
c# entity-framework entity-framework-6
asked by hendryanw

Sqlite and EntityFramework 6 Invalid cast on SqlConnection to EntityConnection

After a couple of hours and differents errors I just find the solution (or at least make it work for the moment)..."Just" change the providerName of the ConnectionString from System.Data.SQLite to System.Data.EntityClient on the app.config file....Hope this works for the next guy who face similar problems.
entity-framework-6 sqlite
asked by Nekeniehl

Effort (EF6) exception when accessing DbSet (The given key was not present in the dictionary)

I'm having the exact problem. Turned out it was because I was using the SQL geography data type in some of my SQL 2014 database tables, and effort ...doesn't support this data type..., and there are no plans to add support for it at the moment either, which leaves me in a real quandry as I can't find any other in-memory database provider for EF6 wh...
.net effort entity-framework entity-framework-6 linq
asked by Breeno

Enable-Migrations gives Exception calling "SetData" with "2" argument(s) error

Reading ...this SO post... suggested that maybe some project types may not be compatible with EF 6 migrations. So, instead of using a class library project type of ".NET standard" for the DataAccess project, I tried using the ".NET framework" project type for the DataAccess class library project (where the DbContext is defined). Migrations worked f...
entity-framework entity-framework-6 visual-studio-2017
asked by Manish

EF6 - Invalid cast from decimal to int32

If you want to use ...NUMERIC(2)... then you need a ...decimal... model property otherwise you will see the conversion errors that you report. So your solution is to change the database or change your model....However, ...NUMERIC(2)... is overkill for your purpose and will consume 5 bytes where you only want numbers up to 99. Instead you should con...
c# entity-framework entity-framework-6
asked by DavidG

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow