Executing stored procedure in Profile system

Hello,

I am using profile store to store custom profiles. I want to delete a record in my custom profile but before deleting the record i want to check that if that particular record's ID is used in any of the child records and for checking this I want to write stored procedures. So I want to know if there is any way that I can write stored procedures in the profile database and call them through the Profile Context. If anyone has done this before then please let me know.

Regards,

Faraz Hussain

[844 byte] By [Faraz_hs] at [2008-1-7]

«« unable to connect to remote graph in graphedit
»» Reg. sending mail through Direct Mailer to a newly created user (cs2007)

# 1

You can drop any stored procedure you want into the profiles database, but I would recommend putting custom objects into a different database. If you're worried about performance querying accross databases, don't be.

You can't use the ProfileContext to access custom stored procedures, but if you're using the sql helper classes and have all your custom data access centralized in a DAL, that's the best way to go.

Or in the near future, you can use extention methods and extend the ProfileContext class to include a new method which you would create to interact with your custom stored procedure.

pdewane at 2007-10-2 >

Commerce Server

Commerce Server 2007

Commerce Server Hot Topic

Commerce Server New Topic

Commerce Server

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech