title: LINQ to SQL Update (C#)
body: <p>This is the script of my table:</p>
  
  <pre><code>CREATE TABLE ClientTypes
  (
      type_id int PRIMARY KEY IDENTITY,
      type_name varchar(250) not null,
      type_applications_list text,
      dtIntro datetime DEFAULT(getdate())
  )
  </code></pre>
  
  <hr>
  
  <p>And in ASP.net i'm trying to do this:</p>
  
  <pre><code>protected void btnActualizar_Click(object sender, EventArgs e)
      {
          var aplicacao = (from apl in dc.ClientTypes
                           where apl.type_id == tipoCliente
                           select apl).Single();
  
          aplicacao.type_name = txtAplicações.Text.ToString();
  
          dc.SubmitChanges();
      }
  </code></pre>
  
  <p>However, when it runs, it crashes and says:</p>
  
  <p>"The data types text and varchar are incompatible in the equal to operator."</p>
  
  <p>I really don't want to change the SQL Datatype to varchar, i would like it to stay in text.
  I have made some tests, with other datatype values, like int... and everything went well.</p>
  
  <p>I really don't understand this, has im using a control which returns a String.</p>
  
  <p>Thx in advance</p>
  
  <p>Can anyone help me?
  Thx in advance.</p>