我有以下2个表格:
public class TestA
{
public int Id { get; set; }
public string Name { get; set; }
public IEnumerable<TestB> Test { get; set; }
}
public class TestB
{
public int Id { get; set; }
public int TestAId { get; set; }
}
我的想法是,我可以从TestA对象访问与TestA相关的所有TestB记录。我想弄清楚的是如何插入Test A和TestB,特别是如果TestB有多个与Test A相关的行。这是我试过的:
var data = new TestA
{
Name = "ABC",
Id = 1,
Test = new List<TestB>
{
new TestB() { Id = 1, TestAId = 1},
new TestB() {Id = 2, TestAId = 1},
new TestB() {Id = 3, TestAId = 1}
}
};
var query = "INSERT INTO TestA(Id, Name) VALUES(@Id, @Name) INSERT INTO TestB(Id, TestAId) VALUES(@Test.TestB.Id, @Test.TestB.TestAId)";
using (var con = conn)
{
con.Execute(query, data);
}
我知道我们可以给dapper一个列表,并且它足够聪明地枚举该列表并插入单个记录,但是如果该列表是对象的子代码,我该如何完成同样的事情呢?我尝试使我的值也是@Test.Id, @Test.TestAId
但它有完全相同的错误。
Test.TestB类型的成员不能用作参数值
你能试一试吗:
var data = new TestA
{
Name = "ABC",
Id = 1,
Test = new List<TestB>
{
new TestB() { Id = 1, TestAId = 1},
new TestB() {Id = 2, TestAId = 1},
new TestB() {Id = 3, TestAId = 1}
}
};
var query = "INSERT INTO TestA(Id, Name) VALUES(@Id, @Name) INSERT INTO TestB(Id, TestAId) VALUES(@Test.TestB.Id, @Test.TestB.TestAId)";
using (var con = conn)
{
var query = "INSERT INTO TestA(Id, Name) VALUES(@Id, @Name)";
con.Execute(query, new { Id = data.Id, Name = data.Name });
foreach (var item in data.Test)
{
string processQuery = "INSERT INTO TestB(Id, TestAId) VALUES (@Id, @TestAId )";
connection.Execute(processQuery, item);
}
}