Questions tagged [data-access]
The data-access tag has no summary.
13 questions
1 vote
3 answers
215 views
How to handle overfetching efficiently with repository pattern in large applications?
I'm working on a large Typescript project in NodeJS with Prisma, where we have dozens of domain entities—some with 30+ fields and complex relations. We're using the repository pattern to abstract data ...
- 21
0 votes
1 answer
169 views
DAL class structure for storing and organizing SQL using Dapper?
I'm creating a web application with Asp.Net Core MVC, and I've replaced Entity Framework with a custom data store. I've decided to use Dapper, but have never used it prior to this project. So I'm ...
- 147
1 vote
1 answer
1k views
How can I design a data access layer that connects to two different databases?
I have a C# application that needs to connect to either an Oracle database or a SQLite database. The databases can be considered "identical" - same schema - but users have the ability to &...
- 113
1 vote
1 answer
536 views
What is an apporpriate design pattern when dealing with Pandas and databases?
We're dealing with a lot of "data analysis", basically different sorts of data mangling, aggregations and calculations using Pandas. Usually, the data is time series data. All underlying ...
- 13
0 votes
0 answers
137 views
Models as data containers in MVVM
In the past, when I've used MVC, my model objects were just dumb data containers. Everywhere I read says that in MVVM, models should contain business logic as well as being a data container. Now that ...
- 1
-2 votes
2 answers
153 views
Creating new methods for every read query in Data Acess Layer
Lets say we have a table 'A' with 4 referenced tables : Table B,C,D,E In our Data Acces Layer we could write a method that returns Table A containg every entity of B,C,D,E by joining in order to reuse ...
- 1
0 votes
1 answer
51 views
When dealing with session level data in a web app, is it better to maintain a static store of that data, or pass it around as needed?
I have a web app that is capable of connecting to multiple databases that are identical in structure but contain different data; each of our clients who uses the app gets their own copy of the ...
- 577
-4 votes
1 answer
581 views
Express SQL Query As Abstract Object Model
Goal: write code to express SQL queries in C# that get converted to SQL at the data layer level and will be compatible with any common data layer / ORM such as Dapper or Entity Framework (EF). Edit: ...
1 vote
1 answer
268 views
Is it good practice to use data API for access cross platform
All, Question: Should I have a common data access API between various cross platform applications or keep the data access specific to the UI even though it would result in duplication? Background: ...
- 113
1 vote
1 answer
743 views
Is my DataAccessLayer well implemented?
I have 3 projects in my solution : An ASP MVC project A console app project A class library project (the DataAccessLayer) I didn't want to recreate an ADO.net entity data model for each project so I'...
- 143
2 votes
2 answers
2k views
Can a UWP App access data outside its own app data, publisher data, or what the user picks with the FilePicker?
Can a UWP App access data outside its own app data, publisher data, or what the user picks with the FilePicker? As far as I can tell, a shared publisher area and a user prompt with the FilePicker are ...
16 votes
3 answers
14k views
Does caching belong in a repository class?
I have gone back and forth on this issue several times. On one hand, you could argue, a repository's single responsibility is to manage the persistent state of an entity, and the consuming ...
- 5,311
0 votes
1 answer
177 views
Where does code belong when it is called by multiple sources?
I am working on a process that requires two different portions of it to make use of an ORM (I am using Insight.Database for this), and I am not sure where this portion of the code belongs, as I am not ...
- 15.7k