HowTo: Strongly Typed View with SubSonic

I had a little trouble yesterday trying to get a Strongly Typed view working correctly in SubSonic. I spent a good 2 hours beating my brain trying to figure it out (I don't have internet at home yet - no Googling). Well after an hour break I came back and it hit me. It's very easy to implement, so lets start.

First off SubSonic will create your view as a collection. If your view is named v_RecentShares then you'll get a VRecentSharesCollection object.

You can then use that to query your view and iterate with a Strongly Typed reference:

Dim V as VRecentSharesCollection() = new VRecentSharesCollection().Load()
Dim Row as VRecentShares()
  
For Each Row in V
    Dim ShareName as String = Row.ShareName
Next

Book Review: 175 Ways to Get More Done in Less Time!

I just read through this book and it has some great tips. Straight and to the point, no models, history, deep discussions, etc... Just straight to the point, trivial tips that you can start using literally right now. If you're looking to get a few extra ideas on how to squeeze more time out of your day then this is a handy start.

I've got a few tips bookmarked. This isn't a one-time read, as a matter of fact I'll be going back and bookmarking a few more tips suggested in this book. This book even sprung another idea on me for my website.

The book is only 36 pages long and you can read through it, front to back, in no more than 15 minutes. You'll want a highlighter around to underline the tips that can help you. Most will help, some you already do, but you'll certainly pick up some new ideas.

175 Ways to Get More Done in Less Time!
by David Cottrell and Mark C. Layton
CornerStone Leadership Institute © 2004 (36 pages)
ISBN:0965878848