.NET Entity Framework 6 and Model First with ASE

[Former Member]

Hello All,

We have an existing SAP ASE database that I am attempting to connect to using C# .NET, Entity Framework Model First methodology and I am having some trouble.

The first issue I had was after installing the SDK I faced an issue that the sybase ASE connector did not appear in the list of data sources when creating an ADO.NET entity model.

I resolved this issue by installing the SQL anywhere trial which then installed the connector (this really should be fixed).

Now I can appropriately create an entity model from the existing database.

Now my issue is I am receiving the following error when doing a simple Context.[TableName].ToList():

No Entity Framework provider found for the ADO.NET provider with invariant name 'Sybase.Data.AseClient'. Make sure the provider is registered in the 'entityFramework'

Is there an entityFramework provider for Sybase ASE? and if so what are the specifications supposed to be in the provider tag in the app.config?

Thank you for your help,

Dan

[dawn_kim · Accepted solution]

Hi Dan,

You need the SDK for SAP ASE to get the ado.net provider for ASE.

Please note that the ado.net driver isn't certified with EF 6 CR 765581.

We just recently got certified with Studio 2012. So if you install a more current version of the SDK like SDK for SAP ASE 15.7 SP127 and higher the installer should install in the correct places. To get the free SDK please follow this message: http://service.sap.com/sap/support/notes/2093510

If you using Studio 2013 there are step you need to do and manually add some information.

Thanks,
Dawn Kim

[Former Member · Accepted solution]

Hi Dawn,

Thank you for your help!

I just downgraded EF6 to EF4.1 and it seems to be working perfectly. I will use EF4.1 from now on in this project.

Thank you for your help.

Dan