Entity Framework (Credit Walt Daniels)

Wiring up Entity Framework to DropDownList ASP.NET.

Prereq ---  Setup Entity Framework.


Private Sub FillSource()
        ctx = New Context()



        Dim qry = From p In ctx.tbl_names
                  Where p.ACTIVE = True
                  Order By p.name
                  Select p.id, p.name


        ddlFundSource.DataSource = qry.ToList()
        ddlFundSource.DataValueField = id"
        ddlFundSource.DataTextField = "name"
        ddlFundSource.DataBind()
        ddlFundSource.Items.Insert(0, New ListItem("[Any Fund]", "0"))    ' Tip if you want to add a default value.

    End Sub