Using VS 2010 and sql server 2005 express edition, i have created an EF model and imported some table into it using the wizard.
I have written a stored procedure in the same database and opened the "Update model from database" wizard - but for some reason, my SP is not there.
I have restarted VS and SQL server, and it didn't do the trick.
finally, i downloaded anklab sql profiler and started a trace, found the query the EF wizard is running to get the SP names from the DB - and when I run it in the sql server management studio express - I can see my SP name!
I don't really know what i'm doing wrong. can someone please help me?