Skip to Content
author's profile photo Former Member
Former Member

.NET Entity Framework 6 and Model First with ASE

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    Posted on Dec 16, 2014 at 10:03 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.