Questions tagged [dapper]
The dapper tag has no summary.
11 questions
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
453
views
How can I restore an entity from the database while keeping my entities database-independent?
Background
I'm currently working on a project using domain-driven design and Dapper as my ORM. The entities are naturally slightly different than the tables in which they are stored (e.g. _id is ...
- 225
1
vote
1
answer
979
views
Performing many SQL inserts quickly without using BulkCopy
I have a C# system that reads thousands of messages per minute from a Kafka topic. The messages are filtered and I need to insert the filtered messages into a MSSQL table.
A normal insert statement is ...
-4
votes
1
answer
298
views
Changing databases in general repository methods when using Dapper [closed]
I'm developing a multi-database application. There is one admin database and many customer databases which are identical in structure.
I also have a generic RepositoryBase which looks like the ...
- 95
2
votes
1
answer
2k
views
Best approach to connect master and child table while insert data in tables
I need advice what is best approach to connect data between master and child table.
I have console application written in C# which scrape data from web, process data and insert them in table.
Master ...
- 123
0
votes
0
answers
195
views
Tradeoffs between Testability and Performance when filtering using SQL vs LINQ
My team has recently decided to adopt the CQRS pattern similar to the one used in the famous Microsoft EShopsOnContainers repository. In this solution, the queries are made in Query classes using ...
- 103
-3
votes
1
answer
120
views
Defer insert data into a database
I need to insert some records into a database at a time when it normally it's not being used, what are some approaches I can take? I have considered using the SQL Server Agent to run some stored ...
- 97
2
votes
2
answers
447
views
Is it better to have a single query that returns all related entities, or separate queries for each case?
Summary
When writing methods to query for related entities, is it better to have a single method for all related entities or separate methods for each combination?
Full Problem
I'm writing repository ...
3
votes
4
answers
6k
views
Is it possible to cache data on a REST service that returns paginated data?
Under the REST architecture principles, a RESTful application should be stateless, therefore each time I invoke an ASP.NET 4 REST service (with GET verb) that pulls tens of thousands of records, the ...
- 139
3
votes
1
answer
448
views
CQRS: how granular should the queries be?
I have a system that uses CQRS with the Queries written using Dapper. It's worked out well, except that there has been a proliferation of query classes that do almost the same thing. The downside of ...
- 487
2
votes
2
answers
328
views
How to maintain database in open source application?
I'm building my first open source project. It's an API build with C#.
My project has layers
Api itself to receive requests
Services library, for logic.
Database library, for db operations.
I'm using ...
- 249