AboutThis blog is mostly about my work, but expect an occasional home project, productivity tip and tooling review.
Most used tags
Tag Archives: Entity Framework
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
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
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
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