Add/Insert style of petapoco vs dapper

Question

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 dapper

var a = new Article();
a.title="My new article";
a.content="PetaPoco was here";
a.date_created=DateTime.UtcNow;
string articleQuery= "INSERT INTO Article VALUES (@Title, @Content, @Date)";        
connection.Execute(articleQuery, new { Title = a.Title, Content = a.Content, Date = a.Date });

I am new to dapper and peta poco. It might be that there is more in dapper that I have not found but I really do not like the way I have to do an insert. Peta poco seems to do it very ormish.

Can dapper do this somehow too?

score 13 · Answer 1 · answered Oct 23 '13 at 14:06

13

If you like the PetaPoco style the better, just go for it. Although Dapper is more famous, PetaPoco has the same performance, has the same concepts but it's a bit more flexible (IMO)

answered Oct 23 '13 at 14:06

Eduardo Molteni

38,786
23
141
206

@Gaspa79 yes, you are right. Roughly enough for the vast majority of apps. – Eduardo Molteni Jul 24 '17 at 17:37
For MS Access/Jet database, PetaPoco is your saving grace. – hubert17 Dec 20 '20 at 17:06

score 7 · Accepted Answer · edited May 23 '17 at 10:30

7

Check out dapper extensions for 'magic' CRUD operations with Dapper:

using (SqlConnection cn = new SqlConnection(_connectionString))
{
    cn.Open();
    Person person = new Person { FirstName = "Foo", LastName = "Bar" };
    int id = cn.Insert(person);
    cn.Close();
}

Also see this thread for more...

edited May 23 '17 at 10:30

Community

1
1

answered Oct 22 '13 at 21:43

Void Ray

9,849
4
33
53

score -1 · Answer 3 · edited Jun 24 '16 at 14:02

-1

Developers use Drapper because of its performance. For many websites PetaPoco is good enough but if you want to extract all the server 'juice' use Drapper. In fact it is the ORM used by Stackoverflow. You can see all ORM performance comparison here

edited Jun 24 '16 at 14:02

alex.b

4,547
1
31
52

answered Mar 26 '15 at 13:00

Ricardo stands with Ukraine

4,508
2
42
59

6

dude performance of Dapper and PetaPoco is basically identical 49ms v 52ms (v 631 for EF in the example). – niico May 22 '16 at 13:23

Add/Insert style of petapoco vs dapper

3 Answers3