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
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 ...
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
-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
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
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