tmsmith/Dapper-Extensions — Issue #29: Insert performance considerations
Author: root85
Created: 2012-01-27 06:10:00+00:00
State: open

Hi!

I've tried to insert an entity using conn.Insert(entity) method like

var user = new User { Name = "Test", GroupId = 1 };
conn.Insert(user, tran);

and found that performance of this operation is almost equal to EF4.2.

It would be great to improve this. Simple dapper query with explicit SQL text is 3 times faster than EF. Code is
conn.Execute("INSERT [Users] (Name, GroupId) VALUES (@Name, @GroupId)", user, tran);

Thank you.