NMemory Database - Knowledge Base (KB)
41 results
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...
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...
asked by RJB
Unenforce foreign key references in Effort
I am using Effort in Visual Studio and C# to recreate and unit test a database. I am writing a class for a single table and so I am only populating the database with objects from that table. My problem is that the Effort database wants the object's foreig...
asked by A_Arnold
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...
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!
asked by Thijs
Why Since Adding Effort.EF6 Unit Tests can I no longer run my C# MVC Website?
My C# MVC Website uses StructureMap for Dependency Injection....The constructor for my DbContext used to be as follows....public class PortalEntityModel : DbContext { public PortalEntityModel() : base("name=PortalEntityModel") { } } ...Now I h...
asked by Tom McClean
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...
asked by Todd Brooks
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...
asked by KryptoBeard
EntityFramework, DbContextScope and Effort - exception: DbContext has been disposed inside unit test
I am trying to write unit tests (with NUnit) for service layer which uses:...Entity Framework as Data Access Layer...DbContextScope... for managing DbContext lifetime...I also use ...Effort.EF6... for mocking DbContext in unit tests. Unfortunately, I cann...
asked by PJDev
Effort (EF Unit Testing) giving errors
I am trying to do unit testing on some classes that reply on an Entity Framework DB Context. For help, I managed to find a library called Effort, which seems to be a little old, and not very well documented, but it seems to work, and seems to be quite pop...
asked by JonathanPeel
Effort (C#) - 'Sequence contains no matching element' when seeding data to any of my entities
I am trying to build some unit tests for a few web service calls in my project. I am using Entity Framework 6.1.3 in my project to retrieve the data at the service layer (with a code-first approach). I did some research on how to Mock a DatabaseContext ob...
asked by Adrian Cruz
Effort Entity Framework Sequence contains not matching elements
So I've been trying to setup Effort and am not having much success. Looking on their site and people's comments it looks pretty straightforward. ...I started small because I just wanted to test if it works. The error I get is "Sequence contains no matc...
asked by user892381
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...
asked by Philip Pittle
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...
asked by WoIIe
Testing eager-loading scenarios with Effort.EF6
We're using ...Effort.EF6... to build a test suite for an ASP.NET Web API 2 service working against an in-memory database, and for the most part it's a wonderful experience....However, for reasons unrelated to this question, we have had to turn off lazy l...
asked by Tomas Aschan
Create stored procedure on Effort database for Unit Test
I have a function calling a stored procedure with Entity Framework :...public async Task<List<Entity>> GetEntity(int id) { var param = new SqlParameter("@id", id); return await myContext.Database .SqlQuery<MyEntity>("[myStoredProc...
asked by GGO
Using Effort with EF6 in a DB First approach
I'm using the Model First approach with EF6 and I'm trying to use ...Entity Framework Effort... to develop in-memory tests....Here is what I do in my test:...var inMemoryConnection = Effort.DbConnectionFactory.CreateTransient("name=MyEntities"); var inMem...
asked by Boubou
Effort supported unit tests conflict
I've inherited some tests with this project. They were working when running against the SQL database, but slowly. I'm trying to switch over to using Effort.... .NET4.5, EF6.2, Effort 1.3.10....I have two possibly related issues with my unit tests....It do...
asked by BWhite
"Sequence contains no matching element" setting HasColumnType("varchar") in EF Mappings using Effort
I have the following Entity Framework (v6.1.3) mapping:...public class FileStoreDocumentEntityMapping : EntityTypeConfiguration<FileStoreDocumentEntity> { public FileStoreDocumentEntityMapping() { Property(x => x.FileStoreDownloadUrl) ...
asked by Adolfo Perez
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...
asked by julian guppy