在ASP.NET中,可以使用以下代码示例从两个表中删除记录:
public class DeleteRecord
{
public int RecordId { get; set; }
public string TableName { get; set; }
}
public ActionResult Delete(DeleteRecord deleteRecord)
{
using (var db = new ApplicationDbContext())
{
if (deleteRecord.TableName == "Table1")
{
var record = db.Table1.Find(deleteRecord.RecordId);
if (record != null)
{
db.Table1.Remove(record);
db.SaveChanges();
}
}
else if (deleteRecord.TableName == "Table2")
{
var record = db.Table2.Find(deleteRecord.RecordId);
if (record != null)
{
db.Table2.Remove(record);
db.SaveChanges();
}
}
}
return RedirectToAction("Index");
}
@model DeleteRecord
@using (Html.BeginForm("Delete", "ControllerName", FormMethod.Post))
{
@Html.HiddenFor(model => model.RecordId)
@Html.HiddenFor(model => model.TableName)
}
在上述代码中,假设数据库上下文为ApplicationDbContext
,要删除的表名为Table1
和Table2
。在控制器的Delete
方法中,根据TableName
属性的值来决定从哪个表中删除记录。