这种SQL拼接用linq应该怎么实现？

Question

query = content.Where(.....)
if(string.isNullorW(extbox_Search.text))
{
query = query.Where(.....)
}if(...)
{
query = query.Where(.....)
}

Answer 1

var query = DbContext.iFile.Where(p => p.fileStatus=1);
                if (!string.IsNullOrEmpty(Textbox_Search.text.trim))
                {
                    query = query.Where(p => p.AppNo.Contains(Textbox_Search.text.trim));
                    //..........................
                }

Answer 2

艾玛，写错了
var query = DbContext.iFile.Where(p => p.fileStatus==1);//双等号，sorry
                if (!string.IsNullOrEmpty(Textbox_Search.text.trim))
                {
                    query = query.Where(p => p.AppNo.Contains(Textbox_Search.text.trim));
                    //..........................
                }

Answer 3

var query = from p in  iFile  where p.fileStatus ==1;
if(Textbox_Search.text.trim()!=""){
    string filter = Textbox_Search.text.trim();
     Func<iFile类, bool> filterFunc = p => (p.AppNo.Contains(filter ) || .....|| .......;
     query = query.Where(filterFunc );
}

Answer 4

当然 你的 并 关系， 把 || 换成 &&

Answer 5

http://blog.csdn.net/q107770540/article/details/5724013

Answer 6

LINQ查询：
var sql = from t1 in iFile 
          where t.AppNo.Contains(new string [] {Textbox_Search.text.trim}) 
                && t.FileNo .Contains(new string [] {Textbox_Search.text.trim}) 
                && t.StaffNo.Contains(new string [] {Textbox_Search.text.trim}) 扩展方法：
iFile.where(lambda表达式。);