How to connect a API database connection in unit test project?

Question

I am new for unit testing. I have created test method in unit testing project. In that test method I called API method for testing . API method connected with database. When i run unit test project getting "No connection found" error. Test method always getting failure.

Please suggest you solution. Please find my code

TestCase:

[TestMethod] 
public void ValidateCheckInCheckOut_Test2() 
{ 
    int task_id = 0; 
    var userToken = "dsdjs2"; 
    Object response = new Object (); 
    var actual = class.GetValidationResponse(task_id, userToken); Assert.AreNotEqual(actual.GetType(), response.GetType());
}

API method:

public void GetValidationResponse(int taskid , string userToken) 
{ 
    using(var context = new DbContext()) 
    { 
        Some logic......
    } 
}

You need to solve that error. Without seeing your code that's the only suggestion we can give. Why your unit test calls actual API? Also why unit tests connects to actual database? — Chetan
– Chetan, Commented Oct 4, 2017 at 5:18
Please find my code TestCase: [TestMethod] public void ValidateCheckInCheckOut_Test2() { int task_id = 0; var userToken = "dsdjs2"; Object response = new Object (); var actual = class.GetValidationResponse(task_id, userToken); Assert.AreNotEqual(actual.GetType(), response.GetType()); } API method: public void GetValidationResponse(int taskid , string userToken) { using(var context = new DbContext()) { Some logic...... } } — Gopal
– Gopal, Commented Oct 4, 2017 at 5:20

Ipsit Gaur · Accepted Answer · 2017-10-04 05:31:34Z

1

As far as your unit tests are concerned, they should not be calling your actual API or your database rather the service calls should be mocked to get the desired result for the unit tests.

But for your question about no connection found, if you are using connection string for your API then you also need to add that connection string in App.config of the Unit test project to access the database through the connection string.

answered Oct 4, 2017 at 5:31

Ipsit Gaur

2,9472 gold badges26 silver badges38 bronze badges

Sign up to request clarification or add additional context in comments.

7 Comments

Ipsit Gaur Over a year ago

Can you please share code how are you accessing database connection string in API(not in unit test project)

Gopal Over a year ago

public void GetValidationResponse(int taskid , string userToken) { using(var context = new newEntities()) { Some logic...... } }

Ipsit Gaur Over a year ago

You must be having the connection string for your database in Web.config, please copy paste that and use it in your unit test's App.config then you can write same code to access database in the unit test project as well.

Gopal Over a year ago

you mean, have to write same logic code in unit test what i written in API. am i right?

Ipsit Gaur Over a year ago

No, if you will call GetValidationResponse method from your unit test project, it will run well. which in case you need to do from your unit tests.

|

Collectives™ on Stack Overflow

How to connect a API database connection in unit test project?

1 Answer 1

7 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

7 Comments

Your Answer

Sign up or log in

Post as a guest

Related