dapper - Dapper 多项执行的参数名称
问题描述
使用 Dapper 使用此代码.Execute
:
using var c = new SqlConnection(ccstr);
var lst = new[] { 1, 2, 3 };
c.Execute("select @p", lst); // @p not recognized as parameter name
有没有办法@p
为这个原生对象列表设置一个参数名称(这里)?
解决方案
利用匿名对象
using var c = new SqlConnection(ccstr);
var lst = new[] {
new {p = 1},
new {p = 2}
new {p = 3} };
c.Execute("select @p", lst);
推荐阅读
- shell - Unix 与远程隐藏文件的并排区别
- javascript - Trigger count with Alert(right!) message
- amazon-s3 - Apache Flink 将 S3 用于后端状态和检查点
- amazon-web-services - Unable to connect via SSH to AWS Lightsail instance created from snapshot
- python - Tkinter - How can I remove the background borders from ttk.Button?
- javascript - 自定义椭圆形 SVG 图像中的填充百分比区域
- php - Conditionally create URLwith php and pass to jquery.ajax
- java - Is the Sonar rule for Spring '"@RequestMapping" methods should be "public"' accurate?
- javascript - Invisible captcha does not work in Chrome Lite mode
- visual-studio - Is there a way to suppress error messages for specific C# types in Visual Studio 2019?