Popular Posts

Thursday, July 24, 2014

Enabling cors on asp.net web api

http://www.asp.net/web-api/overview/security/enabling-cross-origin-requests-in-web-api

Sunday, July 13, 2014

Easy, eager and explicit loading entity framework

http://www.asp.net/web-api/overview/creating-web-apis/using-web-api-with-entity-framework/part-4

Friday, July 11, 2014

Connecting to sql server express instance using web config connection string and entity framework


This connection string does NOT work:

  <connectionStrings>
    <!--<add name="TodosConnection" providerName="System.Data.SqlClient"
          connectionString="Server=.\SqlExprss;Initial Catalog=Todos;Integrated Security=True;"/>-->

This connection string works:

    <add name="TodosConnection"
     connectionString="data source=.\SQLEXPRESS;Integrated Security=True; database=Todos;"
     providerName="System.Data.SqlClient" />
    
  </connectionStrings>


And in the code this how to use it:

namespace Todo.Api.Data
{
    public class TodosContext : DbContext
    {

        public TodosContext()
            : base("name=TodosConnection")
        {
            Debug.Write(Database.Connection.ConnectionString);
        }

        public DbSet<Todo> Todos { get; set; }
    }
}