More in this section
Forums / Developing with Sitefinity / Custom profile provider using SqlTableProfileProvider?

Custom profile provider using SqlTableProfileProvider?

The forums are in read-only mode. In case that you want to directly contact the Progress Sitefinity team use the support center. In our Google Plus group you can find more than one thousand Sitefinity developers discussing different topics. For the Stack Overflow threads don’t forget to use the “Sitefinity” tag.
2 posts, 0 answered
  1. Phill Hodgkinson
    Phill Hodgkinson avatar
    362 posts
    10 Nov 2004
    28 Mar 2008
    Link to this post
    Hey there,

    I'm wondering if anyone out there has attempted to replace the Sitefinity Profile provider with the SqlTableProvider (check it here  I've used this Provider method on other sites and it's a great solution to having profile properties as separate columns in profile table. More efficient than a separate record in profile table for each profile property.

    If no one has attempted it I'm going to give it a go and willb e sure to share the results/code. If someone has done it would you mind sharing any experiences?

  2. Yasen
    Yasen avatar
    121 posts
    18 May 2013
    01 Apr 2008
    Link to this post
    Hello Phill Hodgkinson,

    The reason we are using the technique with different row for every property is to preserve the ASP.NET default functionality. However, it is true that a fixed table with column for every property would be much more efficient.

    Thank you for sharing your experience with us. Probably, you'll easily set the profile provider with Sitefinity, but if you have any troubles, I'll be happy to help.

    All the best,
    the Telerik team

    Instantly find answers to your questions at the new Telerik Support Center
2 posts, 0 answered