mvc.net2.0 达人请帮助怎么实现查询功能

C# code

        //查询        public ActionResult key(string keytxt)        {            ViewData["keytxt"] = keytxt;            var showstxt = dbconn.movie集.First(m => m.title == keytxt);            ViewData.Model = showstxt;            return View();        }//上面传值没有问题，就是不知道怎么dbconn.movie集里查记录,如以下//sql:select * from Cemetery where province like '%北京%'

C# code

var query= db.Table.Where(m=>m.province.IndexOf("北京"));//>>sql '%北京%"var query=db.Table.Where(m=>m.province.StartsWith("北京"));//>>sql "北京%"var query=db.Table.Where(m=>m.province.EndWith("北京"));//>>sql "%北京"
[解决办法]
bool b = (from a in _ary
  select a).Contains("");