这篇博客总结本人在实际项目中遇到的一些关于EF或者Linq的问题,作为以后复习的笔记或者供后来人参考(遇到问题便更新)。
目录
技巧1: DbFunctions.TruncateTime()的使用
有没有遇到做这样的错误:
LINQ to Entities does not recognize the method ‘System.String ToShortDateString()‘ method, and this method cannot be translated into a store expression.【LINQ to Entities不能识别‘System.String ToShortDateString()’方法】
System.NotSupportedException: The specified type member ‘Date‘ is not supported in LINQ to Entities. Only initializers, entity members, and entity navigation properties are supported.【LINQ to Entities不支持类型成员‘Date’,仅支持初始化器,实体成员和实体导航属性】
var query = from order in _orderRepository.GetAll()
.Where(o => o.OrderType == OrderType.LineSold)
.WhereIf(input.OrderDate!=DateTime.MinValue,o=>o.OrderDate.Date==input.OrderDate.Date)
.WhereIf(!string.IsNullOrEmpty(input.OrderNo),o=>o.OrderNo&