I'm learning Clean Architecture and I can't figure this out. Imagine this scenario: I have a ServiceA that calls its repository: public class ServiceA : IServiceA { private readonly IRepositoryA ...

I'm trying to create query helpers for my repository pattern. Actually I'm dealing how to add join clauses. The only idea is to inject Sprintf statement but this behavior might cause SQL injection. ...

I would like to know how to use the repository pattern with Prisma transactions. I am using OAuth, so when the user authenticates, I need to populate the user, account and session tables. If any of ...

I am studying Clean Arch with Java. My project structure is like: project | |--domain | |--entity | | |--Student.java | |--repository | |--StudentRepo.java (...

I have this function in my TaskService: func deleteTask(task: DistributionTask) async throws -> Void { let (tasksCollection, userTasksIdsField, teamTasksIdsField) = task.isCompleted ...

For context: I use Mapster and Serilog. public class UserService(IUserRepository repository, ILogger logger) { public async Task<TDto?> GetByIdAsync<TDto>(int userId, Func<...

I have an ASP.NET Core Web API and services. To abstract EF Core's DbContext from service layer, I decided to use the repository pattern. However, the repository contains logic that cannot be unit ...

I am working on an ASP.NET Core application where I have multiple repositories, and I register my DbContext as Scoped in the Dependency Injection (DI) container: Since all repositories share the same ...

This question is inspired by the articles https://www.gorgias.com/blog/prevent-idle-in-transaction-engineering and https://capnfabs.net/posts/sqlalchemy-connection-management/. SQLALchemy session ...

My current solution is as follows - I want to know whether this is correct. Inside a HttpPost action method, I have the following code - Case type is an entity, case variable is passed as a parameter ...

Using the Dynamic where here Entity Framework Core Dynamic Where Clause I am able to have a where on any column in any table, accessed by property name, using an Entity Framework typed repository ...

I'm extending an application. The application main focus is scanning items and allow an operator to review and rate the results. A kind of quality inspection. We introduced the possibility of binding ...

I am facing an exception(ConnectionMultiplexer) message when trying to access a .NetCore 8 webAPI endpoint. I tried to use repositoryPattern in my project so there's a GenericRepository interface. I ...

I want to create generic method to get few columns only. I am using entity framework with repository pattern. I tried with below public async Task<IEnumerable<TResult>> ...

How can I implement the repository design pattern in a MERN stack project? Also, how should I configure the database ,logic's to follow the repository pattern? what is the abstraction layer in ...