title: Return is an invalid expression term "return"
body: <p>I need to call this Stored Procedure but when I bring it into the .dbml is is being converted to resulting as ISingleResult. I am not sure how to properly call this with all of the parameters. This is my current code but I get an error when I "return result" saying "Invalid Expression term "return"" Any help is appreciated. Thank you.</p>
  
  <pre><code>public static int CreateNewTransferee(CreateTransferee model)
      {
          using (var db = new NJB.NJBDataContext())
          {
                  var result = db.SP_AddTransferee(
                  model.TransferEffectiveDate,
                  model.TransfereeName,
                  model.TransfereeNoticeAddressLine1,
                  model.TransfereeNoticeAddressLine2,
                  model.TransfereeNoticeCity,
                  model.TransfereeNoticeState,
                  model.TransfereeNoticeZip,
                  model.TransfereeNoticePhone,
                  model.TransfereePaymentAddressLine1,
                  model.TransfereePaymentAddressLine2,
                  model.TransfereePaymentCity,
                  model.TransfereePaymentState,
                  model.TransfereePaymentZip,
                  model.TransfereePaymentPhone,
  
              return (int) result.ReturnValue;
          }
      }
  </code></pre>
  
  <p>Update: Here is the SP:</p>
  
  <pre><code> ALTER PROCEDURE [dbo].[SP_AddTransferee] 
  -- Add the parameters for the stored procedure here
  @TransferEffectiveDate datetime,
  @TransfereeName varchar(50),
  @TransfereeNoticeAddressLine1 varchar(50),
  @TransfereeNoticeAddressLine2 varchar(50),
  @TransfereeNoticeCity varchar(50),
  @TransfereeNoticeState varchar(2),
  @TransfereeNoticeZip varchar(12),
  @TransfereeNoticePhone varchar(50),
  @TransfereePaymentAddressLine1 varchar(50),
  @TransfereePaymentAddressLine2 varchar(50),
  @TransfereePaymentCity varchar(50),
  @TransfereePaymentState varchar(50),
  @TransfereePaymentZip varchar(50),
  @TransfereePaymentPhone varchar(50)
  
  AS
  BEGIN
  -- SET NOCOUNT ON added to prevent extra result sets from
  -- interfering with SELECT statements.
  SET NOCOUNT ON;
  
  -- Insert statements for procedure here
  INSERT INTO TransfereeList
  VALUES (@TransferEffectiveDate, @TransfereeName, @TransfereeNoticeAddressLine1, @TransfereeNoticeAddressLine2,
      @TransfereeNoticeCity, @TransfereeNoticeState, @TransfereeNoticeZip, @TransfereeNoticePhone, 
      @TransfereePaymentAddressLine1, @TransfereePaymentAddressLine2, 
      @TransfereePaymentCity, @TransfereePaymentState, @TransfereePaymentZip, @TransfereePaymentPhone);
  
  SELECT SCOPE_IDENTITY();
  </code></pre>
  
  <p>END</p>