So, you can't get your property or you need store them in dbo.aspnet_* ?

If just get user profile, I config like this and it works:

<profile enabled="true" defaultProvider="SqlProfileProvider" automaticSaveEnabled="false">
      <properties>
        <add name="Code" type="System.String" />
        <add name="MarketId" type="System.String" allowAnonymous="true" />
      </properties>

After CurrentProfile was saved, you can get it using GetPropertyValue:

var profile = EPiServerProfile.Get("UserName");
profile["Code"] // This returns Code property.

I have no experience of using EPiServerProfile.Get with Commerce, so I can't comment on problems that may or may not occur.

When working with commerce I have always used the Commerce CustomerProfileWrapper class and I have not experience any issues surrounding its use with further custom properties.

var customerProfile = Security.Context.Current.CurrentUserProfile as CustomerProfileWrapper;

I hope this helps a bit.

@Son Do I already tried modifying the web.config from Commerce Manager in the same shape as your suggestion. It worked, yet as it doesn't inherit from CustomerProfile class anymore, it broke the Commerce Manager by raising exceptions everywhere telling me that several properties were missing.

@Martin Pickering I'll give it a try to your solution when I have a moment to spare (although I can't use the "Current" property as our objective is to implement new reports for CM and for every customer in the system). For the time being, I have decided to solve my issues by using a Business Foundation approach and modify the default Contact object so it includes the Code property I required (alongside being able to edit it from the CM at the Contact menu).

Thanks for the answers!

OK :) I've re-checked your config, It worked as our expected.

My added config:

<profile enabled="true" defaultProvider="CMSProfileProvider" inherits="Mediachase.Commerce.Customers.Profile.CustomerProfile, Mediachase.Commerce">
          <providers>
              <clear />
              <add name="CMSProfileProvider" type="Mediachase.Commerce.Customers.Profile.Providers.CustomerSqlProfileProvider, Mediachase.Commerce" connectionStringName="EcfSqlConnection" />
          </providers>
          <properties>
              <!-- ECF End -->
              <add name="MarketId" type="System.String" allowAnonymous="true" />

              <add name="WholesalersData" type="System.Collections.Generic.List`1[System.String]" />
              <add name="Code" type="System.String" />
              <add name="NumberColegiado" type="System.String" />
              <!-- <add allowAnonymous="false" defaultValue="" name="PageSettings" readOnly="false" serializeAs="ProviderSpecific" type="Mediachase.Commerce.Customers.Profile.CMPageSettings" />
                <add allowAnonymous="true" defaultValue="" name="ConsoleUILanguage" readOnly="false" serializeAs="ProviderSpecific" type="System.String" /> -->
          </properties>
      </profile>

And to get properties we can do like this:

var profile = EPiServerProfile.Get(SecurityContext.Current.CurrentUserName);
            profile["Code"] = "code-" + SecurityContext.Current.CurrentUserName; // This is sample to adding Code property
            profile.Save();

            myCode.Text = profile["Code"].ToString(); // This returns Code property.

I hope this can help :)

@Son Do thanks for your answer. Unafortunately, your approach, very strangely, doesn't work as I expect, it doesn't save any value I provide. I propose you to do the following:

Execute the following code of yours:

var profile = EPiServerProfile.Get(SecurityContext.Current.CurrentUserName);
profile["Code"] = "code-" + SecurityContext.Current.CurrentUserName; // This is sample to adding Code property
profile.Save();
myCode.Text = profile["Code"].ToString(); // This returns Code property.

The execute the following code. The "Code" property should still be there for a given profile:

var profile = EPiServerProfile.Get(SecurityContext.Current.CurrentUserName);
myCode.Text = profile["Code"].ToString(); // This returns Code property.

Re-Login with the given username, reexecute previous code, and the Code property magically disappears. This is very rare and unexpected.

I would also wish to know where the profile data gets saved, because they are not in the aspnet tables

Thanks!

Uhm, you're right about it. We cannot get profile by username right now, I will explain this case below. First is my solution:

You can save it via EPiServerProfile.Current

EPiServerProfile profile = EPiServerProfile.Current;
profile["Code"] = "code-" + profile.UserName;

And it can be get very simple:

EPiServerProfile profile = EPiServerProfile.Current;
profile["Code"] // Property Code.

Your question, where is profile data saved? As I known those properties was save in aspnet_Profile as usual. They're custom properties, so they're saved as binary.

And  EPiServerProfile.Get(SecurityContext.Current.CurrentUserName) can't be used on this case because Commerce create 2 user for each 'real' user - they'll be combined to use in Front-end and Back-end site.

I hope it works now :)

@Son Do thanks for your reply. Yet, I'm curious about one thing. If I would need to iterate over several Customer Profiles (which is my case) then how can I retrieve them without using the "Get" function on a loop? I guess that the "Current" property is not user in that case, am I right?

By the way, What's the reason about profile data being removed when logging in?

Thank you and kind regards,

David

I think you're right again, we cannot use "Current" in your case and sadly I'm not sure we can get list all or several customer profiles.

About profile data is removed, in my opinion, it is not removed :) I just think when we use EPiServerProfile.Get(SecurityContext.Current.CurrentUserName), it just can't get exactly profile we want or it can't save data properly using EPiServerProfile.Save() after Get().

@Son Do given these constraints about using the profiles, I have decided to crash my head against the Business Foundation objects approach. Let's see how this path works :). Thank you!