title: Stored procedure - Operand type clash: smallint is incompatible with uniqueidentifier
body: <p>I'm trying to get a dropdownlist of users and <code>value (userD)</code> but have issues getting the <code>UserID</code> value returned in json, instead of real <code>user id value</code></p>
  
  <p>I get
  <code>&lt;option value="00000000-0000-0000-0000-000000000000"&gt;Test User1&lt;/option&gt;
  &lt;option value="00000000-0000-0000-0000-000000000000"&gt;Test User2&lt;/option&gt;</code></p>
  
  <p>followed by the 
  <em>Operand type clash: smallint is incompatible with uniqueidentifier</em> <strong>error</strong> in my console</p>
  
  <p><strong>Here is my stored procedure</strong> </p>
  
  <pre><code> USE [DojoDB]
      GO
      SET ANSI_NULLS ON
      GO
      SET QUOTED_IDENTIFIER ON
      GO
  
      ALTER PROC [dbo].[rpGetUsers]  
      AS
          BEGIN  
      SELECT [UserID] AS ID,
            [UserFirstname] ,[UserSurname] 
  
        FROM [DojoDB].[dbo].[System_User]
  
           END 
  </code></pre>
  
  <p><strong>Here is my class</strong>    </p>
  
  <pre><code>public class rpusers
      {
          public Guid UserID { get; set; }
          public string UserFirstname { get; set; }
          public string UserSurname { get; set; }
          public string FullName {
  
              get { return UserFirstname + " " + UserSurname; }
  
          }
          public int InstanceID { get; set; }
          public int IsDeleted { get; set; }
          public List&lt;rpusers&gt; rpusersList { get; set; }
          public List&lt;rpusersRecord&gt; rpusersRecordList { get; set; }
      }
  </code></pre>
  
  <p><strong>HTML</strong></p>
  
  <pre><code>@Html.DropDownListFor(m =&gt; m.FullName, new SelectList(Model.rpusersList, "UserID", "FullName"), new
  </code></pre>
  
  <p><strong>Controller</strong></p>
  
  <pre><code>public ActionResult rpusersChart()
      {
          rpusers objrpusers = new rpusers();
          rpusersAction objRusersAction = new rpusersAction();
          try
          {
              objrpusers.rpusersList = objRusersAction.GetrpusersDetails();
              return View("~/Views/rpusers/rpusersChart.cshtml", objrpusers);
          }
          catch (Exception ex)
          {
              throw;
          }
      }
  </code></pre>