Wsrtjtyk

I'm new to The Entity Framework. I need to show the result of two joined tables in a DataGridView and update the database when the user edited the data.

Without EF I usually fill a dataset and assign it to the DataSource property of a datatable and manually write the UpdateCommand. But don't know how to do this with EF.

This is how I'm implementing it right now:

Dim Query2 = From Product In db.Products

                 Join User In db.Users

                     On User.Id Equals Product.Owner.Id

                 Select New With {

                     Product.Id,

                     Product.Title,

                     User.UserName

                    }



DataGridView2.DataSource = Query2.ToList

Here's an example of the type of class I suggested:

Public Class UserProduct



    Private user As User

    Private product As Product



    Public Property UserName As String

        Get

            Return user.UserName

        End Get

        Set

            user.UserName = value

        End Set

    End Property



    Public Property ProductId As Integer

        Get

            Return product.Id

        End Get

        Set

            product.Id = value

        End Set

    End Property



    Public Property ProductTitle As String

        Get

            Return product.Title

        End Get

        Set

            product.Title = value

        End Set

    End Property



    Public Sub New(user As User, product As Product)

        Me.user = user

        Me.product = product

    End Sub



End Class

As you can see, the properties simply pass data through to the corresponding properties of the inner objects rather than storing it directly.

Your LINQ query would then become:

Select New UserProduct(user, product)