System.data.sqlclient.sqlexception: 'could not find stored procedure 'usp_getusername_by_userid'.'

See more:

ASP.NET

Hi Mates

I want to find do i need to create a store procedure for this table on my database? Currently i do not have, could this be the reason for this exception?

What I have tried:

public string GetUserName_By_UserID(string UserId)
       {
           using(SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["MyString"].ToString())) {

               var para = new DynamicParameters();
               para.Add("@UserId", UserId);
               return con.Query<string>("Usp_GetUserName_By_UserID", para, null, true, 0, CommandType.StoredProcedure).SingleOrDefault();
           }
       }