Advice on project Sharepoint (Store Procs to WebService)

[AT76]

Hello,

I have been asked to modify a project from the Back-end being SQL Server to Sharepoint. I need to create an Web Service that will access data from the Sharepoint via the web service and display into webforms. What I need some advice is there are currently lots of SQL store procedures which I will need to change to query Sharepoint instead of SQL Server. Any advice on the best approach to do this? Thank you in advice for any advice/comments provided!

 

[philhege]

The best practice in this case is to use the Sharepoint object model, instead of hand-coded SPs, to get the information you need. Microsoft doesn't recommend querying SPS databases directly, because the data model can and will change going forward.

Phil Hegedusich
Senior Programmer/Analyst
IIMAK

http://www.iimak.com

-----------
I'll have the roast duck with the mango salsa.

 

[AT76]

Phil,

Can you explain a little more. Could you perhaps show and example or a reference.

Thank you!

 

[philhege]

Look up the Sharepoint object model on MSDN (

http://msdn2.microsoft.com).

I can't get there right now to provide the direct link.

Phil Hegedusich
Senior Programmer/Analyst
IIMAK

http://www.iimak.com

-----------
I'll have the roast duck with the mango salsa.

 

[AT76]

No problem...

Thanks Phil! I appreciate your help!