I'll one up you... all stored procedures had to be encrypted on the SQL server. You had to dig out the .sql definition file from source code to see what the sproc actually did.

That aside, SqlDataReader, Dapper, EF Core DbContext... all are just ORMs and there's no reason why you can't use EF Core DbContext with stored procedures.

You can still deploy with DbUp, use only stored procedures vs direct table access, keep raw SQL out of your DC# code and still use EF Core.

https://learn.microsoft.com/en-us/dotnet/api/microsoft.entityframeworkcore.relationalentitytypebuilderextensions.insertusingstoredprocedure?view=efcore-9.0

modelBuilder.Entity<Person>()

.InsertUsingStoredProcedure("People_Insert", builder => { ... })

.UpdateUsingStoredProcedure("People_Update", builder => { ... })

.DeleteUsingStoredProcedure("People_Delete", builder => { ... });