Dapper Tutorial - Knowledge Base (KB)

How to select one to many relationship & one to one together using dapper

I have following classes and db schema. I am trying to query this data from database using dapper that would hydrate the full object graph. I looked at various SO question and the test but couldn't really figure out how to do this....DB Schema...Author ...

Select All from Collection Where ID in List

I'm just learning to use lambda expressions and was turned on to Dapper a couple days ago. I'm working on an app that populates a ...listView... with usernames to be selected for some account maintenance. I'm having trouble with one part of sorting:...I'm...

Passing parameters to Dapper Select query for Oracle database

I'm trying to pass parameters to Dapper for a select query in an Oracle database, but somehow, it doesn't work with the ":" identifier....It works fine using string concatenation :...string req = "SELECT * FROM contact WHERE code_comite = '"; req ...

Sequence contains several elements Dapper

I'm using Dapper for retrieve a result of my request SELECT. ... List<dynamic> results = connection.Query("SELECT id_fonction from liste_personnels_fonctions where id_personnel = @id_personnel", new { id_personnel }).ToList(); ...But sometimes I have 2 re...