Please be aware that the SAP SQL Anywhere Forum will be shut down on August 29th, 2024 when all it's content will be migrated to the SAP Community.

The SQL Anywhere database contains Tables, Views and Stored procedures. Creating a new Entity Framework Data Model (Add, new item, ADO.NET Entity Data Model, generated model from the database) the list of possible database objects contains only the Tables and Views. No Stored procedures can be selected in the Entity Framework import dialog, there aren't there!!

In the Visual Studio 2010 Server Explorer all Tables, Views and Stored procedures(!!) are shown. So it should work for EF as well. Both connections are using the same Data source ".Net Framework Data Provider for SQL Anywhere 12", Server name, Database name etc.

Does anyone have the same problem or a clue? I use SQL Anywhere developer edition version

Note: I tried the same with SQL Server..... no problem (but thats not the production database).


asked 01 Oct '12, 09:38

Hans's gravatar image

accept rate: 0%

edited 09 Oct '12, 07:39

I also downgraded the Entity Framework version to 4.X.... The result keeps the same.

Does anyone use Stored Procedures in combination with EF and SQL Anywhere? Do you get Stored Procedure results at the import?


(09 Oct '12, 10:49) Hans

A suggestion I heard yesterday was that I can probably add the Stored Procedures manually in the EF edmx file. I only have to check if the provider can work with (and find) the Stored Procedures if the context needs an CUD action by the SP. I have not yet tried this.....

(10 Oct '12, 05:13) Hans
Be the first one to answer this question!
toggle preview

Follow this question

By Email:

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



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "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:


question asked: 01 Oct '12, 09:38

question was seen: 4,192 times

last updated: 10 Oct '12, 05:13