Does Dapper support SQL 2008 Table-Valued Parameters?

by

There is now (n Dapper 1.26 and higher) direct support for table-valued parameters baked into dapper. In the case of stored procedures, since the data type is built into the sproc API, all you need to do is supply a DataTable:

var data = connection.Query<SomeType>(..., new {
    id=123, name="abc", values = someTable
}, ...);

For direct command-text you have two other options:

  • use a helper method to tell it the custom data type: 

    var data = connection.Query<SomeType>(..., new {
    id=123, name="abc", values = someTable.AsTableValuedParameter("mytype")
}, ...);

  • tell the data-table itself what custom data type to use:

    someTable.SetTypeName("mytype");
var data = connection.Query<SomeType>(..., new {
    id=123, name="abc", values = someTable
}, ...);

Any of these should work fine.

More Related Contents:

  1. SELECT * FROM X WHERE id IN (…) with Dapper ORM
  2. Is there a way to call a stored procedure with Dapper?
  3. Why doesn’t Dapper dot net open and close the connection itself?
  4. Dapper and SQL Injections
  5. MSI vs nuget packages: which are is better for continuous delivery?
  6. How to do SQL Like % in Linq?
  7. Could not load file or assembly Microsoft.SqlServer.management.sdk.sfc version 11.0.0.0
  8. Case insensitive string compare in LINQ-to-SQL
  9. New asp.net charting controls – will they work with MVC (eventually)?
  10. How can I add a hint text to WPF textbox?
  11. DesignMode with nested Controls
  12. How do you keep user.config settings across different assembly versions in .net?
  13. What is the best implementation for AOP in .Net? [closed]
  14. How to get around the memory leak in the .NET Webbrowser control?
  15. EF LINQ include multiple and nested entities
  16. ServiceRoute + WebServiceHostFactory kills WSDL generation? How to create extensionless WCF service with ?wsdl
  17. How to build RUNAS /NETONLY functionality into a (C#/.NET/WinForms) program?
  18. How to work with Enums in Entity Framework?
  19. How to completely uninstall Visual Studio 2010?
  20. Can you get a Func (or similar) from a MethodInfo object?
  21. Is .NET’s StringBuilder thread-safe
  22. Coerce a WPF TextBox not working anymore in .NET 4.0
  23. Closing connection when using Dapper
  24. How to edit EXIF data in .NET [closed]
  25. Under what circumstances, we need to call GC.Collect twice
  26. Can I remove items from a ConcurrentDictionary from within an enumeration loop of that dictionary?
  27. NHibernate: Reasons for overriding Equals and GetHashCode
  28. How to serialize a large graph of .NET objects into a SQL Server BLOB without creating a large buffer?
  29. Powershell Unload Module… completely
  30. How to control appearance of ‘:’ in time zone offset when parsing/formatting Datetime

Leave a Comment