Questions tagged [data-access]
The data-access tag has no usage guidance.
12 questions
0
votes
1
answer
110
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
955
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
387
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
110
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
123
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
43
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 ...
- 521
-4
votes
1
answer
481
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
255
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
709
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
13k
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,281
0
votes
1
answer
163
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