使用亚音速T4模板从一个表中删除多个记录? [英] Delete multiple records from a table using subsonic T4 templates?

问题描述

使用模板，如何在同一Delete语句中从一个表中删除多个记录?

Using templates, how can I delete multiple records from a table in same Delete statement?

推荐答案

您的问题有点模棱两可，但基于您发布的另一个问题，我想您正尝试根据ID列表或类似内容删除该问题.您可以使用流利的查询来做到这一点，如下所示:

Your question's a bit ambiguous but based on another question you've posted I think you're trying to delete based on a list of Ids or something similar. You can do that using a fluent query as follows:

List<int> peopleIds = new List<int> { 121, 122, 35, 4 };

new SubSonic.Query.Delete<Person>(new MyDB().Provider)
    .Where(PersonTable.IdColumn).In(peopleIds)
    .Execute();

这篇关于使用亚音速T4模板从一个表中删除多个记录?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！