/// <summary>
 /// Loads the given Profile object from the given database data reader.
 /// </summary>
 /// <param name="profile">The Profile object to load.</param>
 /// <param name="dr">The database data reader to read data from.</param>
 public static void LoadDataReader(Profile profile, IDataReader dr)
 {
     //SET FIELDS FROM ROW DATA
     profile.UserId               = dr.GetInt32(0);
     profile.PropertyNames        = dr.GetString(1);
     profile.PropertyValuesString = dr.GetString(2);
     profile.PropertyValuesBinary = NullableData.GetBytes(dr, 3);
     profile.LastUpdatedDate      = LocaleHelper.ToLocalTime(NullableData.GetDateTime(dr, 4));
     profile.IsDirty              = false;
 }
 /// <summary>
 /// Loads the given UserPersonalization object from the given database data reader.
 /// </summary>
 /// <param name="userPersonalization">The UserPersonalization object to load.</param>
 /// <param name="dr">The database data reader to read data from.</param>
 public static void LoadDataReader(UserPersonalization userPersonalization, IDataReader dr)
 {
     //SET FIELDS FROM ROW DATA
     userPersonalization.PersonalizationPathId = dr.GetInt32(0);
     userPersonalization.UserId          = dr.GetInt32(1);
     userPersonalization.PageSettings    = NullableData.GetBytes(dr, 2);
     userPersonalization.Theme           = NullableData.GetString(dr, 3);
     userPersonalization.MasterPageFile  = NullableData.GetString(dr, 4);
     userPersonalization.LastUpdatedDate = LocaleHelper.ToLocalTime(dr.GetDateTime(5));
     userPersonalization.IsDirty         = false;
 }