Entity Framework 6 - Knowledge Base (KB)

how to populate ObjectResult from List<>

In order to test a method that uses a stored procedure, a fake method has been created. This method is to return a list of ints....Something like this ...... public virtual ObjectResult<Nullable<int>> available_IDs( ... ) { List<int?> fake...

Why DbContext doesn't implement IDbContext interface?

Why there is no ...IDbContext... interface in the Entity Framework? Wouldn't it be easier to test things if there was an existing interface with methods like SaveChanges() etc. from which you could derive your custom database context interface?...public i...

Testing an Entity Framework database connection

I have an app that connects to a MYSQL database through the entity framework. It works 100% perfectly, but I would like to add a small piece of code that will test the connection to the database upon app startup....I had the idea of simply running a tiny ...

Using Test Doubles with DbEntityEntry and DbPropertyEntry

I am using the new Test Doubles in EF6 as outlined ...here from MSDN... . VS2013 with Moq & nUnit. All was good until I had to do something like this: ...var myFoo = context.Foos.Find(id);...and then:...myFoo.Name = "Bar";...and then :...context.Entry(my...

EF6 localdb for integration testing

I am developing a WPF application which requires some database access. For development purposes I am using localdb with database migrations enabled and EF6....What I cannot figure out is how do I configure a separate localdb database for integration tests...

How To Use Effort in Conjunction with Reverse Poco Generator

So I am Visual Studio 2017, EF6 and I am using this T4 template ...https://marketplace.visualstudio.com/items?itemName=SimonHughes.EntityFrameworkReversePOCOGenerator... to generate my context class ...Being a big fan of testing I already have 100% covera...