NMemory Database - Knowledge Base (KB)
41 results
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
Effort Framework does not recognize Entity Model schema
I have an entity model of a Sybase ASE database and I am trying to use the ...Effort Framework... to create unit tests for it. I am able to access the database with the entity model in both my main project and unit test project, however when try to use Ef...
asked by elliot-j
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...
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...
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...
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...
asked by nramirez
Effort Unit test: Argument 'xmlReader' is not valid
I'm currently trying to unit test a context class of the Entity Framework with the "Effort" framework (...http://effort.codeplex.com/wikipage?title=Tutorials&referringTitle=Home...)...If my unit test project has two classes that contain methods use effort...
asked by rawajames
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...
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...
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...
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...
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...
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...
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. ....
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...
asked by Szeki
Unit testing with Effort - Adding records with identity off
I am using using Effort (for EF4) to do some unit tests. ...var ctx= Effort.ObjectContextFactory.CreateTransient<TheContext>(Shared.Connection); ctx.companies.AddObject(new company() { ID = 100, name = "Agent", is_agent = true }); ctx.SaveChanges(System....
asked by MJK
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...
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....
asked by gurkan
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 ...
asked by Matt Sanders
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(); } ...
asked by yÇsÊžÇla
Page 1 of 3