Entity Framework Core - Knowledge Base (KB)

Unable to use existing database in unit tests with Effort framework

I am trying to write test using a database, hosted in Azure SQL, with ...Effort... framework on Entity Framework 6....When executing the following code, an exception is thrown: ...[ClassInitialize] public static void ClassInitialize(TestContext context) {...

What's the correct way to use Effort with Entity Framework 6?

I'm trying to get some test code working using the Effort data provider with Entity Framework 6. What I'm trying to do seems like it should be the absolute simplest use-case, but I'm just not able to get things to work....Here is my DbContext class: ...p...

unit testing with effort for entity framework 6 with computed values

Using effort EF6 with code first does not populate computed values. I have a datetime field (FechaCreacion) that is computed. How can I emulate it in Effort, so It is populated with DateTime.Now after savingChanges() ?...This post ...Using Effort (EF Test...

Effort (EF6) exception when accessing DbSet (The given key was not present in the dictionary)

This is proving to be a little hard to trace down, but when using Effort for testing Entity Framework 6, I seem to get a KeyNotFoundException ("The given key was not present in the dictionary") error when trying to access one of the DBSet repositories. ....

Entity Framework Core - In Memory Provider Required Field

In previous versions of Entity Framework I have been using Effort (...https://effort.codeplex.com/...) for unit tests. I decided to give the new in memory provider for EF Core and quickly found out that it does not honor the IsRequired() and other entity ...

ASP Boilerplate problems using Effort in unit testing with EFProf (Entity Framework Profiler)

Having issues using EFProf (...http://www.hibernatingrhinos.com/products/EFProf...) with ASP Boilerplate (...http://www.aspnetboilerplate.com/...). ...For unit testing, ASP Boilerplate uses Effort (...https://github.com/tamasflamich/effort...) for mockin...

Unit Test with Effort EF6 with Async Methods

I'm trying to setup Unit tests for this. But every example I've seen that actually works is this type of setup. It will work this way....//Setup DBContext public MyContext(DbConnection connection) : base(connection, true){} //Have some service that gets p...

Effort.Exceptions.EffortException : Database has not been initialized - after non commited update?

Why does this exception occur? Is this a bug?...I'm using Effort, the EF testing library to create an in memory instance of my database and run into this interesting scenario: ...Open ...DbContext1...Add item to ...Table... (do not save)...Close ...DbCon...

UnintentionalCodeFirstException | Entity Framework Unit Testing with Effort.Ef6 using Database First

The situation...I want to enable unit testing of my ...DbContext... based on entity framework 6. I have created my ...DbContext... and my models with the database first approach and now have an ....edmx... designer file....The problem...My automatically c...

Making tests faster by using only partial database in EntityFramework Effort

Use case: We have a quite large database (about 200 tables) that is used in a large (legacy) system. It's implemented as a database-first approach, with one ...edmx... file defining the entire database. We are using XUnit and Effort for automatic testing....