Questions tagged [dapper]
Dapper is a micro-ORM for .NET developed and used by the Stack Overflow team, focusing on raw performance as the primary aim.
dapper
2,928
questions
0
votes
1
answer
18
views
Error when try to map entities in Dapper(Multi-map error: splitOn column)
Error:
System.ArgumentException: Multi-map error: splitOn column 'Id' was not found - please ensure your splitOn parameter is set and in the correct order (Parameter 'splitOn').
It happens when i use ...
- 1
-3
votes
1
answer
26
views
Where to create Join entities in Clean Architecture .NET [closed]
I am developing an application with Clean Architecture and I came across a problem with the structuring and location of some Objects.
In my Application layer, I am using the CQRS approach. In one of ...
1
vote
0
answers
31
views
How to get selected cell value of multi DataGridView in TabControl to main datagridview in form1 with VB.NET
I'm trying to get selected cell value of multi DataGridView in TabControl to main datagridview in form1 with VB.NET
Please Guide me
for example when I selected row in the Criteria1 tabcontrol with ...
- 47
0
votes
2
answers
62
views
Why do I need to model a join table class?
I have two classes in C#:
public class Student
{
public string Name {get; set;}
public string Email {get; set;}
public List<Course> Courses {get; set;}
}
public class Course
{
...
- 9
0
votes
1
answer
27
views
How to instantiate null object and property in C# with Dapper via SplitOn?
I have this stored procedure in the database:
SELECT
Cars.CarId AS carCarId,
Cars.VinCode AS carVinCode,
-- Cars.CustomerId AS carCustomerId,
Cars.NumberPlate AS carNumberPlate,
...
0
votes
1
answer
41
views
SQLKata insert not working with VARBINARY
I have this block of code that inserts data into tables like this:
public async Task<int> InsertRowAsync(InsertRowRequest request)
{
using var conn = _dbConnectionContext.CreateConnection(...
- 432
0
votes
0
answers
33
views
How to map value objects in dapper
i have the following entity
using MedRaise.Domain.Enums;
namespace MedRaise.Domain.Entities;
public class Appointment : Entity
{
private Guid _clinicId;
private DateTime _date;
private ...
0
votes
1
answer
63
views
Dapper returning zero GUID
Dapper constantly returns the default value instead of the ID. What could be the problem and how to fix it? (Dapper + PostgreSQL)
Can you explain to me what is the problem?
public async Task<...
0
votes
1
answer
43
views
How to convert DTO property types to CLR types in Dapper
I'm using Dapper and Dapper.Contrib in a project. I want to asbtract the type used for keys in my Dto so that I can change it easily in the future.
The code below throws a System.NotSupportedException ...
- 1,679
0
votes
1
answer
114
views
Unexpected formatting of PostgreSQL timestamptz column in function returning json
I have a function returning json that contains a timestamptz. When I execute it in Datagrip console, I get json like
{..., "time_created":"2024-05-15T11:14:23.384266+00:00",...}.
...
0
votes
0
answers
36
views
Dapper with MariaDB stored procedure with UUID type parameters
I'm trying to call stored procedure with parameter of type UUID from Dapper and getting the exception:
System.NullReferenceException: Object reference not set to an instance of an object.at ...
- 1,444
0
votes
0
answers
52
views
Writing to SQLite database using Dapper doesn't work
My code executes without errors, but nothing gets written to the database, and I'm a bit at a loss as to why. Reading works fine (from the table in question) so the connectionString is definitely ...
- 43
-1
votes
0
answers
37
views
Dapper Oracle and CLOB insert data argument was out of the range of valid values
When doing a Dapper Execute on an Oracle table with a CLOB data field and that value is over 1,900 characters I get this error:
System.ArgumentOutOfRangeException: Specified argument was out of the
...
- 3,555
0
votes
0
answers
53
views
Improve Dapper query with more than 7 joins mapping on .NET 8
I'm using Dapper to execute a stored procedure that joins multiple tables and maps the results to various related objects. The code works, but I find it a bit cumbersome and I'm not sure if I'm using ...
- 1
1
vote
0
answers
29
views
How to use User Defined Type(UDT) in dapper for oracle databse
I have a UDT like
CREATE OR REPLACE TYPE VList AS TABLE OF VARCHAR2(100);
and this is my stored procedure;
CREATE OR REPLACE PROCEDURE SEND_EMAIL_PROC
(
P_EmployeeIds VList,
P_DeptsIds VList,
...
- 11