Tag Archives: Entity Framework

EF query optimisation

We have a view that is very slow when you don’t use a filter on the name field. Everywhere in our stored procedures and (sub)queries we have this applied. In our web applicatie we use Entity Framework. The business layer … Continue reading

Posted in Development | Tagged , , , | Leave a comment

Effort: Unhandled exception while trying to initialize the content of Table

We use Effort with the CsvDataLoader in our integration tests. After adding a new data file we got an exception. On the forum every thread ended with something like “my bad” or “never mind”. Looking closer to my csv file showed the error: a typo … Continue reading

Posted in Test | Tagged , , , | Leave a comment

Entity Framework Fake ObjectContext Realization Tool

With Effort (Entity Framework Fake ObjectContext Realization Tool) I can create integration tests for the datalayer in my project. The tool has an Entity Framework provider that works on an in-memory database. This means I can call SaveChanges without mocking it or having a dependency on a … Continue reading

Posted in Development | Tagged , , | Leave a comment

Performance tuning EF, ASP.NET and loadtest

We are developing webservices for accessing data in SQL Server. The performance requirement was not met until we started to tune our solution. TLDR: use table in stead of view EF First we added the AsNoTracking() extension from EntityFramework to … Continue reading

Posted in Development | Tagged , , , , , , | Leave a comment

Week roundup

Last week recap and links: Entity Framework Unit Testing Tool, create a DbContext with an in-memory database Installing ASP.NET 5 On Linux, this is possible now Logitech Performance MX Mouse, I’m looking for a new mouse anyone experience with this … Continue reading

Posted in Uncategorized | Tagged , , , , | Leave a comment