Helpco
سه شنبه 25 اردیبهشت 1397, 11:07 صبح
سلام من با کد فرس دارم کار میکنم وقتی یک جستجو بین دو تاریخ انجام میذم این خطا میده بهم
The specified type member 'Date' is not supported in LINQ to Entities. Only initializers, entity members, and entity navigation properties are supported.
اینم کد جستجو
var DataSource = db.CustomerPurchasingPowerr.Get(x => x.Archive==1
&& (x.Customer.name.Contains(texNameCu.Text) || IsNullOrEmpty(texNameCu.Text))
&& (x.Customer.mobile.Contains(TexMobileCu.Text) || IsNullOrEmpty(TexMobileCu.Text))
&& (x.MelkType == combTypeProperty.Text || IsNullOrEmpty(combTypeProperty.Text))
&& ( IsNullOrEmpty(Date_AZ.Text)|| x.Customer.UserrRecord.Value.Date >= Date_AZ.DateTime.Date) && (IsNullOrEmpty(Date_AZ.Text) || x.Customer.UserrRecord.Value.Date <= Date_TA.DateTime.Date)
)
.Select(x => new
{
x.Customer.Customer_id,
x.Customer.CodeDisplay,
x.Customer.name,
x.Customer.mobile,
x.Customer.phone,
x.MelkType
}).OrderByDescending(x => x.CodeDisplay).ToList();
The specified type member 'Date' is not supported in LINQ to Entities. Only initializers, entity members, and entity navigation properties are supported.
اینم کد جستجو
var DataSource = db.CustomerPurchasingPowerr.Get(x => x.Archive==1
&& (x.Customer.name.Contains(texNameCu.Text) || IsNullOrEmpty(texNameCu.Text))
&& (x.Customer.mobile.Contains(TexMobileCu.Text) || IsNullOrEmpty(TexMobileCu.Text))
&& (x.MelkType == combTypeProperty.Text || IsNullOrEmpty(combTypeProperty.Text))
&& ( IsNullOrEmpty(Date_AZ.Text)|| x.Customer.UserrRecord.Value.Date >= Date_AZ.DateTime.Date) && (IsNullOrEmpty(Date_AZ.Text) || x.Customer.UserrRecord.Value.Date <= Date_TA.DateTime.Date)
)
.Select(x => new
{
x.Customer.Customer_id,
x.Customer.CodeDisplay,
x.Customer.name,
x.Customer.mobile,
x.Customer.phone,
x.MelkType
}).OrderByDescending(x => x.CodeDisplay).ToList();