Dapper: Is there a way to pass a Table-Valued Parameters to dapper on .Net Core right now?
mbuntic
All 5 comments
Not yet. Hopefully it'll work in netstandard2.0 (which we have a branch for already). They're working on these bits right now over in https://github.com/dotnet/corefx/issues/17126 and related issues.
NickCraver
on 17 May 2017
@NickCraver table-valued parameters based on IEnumerable\
@mbuntic in the meantime you can implement SqlMapper.ICustomQueryParameter for your TVPs as shown here: https://github.com/StackExchange/Dapper/blob/61e965eed900355e0dbd27771d6469248d798293/Dapper.Tests/Tests.Parameters.cs#L111 (the test works on .net core 1.x).
sergiivolchkov
on 13 Jun 2017
As soon as we get a new preview release on NuGet for SqlClient, we can merge this down into master - just waiting on that team to give us an updated lib to netstandard2.0 tests pass.
NickCraver
on 19 Jun 2017
TVPs are now in the latest alpha (both for netstandard1.3 and netstandard2.0, please give it a try and let me know if you hit any issues: https://www.nuget.org/packages/Dapper/1.50.4-alpha1-00070
NickCraver
on 14 Sep 2017
Dapper 1.50.4 is now out on NuGet, closing this out to cleanup: https://www.nuget.org/packages/Dapper/1.50.4
NickCraver
on 26 Nov 2017
Related issues
CrescentFresh
路
4Comments
yozawiratama
路
5Comments
wrjcs
路
5Comments
valinoment
路
4Comments
R2D221
路
4Comments
Most helpful comment
Dapper 1.50.4 is now out on NuGet, closing this out to cleanup: https://www.nuget.org/packages/Dapper/1.50.4