Tuesday, February 21, 2006

SharePoint SQL Lists

Having worked with SharePoint Lists for a while, we realized that they are not suited for enterprise applications - but for ad-hoc data capture and sharing.

Entity-Relation diagrams and other data modelling techniques can be leveraged in standard SQL, but can be exposed as Lists in SharePoint with automatic forms where needed. Various web parts are available for creating data, as well as maintaining relations between entities.

If you're interesting learning please Skype me.

2 comments:

chester23 said...

Any examples?

Morten Marquard said...

SharePoint 2010 will support SharePoint lists in SQL tables. The major difference from today is that each list can be placed in its own SQL table. I'm not sure whether or not you can manipulate the lists in SharePoint from SQL. I certainly hope so.

We have developed SharePoint SQL Lists (which we would like Microsoft to do) which support standard SQL operations. Adding an element to a list you simply use standard SQL operations such as SELECT, INSERT, UPDATE and DELETE.