Jim Bonnie's Blog

There are a few set-up steps that are required to create a class library and seperate DLL for a SubSonic Data Access Layer. To help avoid these repetitive steps I have created a Visual Studio 2005 project that can be re-used.

Read More »

In addition to generating your Data Access Layer for you, SubSonic comes with some other goodies that make building web applications easier. I was surprised to find that some of these controls work directly against the database schema and do not require the Data Access Layer to be pre generated at all

Read More »

This is the beginning of a series of Blog posts on using SubSonic with DotNetNuke. SubSonic is perfect to help simplify module development for people starting out with DNN. It is easy to get overwhelmed with the module development tutorials showing the abstract & concrete data providers, controllers, info classes, and stored procedures.

Read More »

I had a great time at the Philly Code Camp yesterday. My presentation slide deck is posted on the downloads section of this site. Thanks to those that attended and hope to see some of you in Vegas at dotnetnuke openforce.

Read More »

Once again I have to thank Carl Franklin and Richard Campbell of DotNetRocks fame for another amazing DoNet experience. DNR has been advertising the Ultimate Sharepoint weekend for developers which includes:

Read More »

There were a few posts about being able to run subsonic without making modification to the applications web.config file.

Rob Conery noted that this could be done, as the subcommander tool does this.

So I pinched some code from there and hereĀ is the barebones code to configure a subsconic provider in code.

DataService.Provider = new SqlDataProvider();

DataService.Providers = new DataProviderCollection();

DataProvider provider = DataService.Provider;

System.Collections.Specialized.NameValueCollection config = new System.Collections.Specialized.NameValueCollection();

config.Add("connectionStringName", ConfigurationManager.ConnectionStrings["SiteSqlServer"].ConnectionString);

provider.Initialize("SiteSqlServer", config);

DataService.Provider.DefaultConnectionString =

ConfigurationManager.ConnectionStrings["SiteSqlServer"].ConnectionString;

DataService.Provider.GeneratedNamespace = "JB";

DataService.Providers.Add(provider);

...

Read More »

Navigation

Register Login

About Me

Thanks for stopping by. My name is Jim Bonnie and I have been writing software for over 20 years. After building financial data systems for Reuters for nearly 18 years I have started doing contract work and am excited about technology and currently focus on Microsoft solutions. DotNetNuke has helped provide a good introduction to ASP.NET web application development, and I am now starting to branch out into other areas. Data Access techniques and SubSonic is something that I am looking into now. This has helped me get an invitation to speak at Las Vegas at DNN Open Force 07. it was a great time. And I am looking forward to OpenForce08, where I wil be presenting on TDD for DNN.

 

Reading the codebetter blogs and attending a nothing but .net training class with JP Boodhoo helped spark my interest in ALT.NET. I attended the first conference in Austin Texas, and it was amazing to see Scott Guthrie introduce the ASP.NET MVC framework.

Add to Technorati Favorites

View blog top tags

Links

Jim Bonnie's Blog

Jim Bonnie's Blog

Jim Bonnie's Blog