Sharepoint BDC

BDC [Business Data Catalog] is a service which part of MOSS 2007.
Its an middle man between external datasources and Sharepoint service.
It manages how the data should be passed between outside datasources are like
SQL Server and WebService using Metadata to Sharepoint service.
Example "DUET" its an collaboration software between SAP and Microsoft Office.
From SAP,Sibel or any other RDBMS data source can be used to supply the information to
SharePoint portal.
For this BDC uses the metadata to describe the APIs of business application.
This metadata model abstracts the underlying physical sources an provides a consistent and simple model of business applications to Sharepoint Service.

Runtime Object Model allows you to create,read,update and delete metadata objects in the Shared Services database.

Eventhandlers in MOSS 2007

Creating or adding extra customised features to the sharepoint components like
SharepointItems,List and WebEventReceivers is called "Features in Sharepoint/moss 2007".
usually developer create the customised action by deriving the event handler class of the sharepoints ie.SPItemEventReceiver,SPListEventReceiver and SPWebEventReceiver and attach to the sharepoint site.

Administrator installing the features and activate them on the site or web.

Synchronous Event:
Events that activate before the action occur
Example : FieldAdding event of SPListEventReceiver

Asynchronous Event
Events that activate before the action occur
Example : FiledAdded event of SPListEventReceiver

Sharepoint Object model

Sharepoint Object model

To programmatically deal with your Sharepoint services or officer server you need to
add the references Microsoft.Office.Server or Microsoft.Sharepoint to your
project.
You can find this references under
C:\Program Files\Common Files\microsoft shared\Web Server Extensions\12\ISAPI

These are my oftenly used classes.Here I categorised these classes

Document Library
SPDocumentLibrary
SPPictureLibrary

Features [ EventHandling in sharepoint you can find these in Feature.XML as attributes]
SPFeature
SPFeatureScope
SPFeatureProperty
SPElementDefinition

Site Level
SPSite
SPSiteCollection
SPWeb
SPSiteAdministration

List Level
SPList
SPListCollection
SPListItem


Solution Level
SPSolution
SPSolutionCollection
SPFeatureReceiver

Meeting

SPMeeting
MtgUtility

User Profile related [ Imports the namespace Microsoft.Office.Server.UserProfiles ]
UserProfiles
UserProfilesManager [ In moss 2007 installed farm,Its obsolete]

selecting records between two dates

ALTER procedure [dbo].[uspLeaveDetails](@User varchar(15),@FromDate datetime,@ToDate datetime)
AS
BEGIN

Select FromDate,ToDate,
NoOfDays,FirstName from UserDetails,LeaveDetails
where FromDate > =@FromDate AND ToDate <=@ToDate AND
UserDetails.USerID=@User
End