zzz projects Dapper Tutorial
Getting Started Documentation 3rd Party Libraries Knowledge Base Online Examples
English (en) Français (fr) Español (es) Italiano (it) Deutsch (de) русский (ru) 한국어 (ko) 日本語 (ja) 中文简体 (zh-CN) 中文繁體 (zh-TW)
  • Getting Started
  • Documentation
  • 3rd Party Libraries
  • Knowledge Base
  • Online Examples
English (en) Français (fr) Español (es) Italiano (it) Deutsch (de) русский (ru) 한국어 (ko) 日本語 (ja) 中文简体 (zh-CN) 中文繁體 (zh-TW)

Dapper Tutorial - Knowledge Base (KB)

English (en) Français (fr) Español (es) Italiano (it) Deutsch (de) русский (ru) 한국어 (ko) 日本語 (ja) 中文简体 (zh-CN) 中文繁體 (zh-TW)

1868 results for:

Any good samples for getting started with Dapper?

I'm trying to get started with Dapper in an exisiting MVC3 project and although it looks very easy to use, I can't seem to find any tutorials on how to set it up intially. Any links or suggestions would be highly appreciated....Thanks a lot.
asp.net-mvc-3 dapper orm
asked by Robert C.

Dapper: can I use parameters for anything?

I am writing some code that will prepare my database for my application. In the code there are some repetitive SQL statements when I am creating a table, and I want to hide them in some methods (there are only two for now: creating the primary key and mak...
dapper npgsql parameter-passing
asked by vhallac

Unit of Work pattern - managing parent child relationships

I'm using a micro-orm (dapper) and am trying to come up with a Unit Of Work (UoW) implementation for my repositories to use. I am a little bit stumped how best to deal with parent-child (foreign key) relationships in my UoW. So for example if I have the f...
c# dapper design-patterns orm unit-of-work
asked by Alex Webber

Dapper.NET and stored proc with multiple result sets

Is there any way to use Dapper.NET with stored procs that return multiple result sets?...In my case, the first result set is a single row with a single column; if it's ...0... then the call was successful, and the second result set will contain that actua...
dapper multiple-resultsets sql-server stored-procedures
asked by marc_s

Multi-Mapper to create object hierarchy

I've been playing around with this for a bit, because it seems like it feels a lot like the ...documented posts/users example..., but its slightly different and isn't working for me....Assuming the following simplified setup (a contact has multiple phone ...
dapper multi-mapping
asked by Jorin

Clarification of Dapper Example Code

I'm trying to grok Dapper and seem to be missing something very fundamental, can someone explain the following code taken from the Dapper home page on Google code and explain why there is no From clause, and the second param to the Query method (dynamic) ...
c# dapper
asked by Stephen Patten

Can AnsiStrings be used by default with Dapper?

I'm using Dapper against a database where strings are stored primarily in ...VarChar... columns. By default Dapper uses ...NVarChar... parameters when generating queries and while I can wrap each and every string parameter I use with ...DbString... it'd b...
c# dapper
asked by John Foster

How to insert an IEnumerable<T> collection with dapper-dot-net

Yep, there are ...questions here... and ...here... about how to insert records with dapper-dot-net. However, the answers, while informative, didn't seem to point me in the right direction. Here is the situation: moving data from SqlServer to MySql. Readin...
c# dapper insert vb.net
asked by IAbstract

How do I rewrite this to be more LINQy?

I have this set of data here. Events has a property ...EventGroups... that is of type ...List<Groups>...List<Events> e; List<Groups> g; // Get the data from the database using dapper using( var con = DataAccessMaster.GetOpenConnection( ) ) { using( v...
c# dapper linq
asked by jcolebrand

Read/Write distribution over MySQL Master/Slaves using Dapper

Would dapper have any problems with using two IDbConnection objects for distributing Writes and Reads between MySQL Master/Slaves?
asp.net c# dapper mysql
asked by Kynth

Java Micro ORM equivalent

What would be the closest equivalent in Java to a Micro ORM such as ...Dapper..., ...PetaPoco..., ...Massive... or ...CodingHorror...?
dapper java massive petapoco subsonic
asked by Kynth

Dapper parameterised queries with LINQ autogenerated types

I'm using a combination of LINQ and Dapper in my work. I'm replacing my LINQ code with Dapper in places for performance reasons. I have a lot of LINQ data objects created by dragging and dropping into the Visual Studio database diagram from SQL Server..
c# dapper linq
asked by Giles Roberts

Can the multimapping of Petapoco handle multiple JOINs?

I have a list objects I use to fill using Petapoco....The class properties and names are maching the database schema. The main class is ...Issue..., and it is related to two other classes which names and properties matches the database schema too : ...Con...
dapper join mapping petapoco
asked by Larry

Using Dapper with SQL Spatial Types as a parameter

I've got a system which basically has to do a query like this:...SELECT * FROM MyTable WHERE @parameter.STIntersects(MyGeometryColumn) ...This is quite simple to do when using vanilla SQL parameters, you just have to create your parameter in a non-typical...
dapper orm spatial sql-server-2008
asked by Erik van Brakel

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

Unexpected behaviour with a multi-mapping query using Dapper.net

I've only just started looking at Dapper.net and have just been experimenting with some different queries, one of which is producing weird results that i wouldn't expect....I have 2 tables - ...Photos... & ...PhotoCategories..., of which are related on ..
asp.net c# dapper mapping
asked by marcusstarnes

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

How to map multiple records from a single SP with Dapper-dot-net

I'd like to use Dapper in a situation where the execution of a single stored procedure will return 50 multiple separate selects, none of the individual result sets will be very wide, maybe 20 or 30 columns at most. The code below is from the Dapper Tests ...
c# dapper
asked by Stephen Patten

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

Page 2 of 94
  • «
  • 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...