1.[IQueryable]order by two or more properties

OrderBy(i => i.PropertyName).ThenBy(i => i.AnotherProperty)

2.OrderBy list for only Date but not Time 

error:The specified type member 'Date' is not supported in LINQ to Entities. Only initializers, entity members, and entity navigation properties are supported.

rderBy(i => EntityFunctions.TruncateTime(i.CreateDate))

    全站熱搜

    smartfly 發表在 痞客邦 留言(0) 人氣()