Unit Testing in MVC not creating/accessing database

Question

I have a solution with an MVC project containing a Services project on top of a Core project.

I just added a Unit Tests project and referenced Core and Services - I'm trying to test Services.

I have a basic call in the test:

public class CrudTests
    {
        private readonly SetServices _setService = new SetServices();

        [TestMethod]
        public void TestMethod()
        {
            _setService.CreateSet("Test Set", "Test Set Details", null);

Which ends up failing because the test can't connect to a database. My config has this:

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
  <connectionStrings>
    <add name="DefaultConnection" connectionString="Data Source=.\;Initial Catalog=Project.Services.Tests;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|\Project.Services.Tests.mdf" providerName="System.Data.SqlClient" />
  </connectionStrings>
</configuration>

I've tried by creating the database Project.Services.Tests and then running, but I get this:

Message=Database 'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\App.Services.Tests.mdf' already exists. Choose a different database name. Cannot attach the file 'C:\PROJECTS\App\App\Services.Tests\bin\Debug\Services.Tests.mdf' as database 'App.Services.Tests'. Source=.Net SqlClient Data Provider ErrorCode=-2146232060 Class=16 LineNumber=65536 Number=1801 Procedure="" Server=.\ State=2 StackTrace:

I tried deleting the database and letting the test do it's thing, and I get this:

A file activation error occurred. The physical file name '\Project.Services.Tests.mdf' may be incorrect. Diagnose and correct additional errors, and retry the operation.

How can I get this working properly?

IMO Unit Test means Without DB interaction, You can use Fake or Mock to do Unit testing. If You Unit test with DB, then Your will test will be slow like tortoise :D — Ravi Gadag
– Ravi Gadag, Commented Feb 21, 2013 at 4:33

amirhosseinab · Accepted Answer · 2013-02-21 06:05:37Z

2

In Unit Testing you must test the code without any dependency such as database or file system etc. unit test means testing only that part of code independently. if you want to test your code by its integration to database you must create Integration Test. that means you should create an initializing for database usage before running test and a tear down for diposing resources after finishing tests.

maybe this link help you more to understand the difference between Unit Test and Integration Test

answered Feb 21, 2013 at 6:05

amirhosseinab

1,0602 gold badges16 silver badges29 bronze badges

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

3 Comments

RobVious Over a year ago

I'm just trying to learn one thing at a time here... unit testing with the database seems simpler - once I get that, I'll pull in mocks.

amirhosseinab Over a year ago

the simplicity is not matter in testing! you must do the right type of testing for each porpuse. but as I said, you can create initialize and tear down methods for runnig tests against database.

Aaron Newton Over a year ago

I see this answer a lot and I find it irritating - not because its wrong - but because the DAL is a layer in your application and should separate from the actual database implementation (and therefore unit-testable). One suggestion I have seen is to use an in-memory database (e.g. LocalDB or MDF) mocking the production schema but with a relatively low footprint - blogs.interknowlogy.com/2014/08/29/unit-testing-using-localdb

Mostafa · Accepted Answer · 2017-04-28 23:59:31Z

0

you should just fix the connection string and it should work, You are attaching the database file from |DataDirectory| of the test project,

answered Apr 28, 2017 at 23:59

Mostafa

88410 silver badges25 bronze badges

Collectives™ on Stack Overflow

Unit Testing in MVC not creating/accessing database

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related