jump to navigation

Best Practice : SharePoint Database Access March 11, 2010

Posted by juanpablo1manrique in Best Practices, DAtabase, Developer, SharePoint.

Specifies any addition, modification, or deletion of the data within any SharePoint database by using database access commands. This includes bulk loading of data into a database, exporting data, or directly querying or modifying data.

Real World Example
A list aggregation Web Part that pulls information from a variety of sites in a server farm is designed to directly query the SharePoint database for information and present it to a user.

Technical Details
Directly querying or modifying the database can place extra load on a server, or can expose information to users in a way that violates security policies or personal information management policies. If server-side code must query data, then the process for acquiring that data should be through the built-in SharePoint object model, and not by using any type of query to the database. Client-side code that must modify or query data in SharePoint Products and Technologies can do this by using calls to the built-in SharePoint Web services that in turn call the object model.

Support Details
This type of customization is not supported.

Direct modification of the SharePoint database or its data is not recommended because it puts the environment in an unsupported state.

If a server component requires information from the database, it must get that data by using the appropriate items in the SharePoint object model, and not by trying to get the items from the data structures in the database through some query mechanism.

Versión en espeañol:: Buenas Prácticas: Acceso a base de datos


1. Buenas Prácticas: Acceso a base de datos « Letras y Números - March 11, 2010

[…] en Ingles : Best Practice : SharePoint Database Access Possibly related posts: (automatically generated)Bases de datos disponibles en la […]

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: