SubSonic 2.0 Beta 3

SubSonic 2.0 Beta 3 is available for download: http://www.codeplex.com/actionpack/Release/ProjectReleases.aspx?ReleaseId=1387

Not a ton of info but you can see what was fixed. Keep yourself updated here, since CodePlex "seems to have an issue with updating RSS feeds in a timely fashion.": http://monk.thelonio.us/category/1.aspx

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

Followup: SubSonic in WinForms or DLL

Looks like the feature to use SubSonic in WinForms and DLL's will be added to the next SubSonic release!

Also there's a new version of the tool that works with the SubSonic 1.0.6 release. It also now works with Enterprise Library projects as well. Thanks DevInstinct / Martin!

SubSonic in WinForms or DLL

I was recently trying to get SubSonic integrated into my Business Layer DLL, which compiled with my web project, and found a great tool in the SubSonic forums. It was a bit of a nuisance to manually do this after each release but thanks to DevInstinct in the forum who has created a Custom Tool add-in for VS 2005 to allow you to use SubSonic in a DLL or EXE (You can use it in Web Application Projects and WinForms too).

This is great because now I can properly separate my Presentation Layer with my Business Layer and package SubSonic in only the Business Layer project! Scale away! This tool is great so go check it out and show support for it so we can get it added to a future SubSonic release.


P.S. I don't pay too much attention to punctuation or properly formatted paragraphs, enjoy ;-) oh and Happy New Year!

SubSonic 1.0.6 Released

Merry Christmas... SubSonic 1.0.6 was released on Tuesday.

No change log yet but we'll just have to wait and see.

SubSonic - Sweet!

I've been using SubSonic: The Zero Code DAL (formerly known as actionpack) for about two months now and I LOVE IT! SubSonic is a tool that helps a website build itself. Remember how long it took to write your SQL Data Access Layer? Well SubSonic takes care of all of that for you in a real-time ORM Mapping manner and even incorporates Views and Stored Procedures too!

My favorite part of SubSonic is that since I've started using it I haven't had to write ANY Data Access Layer functions at all. SubSonic takes care of everything. I can get a DataSet in my business layer by simply calling something like:

Public Function QueryAllProducts() as DataSet
Return New Query(Tables.Products).ExecuteDataSet()
End Function

That's it!! Also looking at the code you can see: Tables.Products... Yes, everything is Strongly-Typed too, even the Stored Procedures! The project is still under development but it's certainly a strong build, a few applications have already been built using SubSonic. So certainly join the community and give SubSonic a try.



Check out the 20 minute demo webcast: http://www.wekeroad.com/actionpackintro.html