Hanalei, Hawaii 9/2/2010
438 Posts and Counting

SubSonic: A Day In The Life Webcast Part 1 Is Ready

Thursday, May 17, 2007 -

Previously I posted a request for ideas RE a SubSonic "Green Screen" challenge, wherein y'all give me some ideas on an application I could work up and I would do a series of webcasts, showing me do just that. Lots of ideas were presented and they varied between CMS and Forums, and since our new Starter Site has a lot of CMS in it, I figured I'd go with forums.

Part 1 is ready, and it's HUGE (300M), 1 hr and 27 minutes long, and you can download it here.

It's a WMV file, as opposed to flash since many people have been complaining that FireFox crashes when they watch some of the larger flash webcasts. FireFox seems to have some memory issues is all I can say. To get around this, I made a WMV file you can watch and control in windows media.

The webcast actually covers a 4.5 hour development cycle, where I spin up (and modify) a Forums application from the ground up. You'll see me fumble my way along, talk to myself, say inappropriate things and so on (I tried to make this as real as I could, as if you were sitting next to me).

The audio is an atrocity, and you can thank Vista for that. I'm using the same microphone and audio settings, but lately Vista has an affinity for making me sound like Master Cylinder. I tried to edit it out as best I could but it still sucks - I'm sorry for that! At least if you use Windows Media you'll be able to throw down with some bass/treble tweakage.

What You'll See
As I mention I tried to break this up into "relative" chunks so that you wouldn't have to sit by while I type out code and listen to Low (The Great Destroyer is one of the best albums ever made). I try to stop at every major step and design shift, and explain why I'm doing what I'm doing.

Since this is part one, here's what you get:

  • I create the DB to handle the forums, and discuss the architectural approach
  • I create the initial site from the Starter Site, and break out the CMS and other things into multiple C# library projects
  • I spin up the data access
  • create the controller for the forums app, and show you how to make some perf compromises when dealing with ORM
  • create the first UI components: Forum Group and Forum listings

The interesting thing here is the architectural decisions made - if you have ever wondered how to fit SubSonic into an "Enterprise" application, and also how to override existing load patterns, extend a class, use external DLLs - then you might want to watch this.

Where's The Code?
When I get this to a stable point, I'm going to load it to source control and whoever wants at it will get commit access. I think it would be a fun test to see what happens if I open this up completely, for all to commit to it wiki-style!

Part 2 will come along and I promise I'll keep it shorter.

Related


Gravatar
Jim Bonnie - Thursday, May 17, 2007 - This is great - thanks for helping the community. I hope to get some insights into loading up UI elements beyond the data grid. Please tell me there is more life then the datagrid! The golf database program is coming soon..and yes a golf score card sure looks like a grid :)
Gravatar
Remmus - Friday, May 18, 2007 - Nice video. Very interesting to see how things develop and change as you go along.

One slight rant though...

when coding html I think all properties should be surrounded by quotes. Otherwise it is invalid markup I think. e.g. or not

I'm looking forward to seeing the next one and getting my hands on the code so I can work through it in the flesh.
Gravatar
Remmus - Friday, May 18, 2007 - Damn I should have guessed it would have done that to my previous post :(

was meant to be something like e.g. href="#" or href='#' not href=#
Gravatar
Alex - Friday, May 18, 2007 - Amazing! Thanks a lot!
Gravatar
Rob Conery - Friday, May 18, 2007 - @Remmus- You're totally correct on this - if there's a URL in there (aside from #) I make dern sure it's got quotes.
Gravatar
Jeremy - Friday, May 18, 2007 - I know it's not exactly mainstream - but rezipped the screencast with 7-zip and got it down to 124MB - might save some bandwidth.
Gravatar
kevin - Friday, May 18, 2007 - First, I love it. Your app architecture discussion at 58min is exactly the type of discussion I want to get to on ScribeSonic (which I finally just pushed live - www.scribesonic.com).

The splicing of SQL via the GetSql() method for GetForumGroups was an interesting technique. I really enjoyed this example the best because it was a unique way of using the utilites SS provides to implement in your design. I normally just use GetSql() to review, not resuse - very cool. The @Deleted# is definately a hack though. Anyway we could make that cleaner or is that just a convention of yours versus a SS requirement.

Agile Development - I enjoy the XP style of programming via the video.

Use of Page.Resolve - Dude, go for it. Using asp:Hyperlink generates more html output! Somethings are better left simple.

Overall I think you covered a terrific amount to start with... very enjoyable.

Side note - anyway to make SubCommander not generate certain table schemas (ie aspnet membership). The class generator observes my exclude list but SubCommander doesn't. or is that just me :P





Gravatar
vbplayr2000 - Monday, May 21, 2007 - Your solution/s have come just in time for us here. It is fascinating stuff and has helped me tremendously.

I REALLY look forward to the conclusion of the forum app development.

Anyway to get the databases and get a start on our own (following your demo video)? Some of us just aren't the SQL genius you are....

It would be good to go step by step recreating my own app and really leveraging the true power of SubSonic.

I'll talk to my superiors about a contribution to the SubSonic fund. I'll throw $20 bucks of my own in for starters. :-)

Regards,

vbplayr2000
Gravatar
vbplayr2000 - Monday, May 21, 2007 - Your solution/s have come just in time for us here. It is fascinating stuff and has helped me tremendously.

I REALLY look forward to the conclusion of the forum app development.

Anyway to get the databases and get a start on our own (following your demo video)? Some of us just aren't the SQL genius you are....

It would be good to go step by step recreating my own app and really leveraging the true power of SubSonic.

I'll talk to my superiors about a contribution to the SubSonic fund. I'll throw $20 bucks of my own in for starters. :-)

Regards,

vbplayr2000
Gravatar
stvjohnsn - Friday, May 25, 2007 - Very Cool....

When's the next installment? I have a forum idea I need to deploy...and I'd love to use SS.
Gravatar
briankb - Saturday, June 16, 2007 - thanks for all the webcasts. it really helps me to get up to speed. I'm just starting this one now but I'm curious when part 2 will be released.
Gravatar
monkey - Thursday, June 28, 2007 - Great stuff! Can you release this? or even mail it to me? even tho It's not stable - I'de like to play around with it and get some stuff going.
I LOVE THIS!
Gravatar
monkey - Thursday, June 28, 2007 - Great stuff! Can you release this? or even mail it to me? even tho It's not stable - I'de like to play around with it and get some stuff going.
I LOVE THIS!
Gravatar
monkey - Thursday, June 28, 2007 - Great stuff! Can you release this? or even mail it to me? even tho It's not stable - I'de like to play around with it and get some stuff going.
I LOVE THIS!
Gravatar
monkey - Thursday, June 28, 2007 - Great stuff! Can you release this? or even mail it to me? even tho It's not stable - I'de like to play around with it and get some stuff going.
I LOVE THIS!