python (65.2k questions)

javascript (44.3k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (13k questions)

Questions - dapper

Generate a dynamic C# class using Dapper with the Database table having a composite key

I have a database table that has a composite key. In my C# code, I don't use Domain classes but based on the name of the table configured in the database, I read that and generate the C# domain class....
test-img

tRuEsAtM

c#

dapper

Votes: 0

Answers: 1

Latest Answer

In the case of models with composite keys, I have used the attribute [ExplicitKey] instead of [Key].
test-img

b166er

Using custom Dapper ITypeHandler for parsing data but not for handling SQL parameters

Assume there is a stored procedure sp_legacy that is not possible to change. The result set contains, among other things, a column called Ids. The column carries a list of integers as JSON. An example...
test-img

Linus

c#

sql

dapper

Votes: 0

Answers: 0

Is Dapper's QueryFirstOrDefault method really slow?

I read that Dapper is faster than EF (at least at retrieving data) and I want to confirm that so I am comparing Dapper and EntityFramework with the help of BenchmarkDotNet. So I tried this... [Ben...
test-img

gven21

c#

performance

entity-framework-core

dapper

benchmarkdotnet

Votes: 0

Answers: 2

Latest Answer

I think this example shows very clearly the responsibility of SQL query generation when using Dapper, CA.Blocks.DataAccess or ADO.NET directly. When using these packages for accessing the database th...
test-img

Kevin Bosch

jsonb_set function using Dapper

in PostgreSQL if I write this query, everything works fine: UPDATE states SET data = jsonb_set(data, '{test}', '"test"') WHERE object_id = 'string' RETURNING state_type, object_id, state_id,...
test-img

idiot4352

c#

.net

postgresql

dapper

Votes: 0

Answers: 1

Latest Answer

Function jsonb_set accepts arguments as (jsonb, text[], jsonb) not (jsonb, text, jsonb). So I added ::text[] to @key: var sql = @"UPDATE states SET data = jsonb_set(data, @key::text[], CAST(@...
test-img

idiot4352

Posts

Questions

Blogs

Jobs