Convert C# linq to VB.net Linq

Question

4.00/5 (1 vote)

See more:

I am fairly new to some of the linq functionality and I was doing an example to improve my MVC skills and ran into this code I couldn't figure it out. I am using vb.net but the code came in C#. I couldn't figure out how to convert the linq version.

C#

public int GetCount()
   {
     // Get the count of each item in the cart and sum them up
     int? count = (from cartItems in storeDB.Carts
            where cartItems.CartId == ShoppingCartId
            select (int?)cartItems.Count).Sum();
     // Return 0 if all entries are null
     return count ?? 0;
   }
   public decimal GetTotal()
   {
     // Multiply album price by count of that album to get
     // the current price for each of those albums in the cart
     // sum all album price totals to get the cart total
     decimal? total = (from cartItems in storeDB.Carts
              where cartItems.CartId == ShoppingCartId
              select (int?)cartItems.Count *
              cartItems.Album.Price).Sum();
     return total ?? decimal.Zero;
   }

Posted 8-May-11 15:47pm

Member 7790032

Updated 8-May-11 17:39pm

Wild-Programmer

v2

Add a Solution

2 solutions

Solution 1

Use this online tool for such work @ http://www.developerfusion.com/tools/convert/csharp-to-vb/[^]
It converts code from C# to VB.NET and vice versa.

Posted 8-May-11 17:41pm

Wild-Programmer

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Member 7790032 · Accepted Answer · 2011-05-08T19:51:00

I have figured it out and most free code converter cannot convert LINQ

VB

Public Function GetCount() As Integer
            ' Get the count of each item in the cart and sum them up
            Dim count As System.Nullable(Of Integer) = (From cartItems In storeDB.Carts Where cartItems.CartId = ShoppingCartId Select (CType(cartItems.Count, System.Nullable(Of Integer)))).Sum()
            ' Return 0 if all entries are null
            Return If(count, 0)
        End Function
        Public Function GetTotal() As Decimal
            ' Multiply album price by count of that album to get
            ' the current price for each of those albums in the cart
            ' sum all album price totals to get the cart total
            Dim total As System.Nullable(Of Decimal) = (From cartItems In storeDB.Carts Where cartItems.CartId = ShoppingCartId Select CType(cartItems.Count, System.Nullable(Of Integer)) * cartItems.Album.Price).Sum()
            Return If(total, Decimal.Zero)
        End Function