Building dynamic sql queries in C# (medium.com)

I kind of like this. No overhead from EF and you could still create constants to describe your table and fields.