For the life of me, I cannot get the SqlProfileProvider to work in an MVC project that I&#39;m working on.

The first interesting thing that I realized is that Visual Studio does not automatically generate the ProfileCommon proxy class for you.  That&#39;s not a big deal since it&#39;s simpy a matter of extending the ProfileBase class.  After creating a ProfileCommon class, I wrote the following Action method for creating the user profile.

&lt;pre&gt;&lt;code&gt;[AcceptVerbs(&quot;POST&quot;)]
public ActionResult CreateProfile(string company, string phone, string fax, string city, string state, string zip)
{
    MembershipUser user = Membership.GetUser();
    ProfileCommon profile = ProfileCommon.Create(user.UserName, user.IsApproved) as ProfileCommon;

    profile.Company = company;
    profile.Phone = phone;
    profile.Fax = fax;
    profile.City = city;
    profile.State = state;
    profile.Zip = zip;
    profile.Save();

    return RedirectToAction(&quot;Index&quot;, &quot;Account&quot;); 
}&lt;/code&gt;&lt;/pre&gt;

The problem that I&#39;m having is that the call to ProfileCommon.Create() cannot cast to type ProfileCommon, so I&#39;m not able to get back my profile object, which obviously causes the next line to fail since profile is null.

Following is a snippet of my web.config:

 

&lt;pre&gt;&lt;code&gt;&amp;lt;profile defaultProvider=&quot;AspNetSqlProfileProvider&quot; automaticSaveEnabled=&quot;false&quot; enabled=&quot;true&quot;&amp;gt;
    &amp;lt;providers&amp;gt;
        &amp;lt;clear/&amp;gt;
        &amp;lt;add name=&quot;AspNetSqlProfileProvider&quot; type=&quot;System.Web.Profile.SqlProfileProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a&quot; connectionStringName=&quot;ApplicationServices&quot; applicationName=&quot;/&quot; /&amp;gt;
    &amp;lt;/providers&amp;gt;
    &amp;lt;properties&amp;gt;
        &amp;lt;add name=&quot;FirstName&quot; type=&quot;string&quot; /&amp;gt;
        &amp;lt;add name=&quot;LastName&quot; type=&quot;string&quot; /&amp;gt;
        &amp;lt;add name=&quot;Company&quot; type=&quot;string&quot; /&amp;gt;
        &amp;lt;add name=&quot;Phone&quot; type=&quot;string&quot; /&amp;gt;
        &amp;lt;add name=&quot;Fax&quot; type=&quot;string&quot; /&amp;gt;
        &amp;lt;add name=&quot;City&quot; type=&quot;string&quot; /&amp;gt;
        &amp;lt;add name=&quot;State&quot; type=&quot;string&quot; /&amp;gt;
        &amp;lt;add name=&quot;Zip&quot; type=&quot;string&quot; /&amp;gt;
        &amp;lt;add name=&quot;Email&quot; type=&quot;string&quot; &amp;gt;
    &amp;lt;/properties&amp;gt;
&amp;lt;/profile&amp;gt;&lt;/pre&gt;&lt;/code&gt;

The MembershipProvider is working without a hitch, so I know that the connection string is good.

Just in case it&#39;s helpful, here is my ProfileCommon class:

&lt;pre&gt;&lt;code&gt;public class ProfileCommon : ProfileBase
    {
        public virtual string Company
        {
            get
            {
                return ((string)(this.GetPropertyValue(&quot;Company&quot;)));
            }
            set
            {
                this.SetPropertyValue(&quot;Company&quot;, value);
            }
        }

        public virtual string Phone
        {
            get
            {
                return ((string)(this.GetPropertyValue(&quot;Phone&quot;)));
            }
            set
            {
                this.SetPropertyValue(&quot;Phone&quot;, value);
            }
        }

        public virtual string Fax
        {
            get
            {
                return ((string)(this.GetPropertyValue(&quot;Fax&quot;)));
            }
            set
            {
                this.SetPropertyValue(&quot;Fax&quot;, value);
            }
        }

        public virtual string City
        {
            get
            {
                return ((string)(this.GetPropertyValue(&quot;City&quot;)));
            }
            set
            {
                this.SetPropertyValue(&quot;City&quot;, value);
            }
        }

        public virtual string State
        {
            get
            {
                return ((string)(this.GetPropertyValue(&quot;State&quot;)));
            }
            set
            {
                this.SetPropertyValue(&quot;State&quot;, value);
            }
        }

        public virtual string Zip
        {
            get
            {
                return ((string)(this.GetPropertyValue(&quot;Zip&quot;)));
            }
            set
            {
                this.SetPropertyValue(&quot;Zip&quot;, value);
            }
        }

        public virtual ProfileCommon GetProfile(string username)
        {
            return ((ProfileCommon)(ProfileBase.Create(username)));
        }
    }&lt;/code&gt;&lt;/pre&gt;

Any thoughts on what I might be doing wrong?  Have any of the rest of you successfully integrated a ProfileProvider with your ASP.NET MVC projects?

Thank you in advance...


All Profile Provider Solutions on Gang of Coders

Total of 1 Profile Provider Solutions

Implementing Profile Provider in ASP.NET MVC