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)

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...
.net dapper sql sqlcommand sqlconnection
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...
.net dapper orm stored-procedures
asked by Jalpesh Vadgama

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?
.net dapper
asked by Carlos Mendes

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...
.net c# dapper sql
asked by Joakim

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...
.net c# dapper
asked by Trev

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...
.net dapper mysql
asked by Gboyega Sulaiman

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...
.net dapper insert one-to-many sql
asked by Anil Ali

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...
.net c# dapper data-mapping
asked by Marko

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; ...
.net dapper multi-mapping
asked by Rakshit Bakshi

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.
.net c# dapper
asked by Kyle Nunery

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

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

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

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...
.net c# dapper
asked by Fermin

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.
.net dapper orm
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>( ...
.net dapper
asked by Tim Bailey

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...
.net dapper sql
asked by Marko

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...
.net abstract-class c# dapper reflection
asked by John

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...
.net c# dapper timeout
asked by sh-beta

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...
.net dapper sqlite
asked by BrokeMyLegBiking

Page 1 of 14
  • 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...