所以我有一個資料庫，我正在嘗試向 QueryBuilder 添加一個方法，該方法將像這樣回傳 IQueryable：
WHERE
student.Name == "Alan" OR student.Name == "Zoe" OR student.Name == "X" OR ...
我有一個可以是任何大小的名稱串列。
代碼如下所示：
public class QueryBuilder
{
private SudentData context;
private IQueryable<Students> query;
public QueryBuilder(StudentData context)
{
context = context;
query = context.Students;
}
public QueryBuilder WithDateFrom(DateTime date)
{
query = query.Where(x => x.Created >= date);
return this;
}
public QueryBuilder WithName(List<string> names)
{
if (name.Any())
{
//Missing query
return this;
}
else
{
return this;
}
}
public IQueryable<StudentDataModel> Build()
{
return query.Select(x => new StudentDataModel()
{
Name = x.Name,
DateTo = x.DateTo,
DateFrom = x.DateFrom
});
}
}
uj5u.com熱心網友回復：
你可以用這個：
public QueryBuilder WithName(List<string> names)
{
if (name.Any())
{
query = query.Where(x => names.Contains(x.Name));
return this;
}
else
{
return this;
}
}
轉載請註明出處，本文鏈接：https://www.uj5u.com/qianduan/396255.html
上一篇：幾個超火的在線編程網站，別錯過
下一篇：無法添加屬性，因為它已經存在？