不了解LINQ至SQL上的此错误

Question

好的，我有一个类，一个dbml文件和表单。我的项目称为"演示项目"

形式 - 从DBML -DataWorld类-tbldrivetimectivevendors

我的表格包含以下代码

 Imports System.Data.Linq.Mapping
 Public Class DriveTimeActiveVendorsForm
Private dc As New DataworldDataContext.DataworldDataContext
Dim _insert As New tblDrivetimeActiveVendors
Private Sub insertVendor()
    dc = New DataworldDataContext.DataworldDataContext
    _insert.ASRVendor = TextBox1.Text
    _insert.AddressLine1 = TextBox2.Text
    _insert.City = TextBox3.Text
    dc.tblDriveTimeActiveVendors.InsertOnSubmit(_insert)
End Sub
 End Class

我的班级包含以下

 Public Class tblDrivetimeActiveVendors

Private _ASRVendor As String = Nothing
Private _AddressLine1 As String = Nothing
Private _City As String = Nothing

Public Property ASRVendor() As String
    Get
        Return _ASRVendor
    End Get
    Set(ByVal value As String)
        If value Is Nothing Then
            _ASRVendor = Nothing
        Else
            _ASRVendor = value.Trim
        End If
    End Set
End Property
Public Property AddressLine1() As String
    Get
        Return _AddressLine1
    End Get
    Set(ByVal value As String)
        If value Is Nothing Then
            _AddressLine1 = Nothing
        Else
            _AddressLine1 = value.Trim
        End If
    End Set
End Property
Public Property City() As String
    Get
        Return _City
    End Get
    Set(ByVal value As String)
        If value Is Nothing Then
            _City = Nothing
        Else
            _City = value.Trim
        End If
    End Set
End Property

我在以下行中遇到错误

    dc.tblDriveTimeActiveVendors.InsertOnSubmit(_insert)

它的" _insert"部分，错误是

    Value of type 'WindowsApplication1.tblDrivetimeActiveVendors' cannot be converted to 'WindowsApplication1.DataworldEntity.tblDriveTimeActiveVendor'.    C:UsersrmonzingDocumentsVisual Studio 2008ProjectsDemoProjectDemoProjectDriveTimeActiveVendorsForm.vb   13  53  DemoProject

我在这里想念什么？谢谢

Answer 1

变量_insert被声明为类型tblDrivetimeActiveVendors（复数）的对象，但是InsertOnSubmit期望类型为" TBlDrivetimeactivevendor"（Singular）。

您代码中的某个地方已经声明了类tblDrivetimeActiveVendor，该类（大概）包含与数据库表中的列相对应的属性。您需要使用此对象而不是上面发布的类。