LinqToSql PredicateBuilder How to retrieve the last inserted value

Asked Nov 11 '11 at 08:34

Active Nov 14 '11 at 07:54

Viewed 234 times

I have two tables

Table Products
-ID
-Name
-Description
...

And

Table Price
-ProductID
-Price
-DateAdded

How do I create a Predicate which we will return the list of products whose price is greater than 10

I tried the following query

Dim predInner As Expression (Of System.Func (Of tblProduct, Boolean)) = PredicateBuilder.True (Of tblProduct) ()
                     predInner = predInner.And (Function (a As tblProduct) a.tblPrice.Select (Function (c) c.Price). First ()> 10)
                     pred= pred.And (predInner)
Me.Grid.DataSource = vQuery.Where (pre)

but not always return the last inserted value. Is it possible for this part

a.tblPrice.Select (Function (c) c.Price). First ()

in some way to sort by column DateAdded

asked Nov 11 '11 at 08:34

SelvirK

1

Can you not do a.tblPrice.OrderByDescending(....).Select(...).First()? – Chris Dunaway Nov 14 '11 at 16:23
yes, thanks, this is solution :) – SelvirK Nov 16 '11 at 11:14
1

@ChrisDunaway you should post that as an answer to get the bounty... – Ahmad Mageed Nov 17 '11 at 19:31

LinqToSql PredicateBuilder How to retrieve the last inserted value

0 Answers0