I get the error:
Azure SQL Database: [SqlException (0x80131904): Could not find stored procedure
when I deploy my ASP.NET MVC application to azure. My database is an Azure SQL database.
The code runs fine in my development environment. The procedure belongs to a custom schema. Below is how I call the procedure from my code.
SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "[schema_name].[procedure_name]";
I think it might have to do with some schema permission. I took the connection string to connect my mvc application to DB from the azure protal.
I would really appreciate any help/direction.
User contributions licensed under CC BY-SA 3.0