entity framework

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

... 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…

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

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…

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

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…

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

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/…

Encrypting data the easy way using Crypteron

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…