The forum will experience an outage sometime between February 10 at 7:00pm EST and February 12 at 11:59 EST for installation of security updates. The actual time and duration of the outage are unknown but attempts will be made to minimize the downtime. We apologize for any inconvenience.

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 12.0.1.3769

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

Hans

asked 01 Oct '12, 09:38

Hans's gravatar image

Hans
46236
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?

Hans

(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

By RSS:

Answers

Answers and Comments

Markdown Basics

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

×162
×100
×64

question asked: 01 Oct '12, 09:38

question was seen: 2,340 times

last updated: 10 Oct '12, 05:13