in

ASP.NET Weblogs

Dave Burke - A freelance .NET Developer specializing in Online Communities

A freelance .NET Developer

My new SharePoint Article, uh, Tip

As my buddy SB Chatterjee mentioned (thanks, SBC!) I have a new article on extending Sharepoint at MSD2D.com.

Extend SharePoint Portal Server with ADO.NET and XML

Well, its like an article, cause its long, has pictures, coding excerpts, and includes a bio.  But its an MSD2D SharePoint Tip.  That's okay.  Big thanks to Dave Cragg at MSD2D for getting me started.

What I mean by “extending SharePoint” is, essentially, packaging up all of the Document Library data (using WebDAV and SPS2001 in the article), into an XML data layer and using ADO.NET to merge that data layer with other enterprise data (SQL Server data in our case) for applications with full access to SharePoint documents that do not require Digital Dashboard or even a browser, for that matter.

I like the MSD2D.com community and how it aggregates information on SharePoint, Exchange, etc. in one location.  The next article I'll probably be submitting for publication at MSD2D.com will be describing the process I used in migrating a SharePoint Portal Server 2001 Document Library containing 10,000+ documents to Windows 2003 Sharepoint Services. 

 

Published Jun 25 2004, 04:34 PM by daveburke
Filed under:

Comments

 

Steve Hall said:

Dave: The hyperlink to Figure 1 seems to be broken. Could you please have it fixed? Thanks!

BTW, your article is GREAT! It's exactly what I had wondered about, since my plans for a Dashboard app were nixed a while back. This should help me architect a solution that better fits our needs... Thanks for passing on your experience!
June 27, 2004 8:57 PM
 

Dave Burke said:

Steve, the figure 1 hyperlink is fixed. Thanks for pointing that out. Best regards with your project!
June 27, 2004 11:09 PM
 

Dana Harts said:

Interesting article, Dave.

However, the object-oriented tradition of creating a data layer is to encapsulate all of the data related methods in one place so that they are separated from the rest of the program logic (and can be reused over and over).

If you look at what Microsoft has done with its DAL (you can read about it at http://support.microsoft.com/default.aspx?scid=kb;en-us;829028), you can see that they have wrapped most of the neccesary data related methods into one dll.

I would be interested to hear of your experiences integrating this kind of data layer into SharePoint 2003.
August 2, 2004 4:41 PM
 

Dave Burke said:

Dana, Thanks for your comments! The point isn't about putting the DAL methods into a single DLL, its about putting the DATA in a single location. Maybe I misunderstood your point. There is no integration needed in SP2003, since the source of most application data is now SQL instead of SQL-WSS. Regards, Dave
August 2, 2004 4:46 PM

Leave a Comment

(required)  
(optional)
(required)  
Add
Terms of Use