About
This blog is mostly about my work, but expect an occasional home project, productivity tip and tooling review.Search
Categories
- Conference (20)
- Development (208)
- Security (17)
- Test (32)
- Tooling (166)
- Uncategorized (168)
Most used tags
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
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
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
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 asp.net, async, EF, Entity Framework, Loadtest, sqlserver, Web API
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