What's the equivalent VB.NET syntax for anonymous types in a LINQ statement?

c# .net vb.net linq anonymous-types
Ben McCormack picture Ben McCormack · Jun 29, 2010 · Viewed 17.7k times · Source

I'm trying to translate some C# LINQ code into VB.NET and am stuck on how to declare an anonymous type in VB.NET.

.Select(ci => 
    new { CartItem = ci, 
          Discount = DiscountItems.FirstOrDefault(di => di.SKU == ci.SKU) })

How do you translate C#'s new { ... } syntax into VB.NET?

Answer

Justin Niessner picture Justin Niessner · Jun 29, 2010

new { ... } becomes

New With { ... } in VB.NET,

or

New With {Key ... } if you want to use Key properties (which allows you to compare two anonymous type instances but does not allow the values of those properties to be changed).

So I'm guessing your statement would look like:

.Select(Function(ci) New With {Key _
    .CartItem = ci, _
    .Discount = DiscountItems.FirstOrDefault(Function(di) di.SKU = ci.SKU) _
})

Related questions

How to flatten nested objects with linq expression

I am trying to flatten nested objects like this: public class Book { public string Name { get; set; } public IList<Chapter> Chapters { get; set; } } public class Chapter { public string Name { get; set; } public IList<Page> Pages { get; …

Read More
Difference between Lookup() and Dictionary(Of list())

I'm trying to wrap my head around which data structures are the most efficient and when / where to use which ones. Now, it could be that I simply just don't understand the structures well enough, but how is an ILookup(…

Read More
What is the fastest way of deleting files in a directory? (Except specific file extension)

I have seen questions like What is the best way to empty a directory? But I need to know, what is the fastest way of deleting all the files found within the directory, except any .zip files found. Smells like …

Read More