How to write c# code in contructor that will NOT be executed at design time by Visual Studio?

Question

I have a method call in the constructor of my user control that does something that won't work at design time (connecting to database), and the VS just bailed out when I tried to add that control to the GUI designer. Sure I can factor out those code to a separate method, but I don't like the idea that everytime I use that object I need to remember to execute a certain method which is essential to that object's function (that's what the constructor is for!).

Is there something like a preproccessor symbol that I can mark my code with so that the VS won't try to execute that code at design time?

Answer 1

In Windows Forms?

if (!DesignMode)
{
    // code that shouldn't be executed at design time
}

As others have mentioned, this won't work in the constructor. It's often used in the Form.Load event.

Answer 2

Have a look at this

Component.DesignMode Property

Answer 3

As others have stated, you can use the DesignMode property of the Component class. However, you will not be able to do this in the constructor of your control. The DesignMode property is always false in the constructor and methods called by the constructor. To get around this, re-factor your code to connect to the database in the OnLoad() callback. The DesignMode property is valid at that point. See here for the reasoning (look for the DesignMode section of the article).

I just ran across this blog entry that describes how to use the System.ComponentModel.LicenseManager.UsageMode property for doing the same thing. The blog describes an additional shortcoming of the DesignMode property when dealing with nested controls. Apparently, the UsageMode property doesn't have the same shortcomings and is available for use in the constructor. I cannot personally vouch for it, but might be worthwhile looking into.