Entity Framework 6 connection string names

Monday, 20 April 2015

When you add Entity Framework to a .NET project, it adds the following to the app.config file:

  <defaultConnectionFactory type="System.Data.Entity.Infrastructure.LocalDbConnectionFactory, EntityFramework">
      <parameter value="mssqllocaldb" />
    <provider invariantName="System.Data.SqlClient" type="System.Data.Entity.SqlServer.SqlProviderServices, EntityFramework.SqlServer" />  

David shows that you can modify the defaultConnectionFactory section to use SQL Server with a connection string.

<defaultConnectionFactory type="System.Data.Entity.Infrastructure.SqlConnectionFactory, EntityFramework">  

    <parameter value="Data Source=.\sql2014;Initial Catalog=AdventureWorks2014;Integrated Security=True;" />  


What might not be immediately obvious is that you can also refer to an existing connectionString by name. So if you already have:

  <add name="AW" connectionString="Data Source=.\sql2014;Initial Catalog=AdventureWorks2014;Integrated Security=True;" providerName="System.Data.SqlClient"/>

Then you can just configure it like this instead:

<defaultConnectionFactory type="System.Data.Entity.Infrastructure.SqlConnectionFactory, EntityFramework">
    <parameter value="AW" />

ASP.NET WebSockets basics

Sunday, 19 April 2015

Back in 2012, ASP.NET 4.5 and IIS 8 shipped with built-in support for WebSockets. If you plan to support using WebSockets on the server today, you’ll most likely use SignalR, which makes this all quite easy, but I thought it would be educational to take a step back and see what’s involved in just using the framework’s basic support.

To try this out I created a new ASP.NET MVC web project.

I then added a new ‘Generic Handler’ item to the project and named it MyHandler.ashx

The contents of this hander are based on the example from What’s New in ASP.NET 4.5. It essentially echoes any content received back to the caller:

using System;
using System.Net.WebSockets;
using System.Text;
using System.Threading;
using System.Threading.Tasks;
using System.Web;
using System.Web.WebSockets;

namespace DemoWebSockets
    public class MyHandler : IHttpHandler
        public void ProcessRequest(HttpContext context)

        public bool IsReusable
            get { return false; }

        private async Task ProcessWebSocket(AspNetWebSocketContext context)
            var socket = context.WebSocket;
            while (true)
                var buffer = new ArraySegment(new byte[1024]);

                // Asynchronously wait for a message to arrive from a client
                var result = await socket.ReceiveAsync(buffer, CancellationToken.None);

                // If the socket is still open, echo the message back to the client
                if (socket.State == WebSocketState.Open)
                    var userMessage = Encoding.UTF8.GetString(buffer.Array, 0, result.Count);
                    userMessage = string.Format("You sent: {0} at {1}", userMessage, DateTime.Now.ToLongTimeString());
                    buffer = new ArraySegment(Encoding.UTF8.GetBytes(userMessage));

                    // Asynchronously send a message to the client
                    await socket.SendAsync(buffer, WebSocketMessageType.Text, true, CancellationToken.None);

I then modified the index.cshtml page

<div class="row">    
<div class="col-md-12">
        <label for="msgText">Text to send:</label>
        <input id="msgText" type="text" /><br />
<input id="Trigger" type="button" onclick="CallWebSocket(); return false;" value="Send" />
        <hr />
        <div id="serverData">

<script type="text/javascript">
     var socket = new WebSocket("ws://localhost:51057/MyHandler.ashx");

     // Receive a string message from the server.
     socket.onmessage = function (msg) {
          document.getElementById("serverData").innerHTML = msg.data;

     function CallWebSocket() {
         if (socket.OPEN) {
             // Send a string message from the browser.
     } </script>

And here’s the finished product:

Screenshot showing example of web page

Youssef also shows how to create a handler using WebAPI, and server-side configuration to enable IIS WebSocket support.

Jon Galloway on new things in ASP.NET 5 and ASP.NET MVC 6

Wednesday, 1 April 2015

We’ve got another “big name international speaker” for ADNUG this month!

Photo of Jon GallowayNext week, we’re joined by Jon Galloway, a Microsoft Technical Evangelist based in San Diego, California. Jon will be speaking about the new features coming in both ASP.NET 5 and ASP.NET MVC 6. I assume we’ll see the final versions of these around the same time that Visual Studio 2015 ships.

I first came across Jon through his being one of the presenters of the Herding Code podcast (I’ve been listening since 2009). More recently, I’ve watched some of his courses on Microsoft Virtual Academy, seen him appear weekly in the ASP.NET 5 Community Standups and been following him on Twitter. He’s an engaging, knowledgeable, down-to-earth presenter and I’m anticipating it will be a great meeting.

If you’re in Adelaide, then please register and come along on Thursday 9th April at 12 noon, Microsoft Adelaide, Level 12, 147 Pirie St, Adelaide. Register via http://www.meetup.com/Adelaide-dotNET/events/221073867/

If you’re out of town or just can’t make it in person, then we’ll be running the session via a Google Hangout – so you can still participate in the live session or watch the recording after the event on YouTube.

Look forward to seeing you there in person or online Smile.


Tuesday, 10 March 2015

(For my own reference)

To resolve this issue in Microsoft SQL Server (often observed when you restore a database that came from another server):

SQL Server Management Studio information dialog

Run this:

alter authorization on database::[MyDbName] to sa;

MVA Figurines

Thursday, 19 February 2015

In September last year I took part in the MVA ‘Become a hero’ promotion. By signing up, I got a free t-shirt (and if you know me well, you’ll know that makes perfect sense). In addition by completing a number of online courses from the MVA site, you could then get a novelty figurine (or maybe up to 6 if you did more courses).

I received my t-shirt, but my figurine never arrived. It appeared the super powers of “DevOps Captain Code” also included the ability to get lost in the mail. “Oh well, at least I’ve got a t-shirt”, I thought.

But then yesterday I got home to discover two packages from Microsoft. One was another t-shirt (yay), and the other was the full set of 6 figurines.

MVC Hero Figurines

So now we have (left to right)

They’re now gracing my desk at work, much to the bemusement of my colleagues Smile

Figurines and t-shirts aside, if you’re after some quality free online training then there’s some excellent resources at the Microsoft Virtual Academy site. Most courses are run as a live event and then are made available on-demand a few weeks later (useful if the live event clashes with your preferred time to be asleep!)