在LinqPad中创建自己的数据示例

debugcn 发表于 Dev

鲁迪

我有一个类（vb.net），其中包含一些要在LinqPad中查询的数据。我已经处理过一些示例，例如“ Linq in Action”中的示例，因此它们也可以与某种带有数据的类一起使用，以解释查询。但是我只是找不到关于如何导入或编写自己的类的任何东西。有人可以在这里帮我吗？

我的班级看起来像：

Public Class Employee
    Public Property ID As Integer
    Public Property Salery As Integer
    Public Property Name As String
    Public Property Department As String
    Public Property Gender As String

    Public Shared Function GetAllEmployees() As List(Of Employee)
        Return New List(Of Employee) From { _
            New Employee With {.ID = 1, .Name = "Mark", .Department = "HR", .Gender = "Male", .Salery = 12000},
            New Employee With {.ID = 2, .Name = "Sandra", .Department = "IT", .Gender = "Female", .Salery = 2000} _
        }
    End Function
End Class

汤姆·布洛杰特

您可能会缺少有关使用LINQPad的一些注意事项：

将语言设置为“ VB程序”，然后将类放在注释所指向的位置。
使用该Dump方法输出表达式。（对于“ VB表达式”，Dump将自动调用。）

这是一个例子。（请注意，您可能正在使用看起来像SQL的语法。）

Sub Main

    Employee.GetAllEmployees() _
        .Where(Function (employee) employee.Department = "HR") _
        .Dump()

    Dim hrEmployees = From employee In Employee.GetAllEmployees() 
        Where employee.Department = "HR"
    hrEmployees.Dump()

End Sub

' Define other methods and classes here
Public Class Employee
    Public Property ID As Integer
    Public Property Salery As Integer
    Public Property Name As String
    Public Property Department As String
    Public Property Gender As String

    Public Shared Function GetAllEmployees() As List(Of Employee)
        Return New List(Of Employee) From { _
            New Employee With {.ID = 1, .Name = "Mark", .Department = "HR", .Gender = "Male", .Salery = 12000},
            New Employee With {.ID = 2, .Name = "Sandra", .Department = "IT", .Gender = "Female", .Salery = 2000} _
        }
    End Function
End Class

本文收集自互联网，转载请注明来源。

如有侵权，请联系[email protected] 删除。