title: How can Convert traditional ADO.Net search to Linq Entity
body: <p>first, sorry my bad English.
  in the traditional ADO.Net I used this function for search and got DataTable of rows to show in GridView or ...</p>
  
  <pre><code>public DataTable GetTableData(string fieldName, string value)
  {
      DataTable ds = new DataTable();
      SqlConnection scon = new SqlConnection("Data Source=.;Initial Catalog=ResearchPackDB;Integrated Security=True;");
      scon.Open();
      string str = string.Format("SELECT * FROM V_ScientificNews WHERE {0} LIKE {1}", fieldName, value);
      SqlDataAdapter sda = new SqlDataAdapter(str, scon);
      sda.Fill(ds);
      scon.Close();
      return ds;
  }
  </code></pre>
  
  <p>Now I want rewrite this function with Linq Entity, function like this!!</p>
  
  <pre><code>    public List&lt;V_ScientificNews&gt; GetNews(string fieldName, string value)
  {
      var q = (from r in _entities.V_ScientificNews
                  select r)
          .Where(?????????????);
      return q.ToList();
  }
  </code></pre>
  
  <p>if have any Idea please tell me. thanks</p>