Performing Inserts and Updates with Dapper

by

We are looking at building a few helpers, still deciding on APIs and if this goes in core or not. See: https://code.google.com/archive/p/dapper-dot-net/issues/6 for progress.

In the mean time you can do the following

val = "my value";
cnn.Execute("insert into Table(val) values (@val)", new {val});

cnn.Execute("update Table set val = @val where Id = @id", new {val, id = 1});

etcetera

See also my blog post: That annoying INSERT problem

Update

As pointed out in the comments, there are now several extensions available in the Dapper.Contrib project in the form of these IDbConnection extension methods:

T Get<T>(id);
IEnumerable<T> GetAll<T>();
int Insert<T>(T obj);
int Insert<T>(Enumerable<T> list);
bool Update<T>(T obj);
bool Update<T>(Enumerable<T> list);
bool Delete<T>(T obj);
bool Delete<T>(Enumerable<T> list);
bool DeleteAll<T>();

More Related Contents:

  1. Dapper and anonymous Types
  2. Entity Framework Code First – two Foreign Keys from same table
  3. Conversion of a datetime2 data type to a datetime data type results out-of-range value
  4. Entity Framework .Remove() vs. .DeleteObject()
  5. Correct use of multimapping in Dapper
  6. LINQ To Entities does not recognize the method Last. Really?
  7. How to implement Generic Repository Design Pattern with Dapper?
  8. How do I write one to many query in Dapper.Net?
  9. Minimal and correct way to map one-to-many with NHibernate
  10. Should I transform Entity (Persistent) objects to DTO objects?
  11. How do I perform an insert and return inserted identity with Dapper?
  12. Are there good reasons not to use an ORM? [closed]
  13. How to implement batch fetching with Fluent NHibernate when working with Oracle?
  14. Eager , Lazy and explicit loading in EF6
  15. Entity Framework | Sequence contains more than one matching element
  16. How do I handle Database Connections with Dapper in .NET?
  17. Problem using SQLite :memory: with NHibernate
  18. Why Entity Framework performs faster than Dapper in direct select statement [closed]
  19. What causes “extension methods cannot be dynamically dispatched” here?
  20. Code is WRONG but no error is raised
  21. Serialize Class containing Dictionary member
  22. What is the difference between a Shared Project and a Class Library in Visual Studio 2015?
  23. How to bind parameters via ODBC C#?
  24. Why do I get “System.Data.DataRowView” instead of real values in my WinForms Listbox?
  25. How to connect to a MS Access file (mdb) using C#?
  26. DataGridView keydown event not working in C#
  27. How do I Moq a method that has an optional argument in its signature without explicitly specifying it or using an overload?
  28. View Generated Source (After AJAX/JavaScript) in C#
  29. Connection to MySQL from .NET using SSH.NET Library
  30. Custom browsable property for Form at design time

Leave a Comment