Get table data using entity framework using vb.net

Question

I am using this code to retrieve a table record from a table, I want to fill every cell data in a separate text box, what I can do next?

      Dim match = From p In students_entities.StudentsInformations
                                    Where p.ID = id
                                    Select p 
txtfirstName.text=????

I want for example retrieve the first name of a student who has id=1, when I use the previous statement it will retrieve a student record, how can I get his first name from the retrieved record? — Alaa
– Alaa, Commented Apr 29, 2013 at 7:47
txtfirstName.Text = p.First().FirstName assuming there is a match and you want to show the first match only. — Emond
– Emond, Commented Apr 29, 2013 at 7:52

Roar · Accepted Answer · 2013-04-29 07:52:04Z

1

in case when u select by id there is only one record should be, so u can do this

Dim match = (From p In students_entities.StudentsInformations
                                    Where p.ID = id
                                    Select p).FirstOrDefault
If match IsNot Nothing Then
   txtfirstName.text= match.FirstName
End If

or

Dim match = students_entities.StudentsInformations.FirstOrDefault(Function(f) f.ID = id)
If match IsNot Nothing Then
   txtfirstName.text= match.FirstName
End If

answered Apr 29, 2013 at 7:52

Roar

2,1574 gold badges24 silver badges39 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Roar Over a year ago

@Alaa, keep in mind that second one will be better about performance, NOT IN THIS ONE, but in case it's some collection. So my tip: always use second approach.

sohail.hussain.dyn · Accepted Answer · 2013-04-29 07:52:57Z

0

You should tell the EF that you want First row. Use the FirstOrDefault or Single function.

Dim match = From p In students_entities.StudentsInformations
                                Where p.ID = id
                                Select p 
txtfirstName.text= match.FirstOrDefault().name

answered Apr 29, 2013 at 7:52

sohail.hussain.dyn

1,5611 gold badge17 silver badges28 bronze badges

Collectives™ on Stack Overflow

Get table data using entity framework using vb.net

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related