Is this a code smell?
I have a repository which connects to a SQL server. This repository uses Dapper to map the results to an object.
I have a method in this repository that checks a result, then passes a bool back on whether the result passed a test.
Since I don't want to use the results of the SQL query outside of the method, I want to create a private model inside the repository file to act as a middle-man, something the query can map to temporarily, whilst the rest of the method runs whatever else it needs to.
I don't want to make a public method as it won't be used outside of this repository, I'm also actively trying to reduce the amount of files this project has.
Is it bad to use a private class inside a repository file? Does it need to be a public class in a model folder?