private static UserInfo ToUser(object[] r)
 {
     var u = new UserInfo
     {
         ID = new Guid((string)r[0]),
         UserName = (string)r[1],
         FirstName = (string)r[2],
         LastName = (string)r[3],
         Sex = r[4] != null ? Convert.ToBoolean(r[4]) : (bool?)null,
         BirthDate = (DateTime?)r[5],
         Status = (EmployeeStatus)Convert.ToInt32(r[6]),
         Title = (string)r[7],
         Department = (string)r[8],
         WorkFromDate = (DateTime?)r[9],
         TerminatedDate = (DateTime?)r[10],
         Email = (string)r[12],
         Location = (string)r[13],
         Notes = (string)r[14],
         Removed = Convert.ToBoolean(r[15]),
         LastModified = Convert.ToDateTime(r[16]),
         Tenant = Convert.ToInt32(r[17]),
         ActivationStatus = (EmployeeActivationStatus)Convert.ToInt32(r[18]),
         CultureName = (string)r[19],
         MobilePhone = (string)r[20],
         MobilePhoneActivationStatus = (MobilePhoneActivationStatus)Convert.ToInt32(r[21])
     };
     u.ContactsFromString((string)r[11]);
     return u;
 }