Last post Apr 02, 2013 01:00 AM by shoeb_aspnetcoder
Apr 02, 2013 01:00 AM|shoeb_aspnetcoder|LINK
This is my first post in ASP.NET forums. Pretty excited!
The problem: I created my tables and then generated the model. After that I created some stored procedures and then updated my model by rightclicking the model diagram and then selecting "Update Model from Database"
In the next dialouge box I then select my new stored procedure. But some stored procedures are not being generated in my model. (I cannot see them under Function Imports in the Model Browser.). Even if I generate the model one more time, no success.
For stored procedure I get this error when generating model:
An exception of type 'MySql.Data.MySqlClient.MySqlException' occured while attempting to update from the database. The exception message is 'No data - zero rows fetched, selected or processed'.
Funny thing is I tested the stored procedure from MySQL workbench. The stored procedure works as expected.