使用Dapper将对象集合转换为TableValuedParameter
使用Dapper将对象集合转换为TableValuedParameter
提问于 2018-01-03 20:20:15
我尝试在dapper中使用TVP一次插入几行，如下所示：
con.Execute(@"
INSERT INTO Author (
FirstName,
LastName,
ParentAuthor
)
SELECT
FirstName,
LastName,
ParentAuthor
FROM @TVP
"
, new[]
{
new Author { FirstName = "Roger", LastName = "Smith", ParentAuthor = 1},
new Author { FirstName = "Stan", LastName = "Smith"},
new Author { FirstName = "Haley", LastName = "Smith"},
new Author { FirstName = "Francine", LastName = "Ling"}
} // .AsTableValuedParameter() => not working
);但是，有没有一种方便的方法将对象集合转换为TableValuedParameter呢？
回答 1
Stack Overflow用户
发布于 2018-01-03 20:49:07
我发现了fast-member，然后就可以简单地这样做了：
var items = new[]
{
new Author {FirstName = "Roger", LastName = "Smith", ParentAuthor = 1},
new Author {FirstName = "Stan", LastName = "Smith"},
new Author {FirstName = "Haley", LastName = "Smith"},
new Author {FirstName = "Francine", LastName = "Ling"}
};
var table = new DataTable();
using (var reader = ObjectReader.Create(
items,
nameof(Author.FirstName),
nameof(Author.LastName),
nameof(Author.ParentAuthor)
))
{
table.Load(reader);
}
con.Execute(@"
INSERT INTO Author (
FirstName,
LastName,
ParentAuthor
)
SELECT
FirstName,
LastName,
ParentAuthor
FROM @TVP
"
, new { TVP = table.AsTableValuedParameter("TVP_Author") }
);如果有类似功能的内置dapper，我还是想知道。
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/48077284
复制相关文章
相似问题
腾讯云开发者
