Moq testing void methods with out parameters

Question

Hi Please let me know how to write the moq unit test case for the below method.Any help would be appreciated .Thanks in advance.

public void ConstructAddMappingQuery(IAnnotationMapping annotationMappings, 
                                     out string commandText, 
                                     out Dictionary<string, dynamic> parameters)
{
   commandText =@"Insert Into AnnotationMapping Values 
                 (@AnnotationSetupId, @WordToAnnotate, 
                  @Annotation, @CreatedDttm, @CreatedUserId, @ModifiedDate, 
                  @ModifiedUserId, @IsActive)";

   parameters = new Dictionary<string, dynamic>();
   parameters.Add("@WordToAnnotate", annotationMappings.WordToAnnotate);
   parameters.Add("@Annotation", annotationMappings.Annotation);
   parameters.Add("@ModifiedDate", annotationMappings.ModifiedDate);
   parameters.Add("@ModifiedUserId", annotationMappings.ModifiedUserId);
   parameters.Add("@AnnotationSetupId", annotationMappings.AnnotationSetupId);
   parameters.Add("@CreatedDttm", annotationMappings.CreatedDttm);
   parameters.Add("@CreatedUserId", annotationMappings.CreatedUserId);
   parameters.Add("@IsActive", 1);
}

Looking for the whole method not the stub.Cheers!!!!!!!!!!!!

Please edit you question first, check this: http://stackoverflow.com/help/formatting — neohope, Sep 02 '16 at 05:06
Does this work for you : http://stackoverflow.com/a/3135677 ? — Zein Makki, Sep 02 '16 at 05:08
Please [edit] your post to clarify what particular help you are looking for and what you want to test. In current state this is next level of "write code for me" request (usually such request at least have information on what should be done...) — Alexei Levenkov, Sep 02 '16 at 05:29
Possible duplicate of [Assigning out/ref parameters in Moq](http://stackoverflow.com/questions/1068095/assigning-out-ref-parameters-in-moq) — Dovydas Šopa, Sep 02 '16 at 06:35
I have to increase the code coverage of my project as of now these set of statements are not covered — NAVANEETHAN V, Sep 06 '16 at 06:08

Nkosi · Answer 1 · 2016-09-02T05:41:02.567

Assuming a class like

public class AnnotationMappingQueryBuilder {
    public void ConstructAddMappingQuery(IAnnotationMapping annotationMappings,
                                 out string commandText,
                                 out Dictionary<string, dynamic> parameters) {
        commandText = @"Insert Into AnnotationMapping Values 
             (@AnnotationSetupId, @WordToAnnotate, 
              @Annotation, @CreatedDttm, @CreatedUserId, @ModifiedDate, 
              @ModifiedUserId, @IsActive)";

        parameters = new Dictionary<string, dynamic>();
        parameters.Add("@WordToAnnotate", annotationMappings.WordToAnnotate);
        parameters.Add("@Annotation", annotationMappings.Annotation);
        parameters.Add("@ModifiedDate", annotationMappings.ModifiedDate);
        parameters.Add("@ModifiedUserId", annotationMappings.ModifiedUserId);
        parameters.Add("@AnnotationSetupId", annotationMappings.AnnotationSetupId);
        parameters.Add("@CreatedDttm", annotationMappings.CreatedDttm);
        parameters.Add("@CreatedUserId", annotationMappings.CreatedUserId);
        parameters.Add("@IsActive", 1);
    }
}

You will only need Moq for the interface. A test could look like this.

[TestClass]
public class UnitTest1 {
    [TestMethod]
    public void TestMethod1() {

        //Arrange
        var mock = Mock.Of<IAnnotationMapping>();

        var expectedCommandText = @"Insert Into AnnotationMapping Values 
             (@AnnotationSetupId, @WordToAnnotate, 
              @Annotation, @CreatedDttm, @CreatedUserId, @ModifiedDate, 
              @ModifiedUserId, @IsActive)";
        string commandText = null;
        Dictionary<string, dynamic> parameters = null;
        int expectedParameterCount = 8;
        var sut = new AnnotationMappingQueryBuilder();

        //Act
        sut.ConstructAddMappingQuery(mock, out commandText, out parameters);

        //Assert
        Assert.IsNotNull(commandText);
        Assert.AreEqual(expectedCommandText, commandText);

        Assert.IsNotNull(parameters);
        Assert.AreEqual(expectedParameterCount, parameters.Count);
        ///what ever else you want to assert for parameters
    }
}

Moq testing void methods with out parameters

1 Answers1