Of SharePoint Nightmares and Dreams...
Oh I love to read this kind of stuff. :-) Check out Steve Hartzog's rave about the SmartPart (see his complete post for the 'nightmares' part):
But then I came across SmartPart (for ASP.NET 1.1) and Son of SmartPart (for ASP.NET 2.0). Within days I was able to create a ASP.NET 1.1 UserControl with database access (using basic ADO.NET) - whereas building the same part as an ASP.NET ServerControl would have taken 1.5-2 weeks!! Rapid prototyping at its best BABY!
And that's just the beginning! Now that we have a WSS2.0 site on ASP.NET 2.0, all dev's have VS2005 installed, and we know have a VSS 2005 box setup - I'm going to play with ADO.NET 2.0 and the new Enterprise Library for ASP.NET 2.0 (January 2006). With the new database reflection builtin to the new EL's DatabaseFactory (for strongly typed DataSets and stored procedure / parameters) and the new connectionStrings section of the 2.0 web.config's - I'm going to be in hog heaven. Oooh, I can't wait!