Goto the &quot;Quick Launch&quot; (Ctrl+Q) and type &quot;using&quot; and press `Enter`.

Then change the following setting:

![Using Sorting option][1]

It&#39;s an annoying default setting, I have no idea why Microsoft chose that, it goes against all previous standards that I&#39;ve ever seen.

**EDIT:**
Thanks to [Oskar][2] we have a [reason][3]:

&gt; The reason for the change in default behavior is due to the fact that
&gt; Windows App Store applications prefer to have &#39;Windows.*&#39; at the top
&gt; of the file rather than &#39;System.*&#39;


  [1]: http://i.stack.imgur.com/twb5T.png
  [2]: https://stackoverflow.com/users/83111/oskar
  [3]: https://connect.microsoft.com/VisualStudio/feedback/details/775702/organize-usings-no-longer-puts-system-references-first-bug-or-feature-change

Here is the query:

    SELECT * FROM table WHERE accountid = 1 ORDER BY logindate DESC LIMIT 1

Now if I added an index with multiple columns on the fields:

    INDEX(accountid,logindate)

Would MySQL take advantage of this multiple column index? Or would it not use it because one field is in the where clause and the other is in an order statement? Or does it not matter as long as I use the fields in the order of the multiple column index?

Understanding multiple column indexes in MySQL query

I am confused about the best way to manage shared development of Google App Scripts. The thing is that editing google app scripts is done through an online editor with its own version control in place, but that&#39;s not shared with other developers as far as I can tell.  

So is the suggested practice that we copy and paste from that editing space into local hard files and then push into the version control system of our choice, and then when we want to test things we copy and paste things back into the online editor?  Seems messy and error prone.

I see some people are putting their Google App Scripts in places like Github:

https://github.com/peterneubauer/neo4j-google-apps-script

Would be great it we could push directly from git to deploy on Google App Scripts the same way we do with Heroku.  Would really like to be able to run a battery of unit tests against my App Scripts ...

Should Google App Scripts be stored in version control like GitHub

I&#39;m using the Power Commands extension with Visual Studio 2012. I have the option checked to remove and sort usings on save. The problem is that the System.Xxx directives are being sorted last, and that&#39;s causing a style analysis error:

&gt;SA1208: System using directives must be placed before all other using directives.

**Before save:**

    using System;
    using System.Diagnostics.CodeAnalysis;
    using Foo;

**After save:**

    using Foo;
    using System;
    using System.Diagnostics.CodeAnalysis;

This worked correctly (System.Xxx first) with VS 2010. Anyone know how to correct this?

Note: Even if it didn&#39;t cause an SA error, I&#39;d still prefer the system directives to be first.

Using Directives Sorted in Wrong Order

I'm using the Power Commands extension with Visual Studio 2012. I have the option checked to remove and sort usings on save. The problem is that the System.Xxx directives are being sorted last, and that's causing a style analysis error:
>SA1208: System using directives must be placed before all other using directives.
Before save:
<pre><code class="hljs language-sql">using System;
using System.Diagnostics.CodeAnalysis;
using Foo;
</code></pre>
After save:
<pre><code class="hljs language-sql">using Foo;
using System;
using System.Diagnostics.CodeAnalysis;
</code></pre>
This worked correctly (System.Xxx first) with VS 2010. Anyone know how to correct this?
Note: Even if it didn't cause an SA error, I'd still prefer the system directives to be first.

Can I execute multiple queries and return their results executing a `SqlCommand` just once?

How do I return multiple result sets with SqlCommand?

I&#39;m trying to use the new async/await feature to asynchronously work with a DB. As some of the requests can be lengthy, I want to be able to cancel them. The issue I&#39;m running into is that `TransactionScope` apparently has a thread affinity, and it seems that when canceling the task, its `Dispose()` gets ran on a wrong thread.

Specifically, when calling `.TestTx()` I get the following `AggregateException` containing `InvalidOperationException` on `task.Wait ()`:

    &quot;A TransactionScope must be disposed on the same thread that it was created.&quot;

Here&#39;s the code:

	public void TestTx () {
		var cancellation = new CancellationTokenSource ();
		var task = TestTxAsync ( cancellation.Token );
		cancellation.Cancel ();
		task.Wait ();
	}

	private async Task TestTxAsync ( CancellationToken cancellationToken ) {
		using ( var scope = new TransactionScope () ) {
			using ( var connection = new SqlConnection ( m_ConnectionString ) ) {
				await connection.OpenAsync ( cancellationToken );
				//using ( var command = new SqlCommand ( ... , connection ) ) {
				//	await command.ExecuteReaderAsync ();
				//	...
				//}
			}
		}
	}

UPDATED: the commented out part is to show there&#39;s something to be done — asynchronously — with the connection once it&#39;s open, but that code is not required to reproduce the issue.

How to dispose TransactionScope in cancelable async/await?

Originally I believed that 				

    context.Configuration.AutoDetectChangesEnabled = false;

would disable change tracking. But no. Currently I need to use `AsNoTracking()` on all my LINQ queries (for my read only layer). Is there a global setting to disable tracking on the DbContext?

Global setting for AsNoTracking()?

Is there a way to do this in Windows Phone 7?

I can reference the TextBlock in my C# Code, but I don&#39;t know exactly how to then set the foreground color of it.

    myTextBlock.Foreground = 
    //not a clue...

Thanks

    

Programmatically set TextBlock Foreground Color

How can I convert the list of match result from regex into `List&lt;string&gt;`? I have this function but it always generate an exception,

&gt; Unable to cast object of type &#39;System.Text.RegularExpressions.Match&#39;
&gt; to type &#39;System.Text.RegularExpressions.CaptureCollection&#39;.

    public static List&lt;string&gt; ExtractMatch(string content, string pattern)
    {
    	List&lt;string&gt; _returnValue = new List&lt;string&gt;();
    	Match _matchList = Regex.Match(content, pattern);
    	while (_matchList.Success)
    	{
    		foreach (Group _group in _matchList.Groups)
    		{
    			foreach (CaptureCollection _captures in _group.Captures) // error
    			{
    				foreach (Capture _cap in _captures)
    				{
    					_returnValue.Add(_cap.ToString());
    				}
    			}
    		}
    	}
    	return _returnValue;
    }

 
         
If I have this string,

    I have a dog and a cat.

regex

    dog|cat

I want that the function will return of result into `List&lt;string&gt;`

    dog
    cat

Convert result of matches from regex into list of string

In my JavaScript (.js) files, I use a Visual Studio 2012 plugin for regions [(here)][1] like this:

    //#region &quot;My Region&quot;
    
    //Code here
    
    //#endregion &quot;My Region&quot;


I would also like to have regions in TypeScript (.ts) files as well. Is this a possibility right now? 

  [1]: http://visualstudiogallery.msdn.microsoft.com/4be701d8-af03-40a4-8cdc-d2add5cde46c

Regions in TypeScript

Visual Studio has an option to place system directives at the top when sorting them.

![enter image description here][1]

When this setting is **unchecked**, sorting using statements by right-clicking on them and using the *Organize Usings* feature, places System namespaces alphabetically along all other namespace imports.

However, ReSharper does not seem to honor this setting, nor does it have anything similar on its own Namespace Imports options page.  It always behaves as if you want System namespaces at the top.  This is especially annoying when you already have some at the bottom and you let ReSharper suggest a namespace to import, then you end up with some at both ends of the list.

Is there some way to fix this?  Or is this just a bug/oversight in ReSharper?

  [1]: http://i.stack.imgur.com/71HGg.png

How to tell ReSharper to sort usings with system namespaces NOT at the top?

Its been a while since I setup a Build Server so maybe I&#39;ve forgotten something or maybe .NET 4.5 is different from whatever version I did this with last time, but here is my problem.

I&#39;m trying to setup a build server to monitor a source control repository. Whenever something changes, I want the server to pull the changes and build the project. If there are no errors, I want to deploy the site to a web site running on the build server.

In the past when I did this, I thought that I was able to do this having only .NET installed, but when I try to build this project I get an error that &quot;C:\Program Files\MSBuild\Microsoft\VisualStudio\v11.0\WebApplications\Microsoft.WebApplication.targets&quot; is missing, and if I go and look I can see that it is missing. In fact there are no Visual Studio 11 targets files.

After a lot of thought and head scratching, I went out and got the &quot;Windows 8/.NET 4.5 SDK&quot; thinking that the .NET 4.5 SDK might install the targets files that I needed, but it did not unless I installed it wrong somehow.

So, what do I need to put on the Build Server in order to get the project to build. I would prefer not to have to install the full Visual Studio 2012. 

Build ASP.NET 4.5 without Visual Studio on Build Server

If I click control-click a hyperlink in the **text editor**, it opens the URL in a new Visual Studio tab. I would rather the link open outside Visual Studio in my system&#39;s default web browser (happens to be Google Chrome). How can I arrange this?

I&#39;m talking about hyperlinks in code comments.

* * *

I am using Visual Studio **2012**. I found a [similar question](https://stackoverflow.com/questions/1201570/how-do-i-open-links-in-visual-studio-in-my-web-browser-and-not-in-visual-studio) dated 2009, however the accepted answer (a macro) doesn&#39;t work in Visual Studio 2012.

Visual Studio 2012 change web browser

I have solution &amp; project in Visual Studio 2012. 

The project has a file `packages.config` in the root of the project.

For the purposes of this question, lets assume I accidentally removed these libraries from the `References` section of my project.

When going into NuGet package manager, the interface is still reporting a tick next to these packages, indicating they are installed.

The only way I can see how to fix this situation is to delete all the entries from `packages.config`, which will fix the issue of the NuGet interface reporting them as installed, and re-add each one.

Is there a smarter way? I had hoped enabling &#39;enable nuget to restore missing packages&#39; would solve this, but it doesnt seem to do anything.

Content Type	Original Author	Original Content on Stackoverflow
Question	Bob Horn	View Question on Stackoverflow
Solution 1 - C#	DaveShaw	View Answer on Stackoverflow

Using Directives Sorted in Wrong Order

C# Problem Overview

C# Solutions

Solution 1 - C#

Should Google App Scripts be stored in version control like GitHub

Understanding multiple column indexes in MySQL query

Attributions