How to Round() in Linq to SQL query?

Question

In a LINQ To SQL query, how can I apply a Round function on a column in my output?

My query is

  From s In oRecelDB.Items Where s.BIN = 'ABC' Select s.ITEMNMBR, s.QUANTITY

and the results are

ITEM I   35.0000
ITEM 2   45.0000
ITEM 3   23.0000

I want to remove the .00000 from the Second column value. How to do that in my query?

Answer 1

Simply convert the value to an Integer:

From s in oRecelDB.Items Where s.BIN = 'ABC' _
    Select s.ITEMNMBR, Quantity = System.Convert.ToInt32(s.QUANTITY)

Answer 2

If you really wanted to simply drop the decimal values use Math.Floor:

From s In oRecelDB.Items Where s.BIN = 'ABC' _
  Select s.ITEMNMBR, Math.Floor(s.QUANTITY)

It'll return you a decimal datatype. That may/not be what you want.