dotnet falcon

Blogging about .NET and software development - from my bird's eye view

Entity Framework

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

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

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 custom SQL
StackOverflow adventures: Specifying default sort order in EF using query interceptors

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

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 automatically add
Encrypting data the easy way using Crypteron

Encrypting data the easy way using Crypteron

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 and test