Enitity Framework Examples

query-columns.md

##Query Columns in a table

Using context As staffDBContext = New staffDBContext()
   Dim query = From m In context.tblStaffs
               Select New With
               {
                   .name = m.name,
                   .type = m.type,
                   .url = m.url
               }

   For Each result In query
       If result.type.ToLower = "advisor" Then
           Response.Write(result.url)
           Response.Write(result.name)
       End If
   Next         
End Using

update-record.md

##Update A Record

Using staffDBContext As New staffDBContext
    Dim query = From p In staffDBContext.tblStaffs
                Where p.name = "John Doe"
                Select p

    query.First.name = "Johnson Doeson"
    staffDBContext.SaveChanges()
End Using