About

SubSonic is a .net open source project developed by Rob Conery and a core team of developers including Eric Kemp, Scott Watermasysk, Jon Galloway, Phil Haack, and Gavin Joyce. The current stable release is version 2.0.3. Nightly builds are available in our SVN respository.

Tips and Tricks
Tags
soniccast

Using SubStage

Thursday, July 10 2008 - 2.1: Pakala

Eric put together a really nice "IDE" for working with SubSonic 2.1. This is a walkthrough on what it is and how to use it.

Making It Easy
We're really trying to make it simple for people use SubSonic and yes, we know, our docs aren't up to speed. In this screencast I go into how you can use our new tool, SubStage, to see all the options available to you with our Providers, and also how you can generate your code precisely how you want to - all visually.

Double-click the video to make it fullscreen - or you can download the WMV here

Tagged as:

#1 Darren Kopp on 7.10.2008 at 10:45 PM

Wow. I am going to make the executive decision to use Subsonic over NHibernate solely based on the fact that you used Tool as the intro music for your video.

#2 George J. Capnias on 7.11.2008 at 12:20 AM

Please, provide a download link for the video.

George J.

Ps: Vote for Tool intro on the video!

#3 Mihai on 7.11.2008 at 1:15 AM

Yes! Please do provide a link for the video. Us guys who have Silverlight 2.0 beta can't access it :P

#4 Rob Conery on 7.11.2008 at 2:46 AM

OK Done!

#5 Tracy on 7.14.2008 at 4:34 PM

I found an issue. I have a SQL Server 2005 database that has two tables with the same name, but created under different schema. Each table has different columns in it.

For example:

dbo.ConsultantTimeSlot

OriginalDesign.ConsultantTimeSlot

dbo.ConsultantTimeSlot has a field called DateAndTime.

OriginalDesign.ConsultantTimeSlot has a field called CTS_DateTime.

SubStage is confused by this. When I look under the provider at the tables, I see two tables named ConsultantTimeSlot, each with both of the columns DateAndTime and CTS_DateTime. So when I try to view the Scaffolds for each table, I am getting "Invalid column name CTS_DateTime" error. I tried to select "Disable Generate Table" on the second one, but it disables it for both tables.

Granted, most people will not have two tables called the same thing created under different schema, but it is a possibility, and may be something that you check for in a future release.

GREAT tool, though, and many thanks for it.

I'm just going to delete the OriginalDesign schema tables because I don't need them.

#6 Rob Conery on 7.14.2008 at 4:36 PM

>>>SubStage is confused by this<<<

I'm confused by this :)

>>>Granted, most people will not have two tables called the same thing created under different schema, but it is a possibility, and may be something that you check for in a future release.<<<

I don't think we'll support this scenario, sorry to say.

#7 Yanko on 7.20.2008 at 7:52 AM

You might want to point out that you need to run SubStage as an Administrator in Vista, otherwise it crashes upon start up. Unless I'm doing something wrong, in which case I apologize.

#8 Danno on 7.21.2008 at 10:06 PM

Got this when running SubStage on Vista Ultimate. Looks like debugging pdb files get unpacked, and svn info is referenced in the stack dump; so... conclusion: the distribution build is a debug/developer build not a release build.

System.UnauthorizedAccessException was unhandled

Message="Access to the path 'C:\\Program Files\\SubSonic\\SubSonic 2.1 Final\\SubStage\\root\\bin\\SubStage.exe' is denied."

Source="mscorlib"

StackTrace:

at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)

at System.IO.File.InternalCopy(String sourceFileName, String destFileName, Boolean overwrite)

at SubSonic.SubStage.SubStageForm.CopyToWebBinDirectory() in C:\svn\subsonicproject\trunk\SubStage\SubStageForm.cs:line 782

at SubSonic.SubStage.SubStageForm..ctor(String[] args) in C:\svn\subsonicproject\trunk\SubStage\SubStageForm.cs:line 97

at SubSonic.SubStage.Program.Main(String[] args) in C:\svn\subsonicproject\trunk\SubStage\Program.cs:line 30

InnerException:

Subscribe
© 2008 SubSonicProject.com. Use of this site is subject to our Terms of Use. All rights reserved. Duplication of this site, in part or in whole, is prohibited without prior written consent.