LINQ 문자열 검색 SQL Like 같이 하기

========= Contains 이용방법 =================

from var_table in db.table

where name.Contains(compare_stringName)

select var_table

 

========= SqlMethods.Like 이용방법 ==============

from var_table in db.table

where SqlMethods.Like(name, compare_stringName)

select var_table

 

========= StartsWidth 이용방법 ===================

from var_table in db.table

where name.StartsWith(compare_stringname)

select var_table