Dapper Tutorial - Knowledge Base (KB)
265 results for: in tag: .net
.NET SqlConnection and SqlCommand
I use SqlConnection and SqlCommand classes in my project with Dapper ORM but I've got a strange problem. When I use SqlCommand for inserting a row in a db table it always work correct and when I select updated data form tables everything is fine but after...
asked by shadeglare
Is there a way to call a stored procedure with Dapper?
I am very impressed with the results of ...Dapper Micro ORM... for stackoverflow.com. I am considering it for my new project and but I have one concern about that some times my project requires to have Stored Procedure and I have search a lot on web but n...
asked by Jalpesh Vadgama
Dapper - like operator using DynamicParameters
This works:...var list = conn.Query<int>( "select Id from Person where Id in @ids", new { ids = new int[] { 1, 2, 3 } } ); ...This throws "No mapping exists from object type System.Int32[] to a known managed provider native type.":...DynamicParameter...
asked by Trev
Dapper multiselect: Nested class primary key doesn't map unless using "AS"
I have two classes:...class Foo{ public int FooId { get; set; } ... public Bar Bar { get; set } } class Bar{ public int BarId { get; set; } public int FooId { get; set } ... } ...when i then run the query like this:...sqlConnectio...
asked by Joakim
Does Dapper support SQL 2008 Table-Valued Parameters?
Does anyone know if is possible to pass ...table-valued parameter... data to a stored procedure with Dapper?
asked by Carlos Mendes
Dapper mapping MySql BIT(1) data type to ulong instead of boolean
Please has anyone come across the above situation with Dapper and MySQL. In all my tables in MySQL (5.1), where the data type is BIT(1) or BIT, Dapper simply return such field as ulong (UInt64). I am using MySql.Data.MySqlClient and I have no such issue...
asked by Gboyega Sulaiman
Can I use DynamicParameters with Template and have a return parameter in dapper?
The system I am currently working on uses Stored Procedures for all data access. I'm looking into Dapper at the moment (so far it looks great) but I was wondering if I can use a DynamicParameters object created using a Template but make one of the parame...
asked by Fermin
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();...
asked by Richard Dingwall
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...
asked by marcusstarnes
Can Dapper batch a set of stored proc calls?
Can ...Dapper... batch a set of stored proc calls? I see it supports Multiple Results in the documentation but I'm not sure if you can execute multiple stored proc calls using Dapper.
asked by Kyle Nunery
Inserting One to Many Entities using dapper
I have following two classes and corresponding db tables. I am trying to insert the full object graph (student with multiple courses). I am looking for an example on how would one do this using Dapper. The Id's are auto-increment identity fields....Cla...
asked by Anil Ali
Dapper Syntax for Nested Multi Mapping
class Person { Address Addr { get; set; } int Age { get; set; } } class Address { string StreetName { get; set; } County Cnty { get; set; } } class County { string CntyName; ...
asked by Rakshit Bakshi
Dapper model mapping
I've been playing with ...Dapper... and I have a question. Is there a way for me to be able to have an enumerator type property in my POCO class and use Dapper? Seems like every time I add a property which is of type Enumerator I get the following excepti...
asked by Marko
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...
asked by hark
Improve performance of SQLite bulk inserts using Dapper ORM
I am working on a desktop application which uses SQLite to bulk insert tens of thousands of rows into a SQLite database. I would like help optimizing the bulk insert performance. It currently takes up to 50 seconds to insert 60 megs worth of data into the...
asked by BrokeMyLegBiking
Adjusting CommandTimeout in Dapper.NET?
I'm trying to run SQL backups through a stored procedure through Dapper (the rest of my app uses Dapper so I'd prefer to keep this portion running through it as well). It works just fine until the CommandTimeout kicks in....using (var c = SqlConnection(co...
asked by sh-beta
dapper PropInfo Setter for inherited EntitySet from abstract class reference is null
I am trying to replace a nasty LINQ 2 SQL hit with some dapper queries to improve performanace. In doing so I have to weave a bunch of different objects together in order to create the big object required to hold all the information I need for ASN informa...
asked by John
SELECT * FROM X WHERE id IN (...) with Dapper ORM
What is the best way to write a query with IN clause using Dapper ORM when the list of values for the IN clause is coming from business logic? For example let's say I have a query:...SELECT * FROM SomeTable WHERE id IN (commaSeparatedListOfIDs) ...Th...
asked by Marko
Dapper SqlMapperExtensions / Dapper.Contrib?
There seems to be a DapperExtensions project, but there is also a SqlMapperExtensions class in the Dapper project. Is there overlap? Is one preferred over the other? I can't find any documentation on Dapper.Contrib.
asked by user1003841
How do I get dapper to map an int to a boolean property
I have this class......public class MyDTO { public int Id { get; set; } public bool Selected { get; set; } } ...and then use dapper to attempt to create a list like this...... var list = this.db.OpenConnection().Query<MyDTO>( ...
asked by Tim Bailey
Page 1 of 14