entity framework

Implementing the Repository pattern with direct IQueryable support

Jul 2, 2019

Lately I have written a lot of posts about the Repository and Unit of work patterns. You can check out all the software design posts about why I think they are (still) useful and how you can use the Specification pattern to improve on it. So this pattern has been

Supporting async LInQ evaluation on IQueryable mocks

Akos Nagy

Jun 18, 2019

IQueryable<T> is a tricky interface. Some people argue that it is actually a bad abstraction, because it is impossible to implement it. This post is not about trying to prove or disprove this point. People who say this do have a point, but I do think they

Entity Framework Code First generators templates

Akos Nagy

May 14, 2019

If you follow my blog, you know that one of the most prominently featured topics if Entity Framework. A not very-well known, but very useful feature of Entity Framework Code First is the ability to add your custom sql generators that are used when you create sql scripts from your

Using dependency injection to configure Entity Framework DbContexts

Akos Nagy

May 6, 2019

So let's say you have your own DbContext descendant with a couple of DbSet<T> properties that contain your entities and you also want to configure some of your entities. If you know EF, you probably know how to do this (and why to do it

Entity Framework custom migration generator decorators

Akos Nagy

Apr 26, 2019

In the past I created a number of custom solutions to generate the migration sql from Entity Framework Code First migrations (see my post here for soft delete automation, here for auditing migration automatically, here for specifying filtered indices and the one I created recently about adding an index to

Entity Framework Core Cosmos DB provider

Akos Nagy

Apr 11, 2019

The Cosmos DB provider for Entity Framework has been available in preview for a while. I've been wanting to check it out ever since I read the announcement, but I haven't really had the time (and to be honest, I was worried it would be not

Generate index for TPH discriminator with Entity Framework Code First

Akos Nagy

Mar 26, 2019

When it comes to mapping inheritance hierarchies to database tables using an ORM, there are a lot of different options. Though it definitely has drawbacks, one of the most popular method is 'table-per-hierarhy' (TPH). TPH maps all the entities in the inheritance hierarchy to one table that contains

Entity Framework

Converting traditional EF includes to EF Core includes

Akos Nagy

Feb 19, 2019

In a previous post I tried to give reasons why you should use the repository and unit of work design patterns even if you have a modern, object-relational framework like Entity Framework (well, modern would be up to debate in this case, but whatever). Besides the usual reasons ('EF

Entity Framework

Create a filtered index using Entity Framework Code First

Akos Nagy

Apr 1, 2018

Using Entity Framework Code First, you have the option of specifying indices on columns that are translated to migrations and from that you can generate the SQL script or update the database. With EF 6.2 you can use the new HasIndex() method to define your indices. Before 6.2,

Analyzing Entity Framework Code First default conventions

Akos Nagy

Nov 7, 2017

In my previous post I told the tale of how I used a wrong (but still awesome) tool to solve a problem. The problem was that I had not known the default conventions when using Entity Framework Code First. To remedy this problem, I decided to take a look at

Stackoverflow Adventures: If all you have is a hammer...

Akos Nagy

Nov 5, 2017

... you see everything as a nail. I'm usually not the one to cite clichés, but for this one I make an exception. It is very, very true, especially in the software engineering business. If all you know is foreach, you don't use SelectMany. If you only

StackOverflow adventures: Checking key equality with generic primary keys in Entity Framework

Akos Nagy

Sep 22, 2017

You might have come across a design like this: you are using Entity Framework Code First, you have a base class that defines the primary key of the entities, and to have a more generic design, the PK is generic. Something like this: public abstract class EntityBase<TKey>

StackOverflow adventures: Don't create non-clustered index for foreign keys with Entity Framework Code First

Akos Nagy

Sep 20, 2017

I found an interesting question on stackoverflow: https://stackoverflow.com/questions/46212828/ef6-preventing-not-to-create-index-on-foreign-key OP wanted to find a way to disable index creation for foreign keys. I don't believe there is an easy way to do this; my mind turned right to custom SQL generators and scaffolders. Using

StackOverflow adventures: Specifying default sort order in EF using query interceptors

Akos Nagy

Sep 17, 2017

During the summer weeks, I was a little less active on stackoverflow. But now that the weather is becoming less and less friendly, I've reactivated myself and come across this question: https://stackoverflow.com/questions/45999489/entity-framework-interceptor-default-sorting/46001440#46001440 So basically, OP wanted to find a way to

Encrypting data the easy way using Crypteron

Akos Nagy

Aug 15, 2017

Story of my life: I'm in the middle of some logistics-project for a hospital or a moving company or a security firm or (God-forbid) the government. Specs have been finalized for months, the business model is implemented in EF, we have a test environment filled with test users

dotnet falcon

Entity Framework