Archives - February 2010
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...
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...
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: SELECT * FROM ( EXEC mySproc foo, bar) There are several workarounds here, and the...
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...
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...
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...
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...
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...
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...
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...
Azure Tip: How To Deploy a ZIP File to Windows Azure
Last month, The Code Project ran an Azure contest and gave away several Amazon Kindles . As part of the contest, which we hosted on Azure, we deployed a sample project with all of the necessary install files for getting started with Windows Azure. It turned out to be slightly more difficult than expected...
Prevent Resharper From Adding Regions
A couple of days ago I was annoyed that Resharper was insisting on turning my abstract base NUnit test class with nothing in it but a shared [SetUp] method into a one line class with a collapsed Setup / Teardown region in it. While I didn’t always feel this way, my experience has taught me that...
How to set up TRIM with Win7 and SSD Drive
I have an Intel X-25M SSD in my developer workstation machine (and it’s quite fast). However, I’ve heard from others that over time SSD performance can degrade due to sub-block level fragmentation that occurs as a result of write combining . Fortunately, newer SSD drives (like mine) support...
