SQLite Error IDbCommand and IDbConnection implementation in the assembly System.Data.SQLite could not be found.

I just ran into a problem with SQLite and NHibernate, which was giving me this error message: The IDbCommand and IDbConnection implementation in the assembly System.Data.SQLite could not be found. The strange thing was, it worked fine from within Visual Studio, but it died when I used my ClickToBuild.bat file, which calls msbuild and runs […]

Untrusted Projects and Blocked Files in Visual Studio

I was just trying to open a project I was emailed as a zip file from a colleague.  VS2010 opens up saying: You should only open projects from a trustworthy source. The project file ‘project’ may have come from a location that isn’t fully trusted. It could represent a security risk by executing customer build […]

SELECT from a Stored Procedure

Occasionally I find myself wanting to SELECT from a SPROC in SQL Server.  Usually this is because I want to ORDER the results or filter them further with a WHERE clause.  Unfortunately, you can’t just do this:

There are several workarounds here, and the appropriate one depends mostly on whether you have any control […]

Avoid Regions for Interfaces in Visual Studio

Another quick tip related to the use of regions in your C# code – you can turn off the default behavior of wrapping interfaced implementations in regions via the options dialog.  Simply go to Tools –> Options –> Text Editor –> C# –> Advanced as shown in the screenshot below, and uncheck the “Surround generated […]

Moving SVN Repositories to new Server

Recently I had to move some SVN repositories from one server to another.  Here are the steps that worked for me, courtesy of Pete Freitag: Step 1: Back up SVN Repository Back up your existing repository with the following command.  Note that if you are using VisualSVN Server as I blogged about previously, you should […]

Silverlight Tools

As we approach the launch of Silverlight 4 and today the 2010 Winter Olympics begin (which are streaming via Silverlight!) I thought I’d post about some Silverlight Tools you may find useful as you build Silverlight applications.  Some of these are also good WPF or general XAML tools.  I haven’t used all of these personally […]

Tight Coupling, Legos, and Super Glue

Building software applications is sometimes compared with building structures out of smaller components.  The children’s toys, Legos (and their generic brethren), come to mind and in fact make for a good analogy.  Given a set of components with varying characteristics (shape, color, etc, or in the case of software, objects with different behavior and state), […]

Hiring Inbound Marketing Score CARD

In their book, Inbound Marketing (review), authors Shah and Halligan use a couple of acronyms that, maybe due to my military background, I thought could be improved.  The first one was VEPA, which I thought made a lot more sense as PAVE.  PAVE relates to qualities of a call to action, and it is easy […]

PAVE the Way to Effective Calls to Action

In their book, Inbound Marketing (review), authors Shah and Halligan describe some key traits of effective calls to action.  The four important qualities of killer calls-to-action are that they be Valuable, Easy-to-Use, Prominent, and Action-Oriented (chapter 8).  The authors go on to suggest that this be referred to as “VEPA”, but I think we can […]

Inbound Marketing and Small Business Trends

I recently read Dharmesh’s and Brian Halligan’s Inbound Marketing book, which has a lot of good tips for startup companies to follow in order to maximize their online reach and popularity.  Many of the tips are pretty obvious: start a blog, get people linking to you, build a following on twitter.  But there are some […]