LINQ 查询

Linq模糊查询

// Linq模糊查询
//n.Name.StartsWith(Name)－－相当于A%
//n.Name.EndsWith(Name)  －－相当于%A
//n.Name.IndexOf(Name)!=-1 --相当于%A%

var listWhere = list.Where(n=>n.Name.StartsWith(Name)||n.Name.EndsWith(Name)||n.Name.IndexOf(Name)!=-1);

或

var listWhere = list.Where(n=>n.Name.Contains(Name));

 

 

两级查询

 

  List<string> deleteIdList = (List<string>)Session["AdsSelectNodes"]; ;
            List<string> deleteIdListed;

            List<TTSBll.Entities.AdsInfor> storeSource = (List<TTSBll.Entities.AdsInfor>)this.StoreForAds.DataSource;

            var selectInfors = from adsInforList in storeSource
                               from selectRecID in deleteIdList
                               where adsInforList.Adsrecid.ToString() == selectRecID
                               select adsInforList;

 

 

//不一样类型对像的查询

 

        IEnumerable<string> aa=(IEnumerable<string> )_Realtimemonitor.Model.GetCarriersSelection().Select(x=>x.TerminalNo) ;

 

            var ss = from x in carriersViewModel.Model
                     join y in aa on x.TerminalNo.ToString() equals y
                     select x;