title: Entity Framework Time Issue
body: <p>I am having issues with inserting time into my database using Entity Framework. </p>
  
  <p>Background: I am using a PC on UTC time to build this application. Once built I will deploy it on a server which is UTC + 1. The database it connects to is also on a server which is UTC + 1. </p>
  
  <p>So when I run locally onto my PC I put in a time such as 9am and it saves in the database as 10am. This is as expected. </p>
  
  <p>When I run on the server I put in a time of 9am and it saves in the database as 11am. This is not what i expected as it should have an hours difference not 2. </p>
  
  <p>Can anyone assist with this. My current code is:</p>
  
  <pre><code>     static void Main(string[] args)
      {
          DateTime Start = Convert.ToDateTime("27/04/2015 08:00");
          DateTime End = Convert.ToDateTime("27/04/2015 16:00");
  
  
          // generate a schedule
          ASML_ScheduleHeader schedule = new ASML_ScheduleHeader(); 
          schedule.ScheduleId = Guid.NewGuid();
  
          TimeZone localZone = TimeZone.CurrentTimeZone;     
          schedule.StartTime = localZone.ToLocalTime(DateTime.SpecifyKind(Start, DateTimeKind.Utc));
          schedule.EndTime = localZone.ToLocalTime(DateTime.SpecifyKind(End, DateTimeKind.Utc));           
  
  
          using (CIC40PrimaryEntities _context = new CIC40PrimaryEntities())
          {
              try
              {
  
                  Console.WriteLine("Adding Header");
                  _context.ASML_ScheduleHeader.Add(schedule);
                  _context.SaveChanges();
                  Console.WriteLine("Schedule added");
  
              }
              catch (Exception ex)
              {
                  Console.WriteLine("Schedule not added");
              }
  
              Console.Read();
          } 
      }
  </code></pre>