LINQ query to select top five

Question

I have a LINQ query   var list   from t in ctn Items            where t DeliverySelection    true  amp  amp  t Delivery SentForDelivery    null            orderby t Delivery SubmissionDate            select t    How can I modify this query to select just five results from the database

User · Answer

The solution   var list    from t in ctn Items            where t DeliverySelection    true  amp  amp  t Delivery SentForDelivery    null            orderby t Delivery SubmissionDate            select t  Take 5

User · Answer

Just thinking you might be feel unfamiliar of the sequence From- Where- Select  as in sql script  it is like Select- From- Where   But you may not know that inside Sql Engine  it is also parse in the sequence of   From- Where- Select   To validate it  you can try a simple script   select id as i from table where i 3   and it will not work  the reason is engine will parse Where before Select  so it won t know alias i in the where   To make this work  you can try   select   from  select id as i from table  as t where i   3

User · Answer

var list    from t in ctn Items            where t DeliverySelection    true  amp  amp  t Delivery SentForDelivery    null            orderby t Delivery SubmissionDate            select t  Take 5

User · Answer

Additional information  Sometimes it is necessary to bind a model into a view models and give a type conversion error  In this situation you should use ToList   method   var list    from t in ctn Items        where t DeliverySelection    true  amp  amp  t Delivery SentForDelivery    null        orderby t Delivery SubmissionDate        select t  Take 5  ToList

User · Answer

This can also be achieved using the Lambda based approach of Linq              var list   ctn Items  Where t  gt  t DeliverySelection    true  amp  amp  t Delivery SentForDelivery    null   OrderBy t   gt  t Delivery SubmissionDate   Take 5

User · Answer

Offering a somewhat more descriptive answer than the answer provided by  Ajni    This can also be achieved using LINQ fluent syntax   var list   ctn Items      Where t  gt  t DeliverySelection    true  amp  amp  t Delivery SentForDelivery    null       OrderBy t   gt  t Delivery SubmissionDate       Take 5     Note that each method  Where  OrderBy  Take  that appears in this LINQ statement takes a lambda expression as an argument  Also note that the documentation for Enumerable Take begins with      Returns a specified number of contiguous elements from the start of a   sequence

[c#] LINQ query to select top five

Examples related to c#

Examples related to linq