Entity Framework knowledge Base | Entity Framework 6 Tutorial and Documentation

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) {...

asked by Lena Kaplan

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...

c# effort entity-framework entity-framework-6 linq

asked by Tim Long

How would I configure Effort Testing Tool to mock Entity Framework's DbContext withOut the actual SQL Server Database up and running?

Our team's application development involves using Effort Testing Tool to mock our Entity Framework's DbContext. However, it seems that Effort Testing Tool needs to be see the actual SQL Server Database that the application uses in order to mock our Entit...

effort entity-framework mocking sql-server unit-testing

asked by CS Lewis

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...

c#-4.0 database effort entity-framework integration-testing

asked by Zuiq Pazu

Spatial DbGeography Provider exception with Effort.EF6 [No usable spatial provider could be found.]

I'm developing an application with EF6 and I decided to use System.Data.Entity.Spatial.DbGeography for my locations as follows...public class Place { public int Id { get; set; } public string Name { get; set; } public DbGeography Location { get; se...

asp.net-mvc c# effort entity-framework-6 spatial

asked by nramirez

Is there a way to use a sql profiler for nmemory (an in-memory database)

I'm using Entity Framework with Effort that uses NMemory to test without having actual database side-effects. Is there any way to view the sql that's being sent to the nmemory database?...Edit:... Thanks to @Gert_Arnold I have been looking in to DbContex...

effort entity-framework

asked by lanierhall

Using Migrations with Effort.EF6?

I'm using EF6 and I'm now setting up some tests for my aggregates. I've decided to use Effort.EF6 because I'd like to have those tests run without having to install an entire database engine....My DbContext uses migrations and a seeding method that insert...

.net c# effort entity-framework-6

asked by Maciek

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 entity-framework entity-framework-6 unit-testing

asked by nerlijma

Update model causes interface to be removed from DbContext when using Effort with Entity Framework

Presently, I am attempting to use Effort (...https://effort.codeplex.com/...) with my Entity Framework 6 solution to allow unit testing without requiring a database connection (see ...http://www.codeproject.com/Articles/460175/Two-strategies-for-testing-E...

c# effort entity-framework-6 unit-testing

asked by user8128167

How can you perform the same tests as Effort using only Moq?

Presently, I have setup a lot of tests including data access layer and business logic layer tests using Effort (see ...https://effort.codeplex.com/...). We have already been using Moq in our unit tests, and my boss would like to keep things simple, so he...

c# effort entity-framework-6 moq unit-testing

asked by user8128167

Is there anyway I can load the data to the in-memory instead of using.csv files in effort for unit-testing?

Is there anyway I can load the data to the in-memory instead of using.csv files in effort for unit-testing?...Scenario: I want to load the data to the in-memory to use the Effort framework which creates the fake dbcontext and performs the operation. Inste...

csv effort entity-framework nunit unit-testing

asked by ravi

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. ....

.net effort entity-framework entity-framework-6 linq

asked by Stefan Zvonar

Testing with Effort and TypeName attribute

I'd like to test some code, and to achieve that, I'd need to fake DbContext defined in DAL (...Entity Framework 6 - Code first...). It's going mostly well, but I bumped into an problem when the data model class is using the ...TypeName... attribute. I mad...

c# dbcontext effort entity-framework unit-testing

asked by Szeki

Entity Framework 6 throws migration exception when trying to create a context with Effort

I'm trying to use Effort to test my application but if code-first migrations are enabled on the context then it throws the following exception:...System.InvalidOperationException: Migrations is enabled for context 'XDbContext' but the database does not ex...

asp.net-mvc effort entity-framework-6

asked by Steve

Effort unit testing Entity framework 6.1.3 DB-first

I am experiencing problems when using Effort framework (version 1.1.4) to unit test my DB-layer....I have a DB-layer using Entity framework 6.1.3 and the model is created using database-first approach so there is an ...*.edmx... file describing the model....

c# effort entity-framework unit-testing

asked by gurkan

Effort throws InvalidOperationException: Sequence contains more than one matching element

I'm using Effort in a regular way by creating a connection and passing it to DB Context:...public class InMemoryContextInitializer { public void BeforeAllTests() { Effort.Provider.EffortProviderConfiguration.RegisterProvider(); } ...

c# effort entity-framework

asked by yÇsÊžÇla

How do I get Effort to work with EntityFramework?

OVERVIEW... Using Fitnesse with EF6, can't get Effort to start up. I've tried every trick in all the posts I can find.... All the posts say to either call 'RegisterProvider', or add a config section. Neither is working....So far:... I have "Effort.Provid...

c# effort entity-framework

asked by BWhite

Shim DbContext ctor for Effort unit testing

I'd like to intercept ...var context = new MyDbContext()... to return a different constructor call instead....The great thing about ...EFfort... is that it let's you set up an easy in-memory database for unit testing....var connection = Effort.DbConnectio...

effort entity-framework microsoft-fakes shim unit-testing

asked by RJB

Effort- FirstOrDefault returns null when Faking Database

I'm trying to create some unit tests for my project, after much digging around I found Effort, the idea is great, it mocks the database instead of the dealing with faking the DBContext which by the way is really hard to get it right when using a complex s...

c# effort entity-framework mocking unit-testing

asked by General Electric

XML column using Effort

I have my Entity Framework context faked using the Effort framework. I'm using a XML-typed column to store data. Apparently Effort can't handle this. How can I get around this? All suggestions are welcome!