在Visual Basic .NET中从LiteDB中选择/过滤数据

Imports LiteDB

Public Class MyClass
    Public Sub SelectData()
        Using db As New LiteDatabase("myDatabase.db")
            Dim collection As LiteCollection(Of MyData) = db.GetCollection(Of MyData)("myCollection")

            ' 选择所有数据
            Dim allData = collection.FindAll()

            ' 根据条件过滤数据
            Dim filteredData = collection.Find(Function(d) d.Name = "John")

            ' 执行查询并获取结果
            Dim result = filteredData.ToList()

            ' 遍历结果
            For Each data In result
                Console.WriteLine(data.Name)
            Next
        End Using
    End Sub
End Class

Public Class MyData
    Public Property Id As Integer
    Public Property Name As String
    ' 其他属性...
End Class