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

[gameboyerik001]

string SQLstr="SELECT * FROM iFile WHERE fileStatus=1";

if(Textbox_Search.text.trim()!="")
{
SQLstr+=" AND (AppNo LIKE '%+Textbox_Search.text.trim()+%')";
SQLstr+=" AND (FileNo LIKE '%+Textbox_Search.text.trim()+%')";
SQLstr+=" AND (StaffNo LIKE '%+Textbox_Search.text.trim()+%')";
}

DataTable dt = SQLHelper.GetDataTable(SQLstr);


RT

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

为什么总感觉linq不如SQL灵活，是我用的不够熟练的事情吗？总感觉linq很像hql但是又不如hql好用

[moonwrite]

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

[-烟花雨季]

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));
                    //..........................
                }

[-烟花雨季]

艾玛，写错了

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));
                    //..........................
                }

[exception92]

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 );
}

[exception92]

引用 4 楼 duanzi_peng 的回复:

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 );
}

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

[q107770540]

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

[gameboyerik001]

主要是if里面的如何实现？

[smthgdin_020]

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表达式。);