As a coding test I've been tasked with developing a toy three-layer architecture DBMS project, involving OOP principles. The three-layer stuff isn't strictly my background so I've been trying to study ...

I have an interface: public interface UserDao extends Dao <UserEntity> {} It has one Implementation UserdaoImpl which looks like: @Component public class UserDaoImpl extends EsBaseDao < ...

As far as I know Repositories should work with Domain/Business Entities. All the operations to save and retrieve data to create entities should go there, and then the Repository is used by the Domain ...

I've got some kind of calendar feature in my Laravel app. Users can have one or more calendars. The owner of a calendar can share it with another user. If an owner shares a calendar with someone, he ...

I'm a fossil I know. I still use dataset, Datatable, Datarow, Dataview and so on. Having been around since the VB 4 days, I have seen many different data accesses come and go. I consider the dataset ...

I am using Next.js with MongoDB, Currently I am using the MongoDB client itself in TypeScript. I was wondering if later on I have to change my database, I need to customize the api/route.ts file. ...

I'm currently working on a React application that's using an internal API endpoint call, which interacts with a DAL layer and writes to a MongoDB hosted online. My issue, I made a less complicated ...

I have a project with NestJS where I use the classic controller-service-dal architecture. Until recently, I performed only simple queries from the DAL which returned the models themselves (or entities ...

I have 2 tables in my db. One is country table and other is state table. Country table has Id, name ,states[]. State table has Id, stateName, countryId. I need to fetch a country details based on Id ...

if the id that I get from database won't change during process(which usually don't), why can't I set it final? and by "can't" I mean I didn't see any software that did it before. I searched ...

I have a data access layer (a C# library), a .NET Core application that I intend to use as a service and several projects that need to talk to this service, including a Blazor WASM project. My DAL has ...

Do you have any suggestions on how one might one split the "action method" (see code below) into a separate DAL and BLL? public ActionResult GetLogs() { //set up your connection ...

I'm trying to use DI and Access Layer Pattern copying this https://davek.dev/crud-with-mongodb-in-c-and-net-6#heading-service-layer. So my project structure is like this: where DbAccess Has This ...

I'm using IDbConnection interface for saving data into my SQL tables, that has a method called Execute, which executes the query and returns the number of rows affected I have the following code: ...

Here is my SQL query: CREATE PROCEDURE User_CRUD @Action varchar(20), @eno int, @ename varchar(50), @salary money AS IF @Action = 'Insert' BEGIN INSERT INTO employee (...