Is there a way to call a stored procedure with Dapper?

by

In the simple case you can do: 

var user = cnn.Query<User>("spGetUser", new {Id = 1}, 
        commandType: CommandType.StoredProcedure).First();

If you want something more fancy, you can do:

 var p = new DynamicParameters();
 p.Add("@a", 11);
 p.Add("@b", dbType: DbType.Int32, direction: ParameterDirection.Output);
 p.Add("@c", dbType: DbType.Int32, direction: ParameterDirection.ReturnValue);

 cnn.Execute("spMagicProc", p, commandType: CommandType.StoredProcedure); 

 int b = p.Get<int>("@b");
 int c = p.Get<int>("@c");

Additionally you can use exec in a batch, but that is more clunky.

More Related Contents:

  1. Dapper and SQL Injections
  2. SELECT * FROM X WHERE id IN (…) with Dapper ORM
  3. Does Dapper support SQL 2008 Table-Valued Parameters?
  4. How can you do paging with NHibernate?
  5. .net ORM Comparison [closed]
  6. Procedure expects parameter which was not supplied
  7. Why doesn’t Dapper dot net open and close the connection itself?
  8. Entity Framework is Too Slow. What are my options? [closed]
  9. Best free ORM tools to use with .NET 2.0/3.5 [closed]
  10. Binding a GridView to a Dynamic or ExpandoObject object
  11. Which method performs better: .Any() vs .Count() > 0?
  12. .NET obfuscation tools/strategy [closed]
  13. Nuget connection attempt failed “Unable to load the service index for source”
  14. Find out the size of a .NET object
  15. Why isn’t there an XML-serializable dictionary in .NET?
  16. What is the significance of ProjectTypeGuids tag in the visual studio project file
  17. Is there a UPnP Library for .NET (C# or VB.NET)? [closed]
  18. How do I add a reference to the MySQL connector for .NET?
  19. Remote machines cannot connect to Visual Studio web server
  20. What is the difference between native code, machine code and assembly code?
  21. DataGridView: How can I make the enter key add a new line instead of changing the current cell?
  22. Connection string using Windows Authentication
  23. Running Code Analysis (FxCop > 10) on build agent without installing Visual Studio
  24. Difference between UTC and GMT Standard Time in .NET
  25. Can you use the asp.net membership provider in a windows application?
  26. How to find USB drive letter?
  27. Drag Drop from .NET application to Explorer
  28. Determine whether .NET assemblies were built from the same source
  29. How to package a .NET Framework library? [closed]
  30. Overloading,Overriding and Hiding? [closed]

Leave a Comment