title: Easy way to convert between c# date and sql datetime
body: <p>I keep having the same problem in my c# projects. I try to insert datetime to sql table, but in Turkey. the date is always DD.MM.YYYY,  C# or SQL sometimes try to insert MM.DD.YYYY like American way.</p>
  
  <p>How do I solve this problem forever?</p>
  
  <p>here is an example code</p>
  
  <pre><code>string selectSql = @"INSERT INTO [RN_VEHICLES_GUEST_INOUT] ([PLAKA],[MY_DATE])  
                       VALUES(@PLAKA,@MY_DATE)
  
  cmd.Parameters.Add("@PLAKA", SqlDbType.VarChar, 50);
  cmd.Parameters.Add("@GELIS_TARIHI", SqlDbType.DateTime);
  
  cmd.Parameters["@PLAKA"].Value = txtPlaka.Text.ToString();
  cmd.Parameters["@GELIS_TARIHI"].Value = dateGelisTarihi.EditValue.ToString();
  </code></pre>
  
  <p>This code worked until today, It crashes today because today is 13.07.2013 and it tries to insert it as MM.DD.YYYY. yesterdat it was 12.07.2012 and I didnt have problem because it could convert 12 as a month but not 13. thats how I realized the problem.</p>
  
  <p>How can I make sure C# and SQL always work in DD.MM.YYYY format?</p>