Dapper Tutorial - Knowledge Base (KB)

Java Micro ORM equivalent

What would be the closest equivalent in Java to a Micro ORM such as ...Dapper..., ...PetaPoco..., ...Massive... or ...CodingHorror...?

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...

Increase performance on query with a lot of one-to-many mappings

I'm using Entity Framework to SQL Azure and in one page of my application we show quite a bit of related data to the user. We're loading a max of 30 items on the page but each item has 5 one-to-many mappings to other objects. The query time is at a reason...

Repository Pattern Where and Lightweight ORMs

For my IRepository, i would like:...To have it be usable by a micro-orm like dapper, petapoco, massive etc... for the SPEED...To have where clauses that get run on the server, hopefully using Expression/IQueryable style (which is also very swappable)...Is...

ORM for use with databases that have semi-flexible schema design

I like the "micro" approach of Dapper, Massive, PetaPoco etc. and I like to have control over the SQL we send to the database, most of the time it's relatively simple. I also like working with POCO's however when dealing with a somewhat flexible schema de...

Connect to Navision with Petapoco or Dapper using ODBC

I'm trying to connecto to Navision 2.60 using ODBC. I have a static class to manage the odbc connection....I want to use a ORM for mapping entities like Petapoco or Dapper, does anyone have an example of doing so?

Best strategies when working with micro ORM?

I started using PetaPOCO and Dapper and they both have their own limitations. But on the contrary, they are so lightning fast than Entity Framework that I tend to let go the limitations of it....My question is: Is there any ORM which lets us define one-to...

Replacements to hand-rolled ADO.NET POCO mapping?

I have written a wrapper around ADO.NET's DbProviderFactory that I use extensively throughout my applications. I also have written a lot of code that maps IDataReader rows to POCOs. However, as I have tons of classes the whole thing is getting to be a pai...

Dapper vs Petapoco - Easy data access in ASP.NET 4.5 Web Application

I want to use an ORM with my new ASP.NET 4.5 project. I am developing my project with Visual Studio 2012. I want to know what are the advantages of using various ORM products, including the following:...Entity Framework (seems the slowest)...Dapper (seems...

Add/Insert style of petapoco vs dapper

I am ...delighted... by this: ...// Insert a record with peta poco...var a = new Article(); a.title="My new article"; a.content="PetaPoco was here"; a.date_created=DateTime.UtcNow; db.Insert(a); ...I am ...distracted... by this:...// Insert a record with ...

Can you map column name in SqlFu?

Everything else about this micro ORM looks great, except I can't figure out how to map column name, like ...[Column("db_username")] public string UserName {get;set;} ...Did I miss something? Thanks

Dapper 'Characters found after end of SQL statement.' - Stop Dapper returning identity value

I'm using Dapper with Microsoft Access (not by choice I assure you) and I'm also using the Dapper.Contrib extensions to allow me to do ...connection.Insert(address).... Unfortunately that's throwing an error ...'Characters found after end of SQL statemen...

Handling varying number of result sets in Petapoco or Dapper?

I have used ...QueryMultiple... before for handling multiple result sets, but I knew the exact number of result sets being returned. In this case, when I call a stored proc with ...QueryMultiple..., the number of result sets returned varies. Is it possi...