Dapper Tutorial - Knowledge Base (KB)

How with Dapper I can get values for child objects?

I am retrieving profile details with the following:...var profiles = connection.Query<Models.PROFILE>( "SELECT * FROM PROFILES WHERE ID=@ID", new { ID = profileID }); // IEnumerable var profile = profiles.First<Models.PROFILE>(); ...The profile o...

When passing in a model, how can I create a dynamic where clause using Dapper?

I have an example model that looks like this:...public class PersonModel { public int Id {get; set;} public string FirstName {get; set;} public string Lastname {get; set;} public string City {get; set;} } ...In my repository I want to ...