Convert C# LINQ to VB.Net

Question

I was wondering if someone can help me convert the following code to VB.Net. Thanks a million!

var data = from l in this.MyData.MyAccountLists

                   select new
                   {
                       LastName = l.LASTNAME,
                       FirstName = l.FIRSTNAME,
                       MiddleName = l.MIDDLENAME,
                       Suffix = l.SUFFIX,
                   };

Answer 1

 

       It should look like this:

 

Dim data = from l In Me.MyData.MyAccountLists _
                       Select New With _
                       {               _
                       .LastName = l.LASTNAME, _

                       .FirstName = l.FIRSTNAME, _
		       .MiddleName = l.MIDDLENAME, _
                       .Suffix = l.SUFFIX, _
                       }

 

 

---

Tom Overton

Answer 2

Hi AZDev;

Tom Overton's solution is just missing one thing. In the Select clause when using the With keyword the property names need to have a . before the name as follows:

 

Dim data = from l In Me.MyData.MyAccountLists _
           Select New With _
           {               _
               .LastName = l.LASTNAME, _
               .FirstName = l.FIRSTNAME, _
               .MiddleName = l.MIDDLENAME, _
               .Suffix = l.SUFFIX _
           }

 

 

---

Fernando (MCSD)

If a post answers your question, please click "Mark As Answer" on that post and "Mark as Helpful".

Answer 3

Thanks , good catch Fernando!  I edited mine to show the dots , your example is the correct answer.   

---

Tom Overton

Answer 4

 

Not a problem Tom. I am always doing the same thing jumping between C# and VB .Net, my biggest problem is putting a semicolon at the end of a VB line of code.

 

---

Fernando (MCSD)

If a post answers your question, please click "Mark As Answer" on that post and "Mark as Helpful".

Answer 5

Fantastic! Thanks Fernandoo and Tom for your help! I really appreciate it! Awesome job!

Answer 6

Hi AZDev;

If the solutions of Tom and myself answered your question please mark them as as answer the question by clicking on "Mark As Answer" to complete the question.

Thank you.

---

Fernando (MCSD)

If a post answers your question, please click "Mark As Answer" on that post and "Mark as Helpful".