ASP.NET LINQ 删除行

Question

Dim db As New SQLDataContext
Try
    Dim deleteBoatPics = (From boat In db.Photos
                          Where boat.boatid = id)
    db.Photos.DeleteOnSubmit(deleteBoatPics)
    db.SubmitChanges()
Catch ex As Exception
End Try

我收到一条错误消息： 无法将“System.Data.Linq.DataQuery`1[WhiteWaterPhotos.Photo]”类型的对象转换为“WhiteWaterPhotos.Photo”类型。

我有两个单独的 db.SubmitChanges() 因为当按下按钮时，我让它从 1 个表中删除记录，然后再删除下一个表。

我迷路了，有人可以帮助我吗？

Answer 1

试试这个：

Dim db As New SQLDataContext
Try
    Dim deleteBoatPics = (From boat In db.Photos
                          Where boat.boatid = id).take(1).singleordefault
    if not deleteBoatPics is Nothing Then
       db.Photos.DeleteOnSubmit(deleteBoatPics)
       db.SubmitChanges()
    End If
Catch ex As Exception
End Try

或者对于元素列表：

Dim db As New SQLDataContext
Try
    Dim deleteBoatPics = (From boat In db.Photos
                          Where boat.boatid = id).ToList()
    if not deleteBoatPics is Nothing Then
       db.Photos.DeleteAllOnSubmit(deleteBoatPics)
       db.SubmitChanges()
    End If
Catch ex As Exception
End Try

Answer 2

尝试一下，

Dim db As New SQLDataContext
Try
    Dim deleteBoatPics = (From boat In db.Photos
                          Where boat.boatid = id
                          select boat)
    db.Photos.RemoveAll(deleteBoatPics)
    db.SubmitChanges()
Catch ex As Exception
End Try

我不太了解 vb.net，但在 C# 中，在该查询的末尾会有一个“选择船”并使用
全部删除(...)