how to get sharepoint data from sql DB

Question

Hi

i have a SharePoint site in which there are some lists and libraries now i need to build another application(mobile application not SharePoint mobile application) other that SharePoint which uses the SharePoint list and libraries data items

is there any way to get the data directly from the SQL of SharePoint Content DB.

---

Alen Austin

Answer 1

Hi Alen,

Directly interacting with a SharePoint content database will cause your SharePoint installation to lose Microsoft support.

Any interactions with SharePoint should be performed via the object model (Client or Server) or Web Services.

Please go through following URL for Client application design considerations for SharePoint 2010:

http://msdn.microsoft.com/en-us/library/ff798452.aspx

---

Please don't forget to 'mark answer/propose answer' or 'vote as helpful' as appropriate.

Answer 2

Hi Mahesh,

Client Object Model is used for SharePoint we are not using to show the Data into a SharePoint environment

it will be shown to some other application.

---

Alen Austin

Answer 3

Hello,

>Client Object Model is used for SharePoint

Client object model is not required to deploy into sharepoint environment so you can use it for your requirement. (Object model code is required sharepoint).

You can easily use this client model to get data from sharepoint site and show in any different application like: .NET, Mobile etc.

Another way is, There are some default web services provided by sharepoint, which can be called in third party application without any interaction with sharepoint so you can also use them. For Example: If you want to get data from list/library from sharepoint site then use lists.asxm web service. This service return result in XML format so easy to use in any mobile application.

http://msdn.microsoft.com/en-us/library/lists%28v=office.12%29.aspx

Hope it will clear your doubt

---

Hemendra:Yesterday is just a memory,Tomorrow we may never see
Please remember to mark the replies as answers if they help and unmark them if they provide no help.