zzz projects Dapper Tutorial
Getting Started Documentation 3rd Party Libraries Knowledge Base Online Examples
  • Getting Started
  • Documentation
  • 3rd Party Libraries
  • Knowledge Base
  • Online Examples
  •   Download  

Dapper Tutorial - Knowledge Base (KB)

12 results in tag: orm

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...
dapper orm vb.net
asked by ericdc

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...
c# dapper orm
asked by Slaggg

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...
dapper orm
asked by b3n

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...
c#-4.0 dapper orm
asked by ElHaix

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...
c# dapper orm
asked by RWBear

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...
.net .net-3.5 dapper orm
asked by cdub

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...
.net async-await c# cancellation-token dapper
asked by Pedigree

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...
.net c# dapper orm
asked by Husni Jabir

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 {...
c# dapper mapping orm sql
asked by Saadi

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...
c# dapper dapper-extensions micro-orm orm
asked by Blake Rivell

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...
.net asp.net-web-api2 c# dapper orm
asked by Ameya Rane

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...
c# dapper micro-orm orm
asked by Infii

Page 1 of 1
  • 1

Prime Library

Performance

  • Entity Framework Extensions
  • Entity Framework Classic
  • Bulk Operations
  • Dapper Plus

Expression Evaluator

  • C# Eval Expression
  • SQL Eval Function
More Projects...
Get monthly updates by subscribing to our newsletter!
SUBSCRIBE!