Specification VS examQuestionCore

If so, then look into this

Also, to minimize duplication of code and optimize your architecture i suggest using something like https://github.com/ardalis/Specification

This is a great candidate project for the Ardalis.Specifications library.

This is honestly such an amazing way to make sure you have a clear view of what your Linq does, see https://github.com/ardalis/Specification - note that the examples on the front git page uses a repository, but he later allowed the use directly on DbSet which finally made it possible for me to use the library.

Check out the specification pattern - it is designed to encapsulate query logic similar to your example. Steve Smith has a nice library for it on GitHub: https://github.com/ardalis/Specification

I'm thinking that the only way to abstract both of them would be to have the repositories return IEnumerables and have well defined aggregates for the entire application to avoid an exploding number of methods on the interface, but this is not possible in my project*. I've looked at Steve Smith's Specification library, but since it works with IQueryable, it would not work with Dapper.

I use this to distribute exams to my students https://github.com/rtbsoft/examQuestionCore

Have a look at what I've done here: https://github.com/rtbsoft/examQuestionCore . I'm all for the right level of complexity and accessing dbContext in the controller is just fine. I've worked on a project with a DTO layer and an Repository layer and interfaces everywhere and it just ended up that every change required touching multiple files and running automated tools (which sometimes failed on the build server) -- with almost no gain in security or any other metric I could think of. KISS

Here's a project I created for teaching purposes: https://github.com/rtbsoft/examQuestionCore Hope you can learn something by studying this code.

My front end tool of choice is Vue. You can see the combo here: https://github.com/rtbsoft/examQuestionCore and here: https://github.com/rtbsoft/examQuestionVue.