Entity Framework 6 - Knowledge Base (KB)

TDD and ADO.NET Entity Framework

I've been playing with ADO.NET Entity Framework lately, and I find that it suits my needs for a project I'm developing. I also find cool its non-invasive nature....After generating a data model from an existing database you are faced with the task of inte...

How should I set up my integration tests to use a test database with Entity Framework?

I am writing integration tests for an application and have not been able to find any best practices on how to set up a test database for my integration suite. I am working on an ASP.NET MVC4 application using Entity Framework code-first....I can confirm t...

Entity Framework Integration tests failing running multiple tests that are singularly passing [Resharper, NUnit, EF6]

I'm having an inconsistent behavior running Integration Test using Resharper 8.2, NUnit 2.6.4. Depending one how many test I select, sometime all passes and sometime just firsts and lasts. If instead I run each test singularly they all passes....In this p...

Using Effort (EF Testing Tool) with Computed Column

I have a number of integration tests which access the DB directly - create test prerequisite objects - performs the tests and then cleans up afterwards - however I wonted to try out the same approach in-memory....I have just used ...Effort... in my projec...

Integration tests - Setup data in database

I need to write integration tests for my layer that exposes methods of service. But I need my database to be in a certain state for the tests to pass...For example for testing the GetStoreByID method, I need to have store 1 in my database but not store 2 ...

SQL Server In Memory Equivalent

My team has recently decided to move from EF to Dapper. As such we are moving a lot of the logic that was done in EF into Stored Procedures as part of our SQL Server DB. This means that a lot of the Unit Tests that we have for EF are now Integration Level...

Web API In Memory Integration Testing - Authentication between two services

I have searched lots of posts here regarding my problem but have not found anything related to what I am trying to achieve....I have created a Web API micro service for handling user authentication. The service uses identity framework and issues bearer t...