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)

2043 results for:

Why doesn't Select() convert a IEnumerable<dynamic> to IEnumerable<StrongType>?

I'm trying to use Dapper simply to map my database tables to types in C#, however, some of my types need additional elements that are not in the table. To do this I am using a factory that can take column values and set the appropriate properties....publ...
c# dapper linq
asked by Doug Wilson

Dapper-dot-net "no column name"

I have a result set that might look like this:...ID (no column name) anotherID ---- ---------------- ---------- 1 super 3 1 super 4 3 duper 6 4 really 7 4 really ...
dapper
asked by John Sobolewski

Dapper with MVCMiniProfiler

I am wanting to use the MVCMiniProfiler with Dapper. Is this possible beyond wrapping the "Query" call from dapper in "Using Profiler.Step" block?...I have this basic Dapper call:...Dim comments As List(Of Comment) Using conn = New SqlConnection(Connectio...
dapper mvc-mini-profiler
asked by ericdc

Dapper performance results seem very similar on my machine

I ran the performance tests that came with the dapper source code: ...http://code.google.com/p/dapper-dot-net/...For the most part, the performance between the various data access methods were very very similiar, my results were in the 1200ms to 1500ms ra...
c# dapper performance
asked by codecompleting

Using Dapper with Oracle stored procedures which return cursors

How would one go about using ...Dapper... with Oracle stored procedures which return cursors?...var p = new DynamicParameters(); p.Add("foo", "bar"); p.Add("baz_cursor", dbType: DbType.? , direction: ParameterDirection.Output); ...Here, the DbType is Syst...
.net c# dapper oracle
asked by hark

Dapper is throwing an invalid cast exception when trying to set a boolean value returned from MySQL

I have this class...public class User { public int UserId { get; set; } public string UserName { get; set; } public bool IsValidated { get; set; } } ...And I'm populating it with this sql using dapper:...var users = connection.Query<User>("SEL...
dapper mysql mysql.data
asked by Glenn Slaven

Duplicate field name problem in a nested multi-mapping Dapper pagination query

I've ran into an issue when trying to do multi-mapping using Dapper, for pagination queries....Because I am using a nested query in this pagination scenario, there are multiple tables within the nested query that I must join to get my multi-mapped data, b...
.net c# dapper orm
asked by marcusstarnes

Is it possible to declare an anonymous type in C# with a variable/dynamic set of fields?

In C#, I would like to figure out if it's possible to declare an anonymous type where the fields are not known until run-time....For example, if I have a List of key/value pairs, can I declare an anonymous type based on the contents of that list? The spe...
anonymous-types c# dapper dynamic
asked by Egahn

Dapper micro ORM, database agnostic and MySql Guid type

I am experimenting ...Dapper... on a pet project. I am using ...SQLite... to run all the tests and MySql for "production". However I am not sure how to best use Dapper to handle database agnostic situation....The particular problem I am having is with MyS...
c# dapper mysql orm sqlite
asked by Jeff

Correct use of Multimapping in Dapper

I'm trying to use the Multimapping feature of dapper to return a list of ProductItems and associated Customers. ...[Table("Product")] public class ProductItem { public decimal ProductID { get; set; } public string ProductName { get; set; ...
dapper
asked by Richard Forrest

How do I map lists of nested objects with Dapper

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

Parameterized LIKE clause in SQL statement using Dapper

I want to perform the following query using Dapper, which currently doesn't return expected results (I think it must be treating the @pName param as literal text within the single quotes?):...var q = "SELECT * FROM Users WHERE Name LIKE '@pName%'"; ...@pN...
dapper sql
asked by marcusstarnes

Dapper.NET multi mapping TSecond Deserializer is null

I'm trying to perform a very standard multi mapping query using Dapper, and I'm getting the following error. I also get another error occasionally when this seems to work, but I'm unable to reproduce it at the moment. I'll append it to this post if/when t...
c# dapper mapping multi-mapping
asked by George

Dynamic where clause in dapper

Is it possible to add and remove criteria on the fly with dapper? I need this to implement user driven filtering. It is not feasible to have a query for each filter as there are too many combinations.
c# dapper orm
asked by NabilS

How can I use Dapper's strongly-typed query parameters with Sybase ASE?

Dapper... can pass query parameters as anonymous objects, and supports any ADO.NET data provider. However, when running the following query against the Sybase 15 ADO.NET drivers:...using (var connection = new AseConnection("...")) { connection.Open();...
.net ado.net dapper sybase-ase
asked by Richard Dingwall

how to convert Dictionary<dynamic, dynamic> to Dictionary<string, string> using Colllection.ToDictionary()

I am using Dapper to fetch a 2 column resultset into a dictionary. I noticed that intellisense shows me a .ToDictionary() when I hover over the resultset but I cannot get it to work since dapper uses dynamic properties/expandoObject...Dictionary<string, s...
c# c#-4.0 dapper expando expandoobject
asked by Gullu

Dapper - using multimapping with split points other than Id

I know this is similar to ...Correct use of Multimapping in Dapper..., but I think it's slightly different. ...I have the following POCO structure:...public class Customer { public int customerkey { get; set; } public string FirstName { get; set; ...
dapper
asked by dankorz

C# Database Mapper

I was looking to map my database query results to strongly type objects in my c# code. So i wrote a quick and dirty helper method on the SqlConnection class which runs the query on the database and uses reflection to map the record columns to the object p...
c# dapper orm
asked by newbie

How to get a bigint to a long object property from SQL Server using Dapper?

I have a ...bigint... in my table and when I try to do a select using Dapper, it is not working. I found a tip that said to cast to numeric, but that is throwing a invalid cast error....What is the correct cast to use with dapper?
asp.net c# dapper sql-server
asked by jpshook

Does Dapper work on Mono?

We're thinking about moving over to ...Mono... and I see that ...Dapper... works with MySql. However this is with a ADO.NET provider. Does Mono/Linux have a MySql ADO.NET provider and does that work with Dapper?...Eventually we are planning on moving our ...
c# dapper mono mysql postgresql
asked by thames

Page 4 of 103
  • «
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • …
  • »
  • »»

Prime Library

Performance

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

Expression Evaluator

  • C# Eval Expression
  • SQL Eval Function
More Projects...