Dapper Tutorial - Knowledge Base (KB)

How to use Dapper for paging and sorting?

I am giving the Dapper ORM a try. I am able to query data from a table using the code below: ...Dim comments As List(Of Comment) Using conn = New SqlConnection(ConnectionString) conn.Open() comments = conn.Query(Of Comment)("SELECT * from comme...

How to execute inserting and updating using Dapper?

I am interested in using Dapper - but from what I can tell it only supports Query and Execute. I do not see that Dapper includes a way of Inserting and Updating objects....Given that our project (most projects?) need to do inserts and updates, what is th...

How can I use Dapper to map lists of nested objects?

I'm currently using Entity Framework for my db access but want to have a look at Dapper. I have classes like this:...public class Course{ public string Title{get;set;} public IList<Location> Locations {get;set;} ... } public class Location{ p...

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

How to use Dapper with nested objects?

I have a customer who has dictated that I use Dapper ORM, which I've never used before. I have a problem with nested objects. I have a main class (Location) which has an embedded value object class (Address). The two classes look like this:...class Locati...

Do Dapper is safe from SQL Injections?

How does Dapper help protect against SQL injections? I am testing out different DAL technologies and have to choose one to be secure our site. I'm leaning towards Dapper (http://code.google.com/p/dapper-dot-net/), but need some help learning about securit...

How to use CancellationToken with Dapper async methods?

I'm using Dapper 1.31 from Nuget. I have this very simple code snippet,...string connString = ""; string query = ""; int val = 0; CancellationTokenSource tokenSource = new CancellationTokenSource(); using (IDbConnection conn = new SqlConnection(connString...

How to use Dapper to return a list of dynamic types (list<dynamic>)?

I have been using Dapper.net for a while now and its a very good ORM mapper which works great with .Net dynamic types....But I noticed that when Dapper retrieves data from a database it returns as ...DapperRow... type....Is there are any way that I can re...

How to create a multiple join query in Dapper?

I want to map complex object to dapper result from query which has two inner joins. I know we've solution to map one inner join but I want to map two inner joins result....Here is the Scenario:...My Classes are:...public class Order { public int id {...

How to use Dapper and query to return a complex entity?

I have a Customer class with the following properties:...public int Id { get; set; } public string Name { get; set; } public int AddressId { get; set; } public Address Address { get; set; } ...My goal is to write a Dapper query that will use an Inner Join...

With Dapper, how can you may map a list of nested entity?

I'm using Dapper and I have classes like this:...public class Region { public Region() { Countries = new List<Country>(0); } public int RegionID { get; set; } public int RiskRank { get; set; } public string Name { get; se...

How with Dapper to get data from a INNER JOIN sql?

I am working on DB operations on one project and developing WinForms App C# and I am using Dapper to get data out of DB, I am stuck at situation where I need to retrieve data using inner join. Eg. I've two tables Authors and Book as Follow : ...public cla...