|
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 |
Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.
Follow this question
By Email:Once you sign in you will be able to subscribe for any updates here
By RSS:Markdown Basics
- *italic* or _italic_
- **bold** or __bold__
- link:[text](http://url.com/ "title")
- image?
- 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,083 times
last updated: 10 Oct '12, 05:13
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
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.....