Dapper Tutorial - Knowledge Base (KB)
2043 results
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.
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...
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...
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...
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 ...
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) ...
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...
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...
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...
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?
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...?
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..
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...
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...
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...
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 ..
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...
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...
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 ...
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...
asked by Anil Ali
Page 2 of 103