Welcome to Stephen's wiki. There is lots of really great content here - you just have to search for it.

This is a collection of random stuff I want to record for future reference. Probably not much use to anyone else.

Chris used an abstract base class. The following should be adapted for an interface, if possible.

/*
  <appSettings>
    <add key="definitionService" value="EA.ReportingPortal.Services.DbDefinitionService" />
  </appSettings>
*/ 
public abstract class DefinitionService
{
	public abstract List<CategoryTag> GetAllCategories();
	// ...
 
	public static DefinitionService Current
	{
		get
		{
			var activeServiceName = WebConfigurationManager.AppSettings["DefinitionService"];
			if (string.IsNullOrWhiteSpace(activeServiceName))
				throw new ConfigurationErrorsException("Definition Service type not specified or blank");
 
			var serviceType = typeof(DefinitionService).Assembly.GetType(activeServiceName);
			if (serviceType == null || !typeof(DefinitionService).IsAssignableFrom(serviceType))
				throw new ConfigurationErrorsException("Definition Service type does not exist or does not inherit from DefinitionService");
 
			var defaultConstructor = serviceType.GetConstructor(Type.EmptyTypes);
			if (defaultConstructor == null)
				throw new ConfigurationErrorsException("Definition Service type does not have an empty constructor");
 
			return (DefinitionService)defaultConstructor.Invoke(null);
		}
	}
}

((System.Data.Objects.ObjectQuery)myQuery).ToTraceString()

Or, if you want an extension method:

public static class IQueryableExtensions
{
    public static string ToTraceString<T>(this IQueryable<T> t)
    {
        ObjectQuery<T> oqt = t as ObjectQuery<T>;
 
        return oqt == null ? string.Empty : oqt.ToTraceString();
    }
}

1. [Visual Studio] Open Source Control Explorer.
2. [Visual Studio - Source Control Explorer] Right click the branch or folder to be ungetted.
3. [Visual Studio - Source Control Explorer] Select 'Get Specific Version…'
4. [Visual Studio - Get dialogue] Type: Changeset.
5. [Visual Studio - Get dialogue] Changeset: 1.
6. [Visual Studio - Get dialogue] Click Get. Bye bye local files and the branch / folder is updated correctly in the Source Control Explorer.

1. Open this page in a new browser window.
2. Setup a list for the results.
3. Create a new or reuse an existing route.
4. Create a run-once pocket query based on the route.
5. Sort the results by favourites and open each in separate browser tab.
6. Send each one to c:geo.
7. Bookmark the first one and add it to the list.
8. Bookmark all the rest.
9. Go back to the lists and create a pocket query based on it.
10. Check lots of boxes and Use the “Uncheck the day of the week after the query runs” option.
11. Go to pocket queries and delete it.
12. Wait for email.
13. Upload attached GPX file to phone.
14. Import caches into Locus.
15. Use uMap (Twitter log in).
16. Create new map and upload GPX file.

To print:

1. Open uMap page in Firefox.
2. F11 to full screen.
3. Ctrl + PrnScn (or whatever it is).
4. Open Paint.NET, paste & print.
5. Untick 'Fit picture to frame'.

1. [Visual Studio] Tools → WCF Service Configuration Editor
2. [Microsoft Service Configuration Editor] File → Open → Config File…
3. [Microsoft Service Configuration Editor] (Open the Web.config file)
4. [Microsoft Service Configuration Editor] Diagnostics (not a subnode)
5. [Microsoft Service Configuration Editor] Click Enable MessageLogging
6. [Microsoft Service Configuration Editor] Click Enable Tracing
7. [Microsoft Service Configuration Editor] File → Save
8. [] Rerun app and reproduce error or whatever.
9. [Windows Explorer] Open directory with Web.config in it.
10. [Windows Explorer] Double click Web_messages.svclog and Web_tracelog.svclog.

[DataType(DataType.Date)]
[DisplayName("Start date")]
[DisplayFormat(DataFormatString = "{0:dd/MM/yyyy}", ApplyFormatInEditMode = true)]
[Date(ErrorMessage = "Please enter a start date")]
public DateTime StartDate { get; set; }

1. Minimise all windows.
2. On the desktop, create a new file and name it 'test.udl'.
3. Double click it.
4. Select Provider and connection settings and play with them until they work.
5. Click ok.
6. Open 'test.udl' in a text editor. There is your connection string.

Visual Studio can sometimes get a bit confused about which TFS workspaces exist and which don't. Sort it out with the Visual Studio Command Prompt.

Figure out what workspaces really exist:

tf workspaces /collection:sourcecontrol.company.co.nz\DefaultCollection

Well and truly delete the motherfucker:

tf workspace /delete workspacename

If tf starts complaining about “Unable to determine the source control server”, try running the first command again (it seems to magically fix shit up or something):

tf workspaces /collection:sourcecontrol.company.co.nz\DefaultCollection

¹ Simple, Moderate, Advanced, Enterprise
² Gave up googling, api changes often, lots of out-of-date info on web.

<div @(item.Selected ? string.Empty : "style=display:none")></div>

Note that Razor is quite fussy about the format of the style=display:none bit. No spaces.

A less nice method that also works is:

<div class="notch" @(Html.Raw(item.Selected ? string.Empty : "style=\"display: none;\""))></div>

Generates SQL commands to drop everything in the database. Be careful you nuke the correct database…

USE [DATABASE]
 
SELECT 'DROP PROCEDURE ' + [Schema].name + '.' + StoredProcedure.name AS SqlCommand
       , 10                                                           AS SortOrder
FROM   sys.objects StoredProcedure
JOIN   sys.schemas [Schema]
ON     [Schema].schema_id = StoredProcedure.schema_id
WHERE  StoredProcedure.TYPE = 'P'
UNION
SELECT 'DROP VIEW ' + sys.objects.name
       , 20
FROM   sys.objects
WHERE  sys.objects.TYPE = 'V'
UNION
SELECT 'ALTER TABLE ' + [ParentTable].Name + ' DROP CONSTRAINT [' + [ForeignKey].name + ']'
       , 30
FROM   sys.objects [ForeignKey]
JOIN   sys.objects [ParentTable]
ON     [ParentTable].object_id = [ForeignKey].parent_object_id
WHERE  [ForeignKey].TYPE = 'F'
UNION
SELECT 'DROP TABLE ' + sys.objects.name
       , 40
FROM   sys.objects
WHERE  sys.objects.TYPE = 'U'
ORDER BY SortOrder

See ASP.NET MVC Security Check List.

On Windows 7 and above:

1. Start button.
2. Type Steps or PSR.
3. Click 'Record steps to reproduce a problem'.
4. Be amazed.

1. Download NuGet.Tools.vsix (look for it at nuget.org)
2. Uninstall NuGet from within Visual Studio.
3. Close Visual Studio.
4. Run the NuGet.Tools.vsix file to install the new version.

Search the application event log on the local machine:

LogParser.exe -i:evt -rtp:-1 "SELECT TOP 100 * FROM Application WHERE SourceName like '%Reporting%'" > d:\Temp\Output.txt 

Search the standard three event logs on the local machine:

LogParser.exe -i:evt -rtp:-1 "SELECT TOP 100 * FROM System, Application, Security WHERE SourceName like '%Reporting%'" > d:\Temp\Output.txt 

Search the application event log on a remote machine (may take a while):

LogParser.exe -i:evt -rtp:-1  "SELECT TOP 100 * FROM \\MachineName\Application WHERE SourceName like '%Reporting%'" > d:\Temp\Output.txt 

The -rtp:-1 option suppresses the “Press a key…” prompt.

In a Powershell console:

Get-Item *.jpg | ForEach-Object { convert $_ "$($_.basename).png" }

This also works:

Get-ChildItem 'C:\External Drives\Primary Media 2\My Pictures\Fractals\FA (Dual Monitor Wallpaper)' | Foreach { convert $_.FullName -resize 3840x1080! -quality 99 $_.Name }

For canvas prints through pixelpaint.co.nz, use 8E series images and convert to JPEG, < 15MB. Copy images from C:\External Drives\Primary Media 2\My Pictures\Fractals\8E (Printing) to a temp directory. Run this:

Get-ChildItem | Foreach { convert $_.FullName -quality 98 "$($_.basename).jpg" }

For any that are still bigger than 15MB, decrease quality and / or size (-resize 80%%).

1. Open Firefox and type about:config in the address bar.
2. In the Filter field enter network.automatic-ntlm-auth.trusted-uris.
3. Set the value to a comma separated list of sites:

   http://intranet.company.com,http://email.company.lan

How do I fix the following error:

‘dropdownlist1′ has a SelectedValue which is invalid because it does not exist in the list of items

1. Remove the SelectValue binding in the drop down:

   SelectedValue='<%# Bind("LocationId") %>'

2. In the code behind, add the following to the PreRender of the FormView:

   Protected Sub EmployeeDetailsFormView_PreRender(ByVal sender As Object, ByVal e As System.EventArgs) Handles EmployeeDetailsFormView.PreRender
   	If EmployeeDetailsFormView.CurrentMode = FormViewMode.Edit Then
   		Dim Location_DropDownList As DropDownList = CType(EmployeeDetailsFormView.FindControl("Location_DropDownList"), DropDownList)
    
   		Dim rowView As DataRowView = CType(EmployeeDetailsFormView.DataItem, DataRowView)
   		If IsNothing(rowView) Then Return ' Or perhaps throw an exception.
    
   		Dim locationId As String = rowView("LocationId").ToString() 
    
   		If Not IsNothing(Location_DropDownList.Items.FindByValue(locationId)) Then
   			Location_DropDownList.SelectedValue = locationId
   		Else
   			' TODO: Set the value to whatever it should be if there is no match.
   			Location_DropDownList.SelectedValue = "0"
   		End If
   	End If
   End Sub

3. Then add the following the ItemUpdating of the FormView:

   Protected Sub EmployeeDetailsFormView_ItemUpdating(ByVal sender As Object, ByVal e As FormViewUpdateEventArgs) Handles EmployeeDetailsFormView.ItemUpdating
   	Dim Location_DropDownList As DropDownList = CType(EmployeeDetailsFormView.FindControl("Location_DropDownList"), DropDownList)
    
   	e.NewValues("LocationId") = Location_DropDownList.SelectedValue
   End Sub

1. Open the Excel file in a Hex Editor (XVI32 will do nicely).
2. Search for the text string “DPB=”.
3. Change it to “DPx=”.
4. Save and close.
5. Open in Excel.
6. Open VBA project (Alt + F11) - ignore errors.
7. Right click the project and select Foo Properties…
8. Change the password and save.

1. In Visual Studio, from the main menu, select Test → Edit Test Settings → Local (Local.testsettings).
2. [Test Settings] Select the Save As button.
3. [Save As] Enter 'CodeCoverage.testsettings' and select OK.
4. [Test Settings] Select Data and Diagnostics.
5. [Test Settings] Enable Code Coverage.
6. [Test Settings] Double-click Code Coverage.
7. [Code Coverage Detail] Select the assembly or assemblies that you wish to have code coverage for. Normally this would be the non-test assemblies.
8. [Code Coverage Detail] Select OK.
9. [Test Settings] Select Apply and then Close.
10. [Save Dialog] Select Yes.
11. Done. Test settings should be checked into source control.

1. In Visual Studio, from the main menu, select Test → Select Active Test Settings → Local (CodeCoverage.testsettings).
2. Change the build configuration to Debug.
   1. From the main menu, select Build → Configuration Manager….
   2. [Configuration Manager] Set the Active Solution Configuration to Debug.
   3. [Configuration Manager] Select Close.
3. If the target is signed, temporarily remove it.
   1. Open the project properties.
   2. Select the Signing tab.
   3. Uncheck the Sign the assembly check box.
   4. Save the project.
4. Run the unit tests.
5. Turn the Code Coverage Colouring on and off in the Code Coverage Results window.

…and maintaining version history.

1. [SubVersion] Export the trunk to a temp directory.
   • C:\Temp\SuperApp\trunk
2. [Text Editor] In the temp solution, open the solution file.
   • C:\Temp\SuperApp\trunk\SuperApp.sln
3. [Text Editor] Find the section that has Web Site Project. It will look something like:

   Project("{E24C65DC-7377-472B-9ABA-BC803B73C61A}") = "SuperApp.Web", "SuperApp.Web", "{C92B633A-C441-4FB6-904B-EEA604BAAF15}"
   	ProjectSection(WebsiteProperties) = preProject
   		...
   		ProjectReferences = "{0A231AD6-AF0C-45C1-B441-2AB97BC40975}|SuperApp.DataAccess.dll;{96DC8217-C24D-4851-B4C2-92FBE60727CC}|SuperApp.Business.dll;"
   		...
   	EndProjectSection
   EndProject

4. [Text Editor] Note down any project references for later. In the example above, the Web Site Project references SuperApp.DataAccess.dll and SuperApp.Business.dll.
5. [Text Editor] Delete the entire Web Site Project (from Project to EndProject inclusive) and save.
6. [Windows Explorer] In the temp solution, delete the entire Web Site Project directory
   • C:\Temp\SuperApp\trunk\SuperApp.Web
7. [Visual Studio] Open the temp solution.
8. [Visual Studio] Create a new ASP.NET Empty Web Application in the old Web Site Project directory. Make sure it is the correct language (VB or C#)! The language of new ASP.NET Empty Web Application must match the existing Web Site Project.
   • C:\Temp\SuperApp\trunk\SuperApp.Web
9. [Visual Studio] Save and close.
10. [SubVersion] Copy and rename to a branch.
    • C:\Dev\SuperApp\trunk → C:\Dev\SuperApp\branches\Converting to Web App
11. [Text Editor] In the branch solution, open the solution file.
    • C:\Temp\SuperApp\branches\Converting to Web App\SuperApp.sln
12. [Text Editor] Remove the Web Site Project and save.
13. [Windows Explorer] Copy from the temp solution to the branch solution:
    • (C#) C:\Temp\SuperApp\trunk\SuperApp.Web\Properties → C:\Temp\SuperApp\branches\Converting to Web App\SuperApp.Web
    • (VB) C:\Temp\SuperApp\trunk\SuperApp.Web\My Project → C:\Temp\SuperApp\branches\Converting to Web App\SuperApp.Web
    • C:\Temp\SuperApp\trunk\SuperApp.Web\SuperApp.Web.csproj → C:\Temp\SuperApp\branches\Converting to Web App\SuperApp.Web
    • C:\Temp\SuperApp\trunk\SuperApp.Web\Web.Debug.config → C:\Temp\SuperApp\branches\Converting to Web App\SuperApp.Web
    • C:\Temp\SuperApp\trunk\SuperApp.Web\Web.Release.config → C:\Temp\SuperApp\branches\Converting to Web App\SuperApp.Web
14. [Text Editor] The Web.config in the branch solution probably does not need to be changed, but open both and check just in case.
    • C:\Dev\SuperApp\branches\Converting to Web App\SuperApp.Web\Web.config
    • C:\Temp\SuperApp\trunk\SuperApp.Web\Web.config
15. [Visual Studio] Open the branch solution.
16. [Visual Studio] In the Solution Explorer, turn on Show All files.
17. [Visual Studio] In the Web App project, include all the file and directories except the Bin and Obj directories.
18. [Visual Studio] Right click the Web App project and select Manage NuGet Packages.
19. [Visual Studio, Manage NuGet Packages dialog] If there is a message about restoring NuGet packages, do it.
20. [Visual Studio] Add the project references noted down in step 4.
21. [Visual Studio] Right click each ASPX file and select Convert To Web Application.
22. [Visual Studio] Set the Web App project as the start up project, and set the appropriate start page.
23. [Visual Studio] Cross fingers and run it.

<script src="../Scripts/jquery-1.7.2.min.js" type="text/javascript"></script>
<script type="text/javascript">
	$(document).ready(function () {
		$(".CollapsibleTrigger").click(function (event) {
			$(this).next().toggle();
 
			if ($(this).next().is(':visible'))
				$(this).addClass('Expanded');
			else
				$(this).removeClass('Expanded');
		});
	});
</script>

<asp:ListView ID="Foo_ListView" runat="server" DataSourceID="Foo_Logic" DataKeyNames="FooID" >
	<LayoutTemplate>
		<table class="DataWebControlStyle" cellspacing="0" cellpadding="2" border="1">
			<tr class="GridHeader">
				<th>Blah</th>
				...
			</tr>
			<asp:PlaceHolder ID="itemPlaceholder" runat="server" />
		</table>
		<asp:DataPager runat="server" ID="ContactsDataPager" PageSize="50">
			<Fields>
			<asp:NextPreviousPagerField ShowFirstPageButton="true" ShowLastPageButton="true"
				FirstPageText="|&lt;&lt; " LastPageText=" &gt;&gt;|"
				NextPageText=" &gt; " PreviousPageText=" &lt; " />
			</Fields>
		</asp:DataPager>
	</LayoutTemplate>
	<ItemTemplate>
		<tr class='<%# String.Format("{0} CollapsibleTrigger", Me.AlternatingGridRowClass()) %>'>
			<td><asp:Label ID="Foo_Label" runat="server" Text='<%# Eval("Foo") %>' /></td>
			...
		</tr>
		<tr class="CollapsibleRegion" style="Display: none;">
			<td><asp:Label ID="Bar_Label" runat="server" Text='<%# Eval("Bar") %>' /></td>
			...
		</tr>
	</ItemTemplate>
</asp:ListView>

Private _alternateRow As Boolean
Protected ReadOnly Property AlternatingGridRowClass() As String
	Get
		_alternateRow = Not _alternateRow
		Return If(_alternateRow, "GridAlternatingRow", "GridRow")
	End Get
End Property

Protected Sub Foo_ObjectDataSource_Updating(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.ObjectDataSourceMethodEventArgs) _
	Handles Foo_ObjectDataSource.Updating
 
	Dim iod As IOrderedDictionary = e.InputParameters
	For Each de As DictionaryEntry In iod
		System.Diagnostics.debug.print(de.Key & "=" & de.Value)
	Next
End Sub

ASP.NET's UpdatePanel will not work if xhtmlConformance mode is set to Legacy in the Web.config file:

<xhtmlConformance mode="Legacy" />

Take it out of the Web.config file - it almost certainly does not need to be in there.

With administrator privileges, edit the C:\Program Files (x86)\VideoLAN\VLC\lua\http\.hosts file, and set it to:

::/0
0.0.0.0/0

This will probably need to be done every time a new version of VLC is installed.

Probably caused by the Web.config file. Remove the following, if they exist:

<section name="scriptResourceHandler" type="System.Web.Configuration.ScriptingScriptResourceHandlerSection, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false" allowDefinition="MachineToApplication"/>
 
<section name="jsonSerialization" type="System.Web.Configuration.ScriptingJsonSerializationSection, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false" allowDefinition="Everywhere" />
<section name="profileService" type="System.Web.Configuration.ScriptingProfileServiceSection, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false" allowDefinition="MachineToApplication" />
<section name="authenticationService" type="System.Web.Configuration.ScriptingAuthenticationServiceSection, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false" allowDefinition="MachineToApplication" />
<section name="roleService" type="System.Web.Configuration.ScriptingRoleServiceSection, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false" allowDefinition="MachineToApplication" />

Removing these from the Web.config doesn't seem to matter, but if it does, try adding the relevant DLL files and see if that fixes the problem.