The package you need can be found by searching for &quot;autofac webapi2&quot; on Nuget.  
It is called **Autofac ASP.NET WebApi 2 Integration**.

How to add a new variable to an existing data frame, but I want to add to the front not end.
eg. my dataframe is

    b c d
    1 2 3
    1 2 3
    1 2 3

I want to add a new variable a, so the dataframe will looks like

    a b c d
    0 1 2 3
    0 1 2 3
    0 1 2 3



How to add new column to an dataframe (to the front not end)?

I use `NSAttributedString` to generate a string with two different sizes. By default, its bottom alignment looks like this:

![baseline aligned sizes][1]

But I want to center it vertically, like this:
![vertically centered sizes][2]

To be clear, this is a single attributed string, not two or more. This is a simplified example to describe my question, what I&#39;d actually like to do is more complex.

  [1]: http://i.stack.imgur.com/CmMcd.png
  [2]: http://i.stack.imgur.com/jb9D6.png

Center two fonts with different different sizes vertically in an NSAttributedString

I&#39;ve updated all of the nuget packages in my project, as well as the AutoFac MVC5 Integration package (removed MVC4 one) and still no dice.


&gt;Inheritance security rules violated while overriding member: &#39;Autofac.Integration.WebApi.AutofacWebApiDependencyResolver.BeginScope()&#39;. Security accessibility of the overriding method must match the security accessibility of the method being overriden.

MVC5, WebAPI2 and AutoFac not working. All Nuget packages updated

<p>I've updated all of the nuget packages in my project, as well as the AutoFac MVC5 Integration package (removed MVC4 one) and still no dice.</p>
<p>>Inheritance security rules violated while overriding member: 'Autofac.Integration.WebApi.AutofacWebApiDependencyResolver.BeginScope()'. Security accessibility of the overriding method must match the security accessibility of the method being overriden.</p>


I created a Web Api in VS 2012.
I am trying to get all the value from one column &quot;Category&quot;, that is all the unique value, I don&#39;t want the list to be returned with duplicates.

I used this code to get products in a particular category. How do I get a full list of categories (All the unique values in the Category Column)?

    public IEnumerable&lt;Product&gt; GetProductsByCategory(string category)
        {
            return repository.GetAllProducts().Where(
                p =&gt; string.Equals(p.Category, category, StringComparison.OrdinalIgnoreCase));
        }

Select All distinct values in a column using LINQ

It&#39;s a Web API 2 project.

When I implement DI using Ninject, I got an error message

An error occurred when trying to create a controller of type &#39;TokenController&#39;. Make sure that the controller has a parameterless public constructor.

    [assembly: OwinStartup(typeof(Web.Startup))]

    namespace Web
    {
        public partial class Startup
        {
            public void Configuration(IAppBuilder app)
            {
                ConfigureAuth(app);
                ConfigureWebApi(app);
            }
        }
    }

    public class TokenController : ApiController
    {

        private IUserService _userService;

        public TokenController(IUserService userService)
        {
            this._userService = userService;
        }

        [Route(&quot;api/Token&quot;)]
        public HttpResponseMessage PostToken(UserViewModel model)
        {
            if (_userService.ValidateUser(model.Account, model.Password))
            {
                ClaimsIdentity identity = new ClaimsIdentity(Startup.OAuthBearerOptions.AuthenticationType);
                identity.AddClaim(new Claim(ClaimTypes.Name, model.Account));
                AuthenticationTicket ticket = new AuthenticationTicket(identity, new AuthenticationProperties());
                var currentUtc = new SystemClock().UtcNow;
                ticket.Properties.IssuedUtc = currentUtc;
                ticket.Properties.ExpiresUtc = currentUtc.Add(TimeSpan.FromMinutes(30));
                return new HttpResponseMessage(HttpStatusCode.OK)
                {
                    Content = new ObjectContent&lt;object&gt;(new
                    {
                        UserName = model.Account,
                        AccessToken = Startup.OAuthBearerOptions.AccessTokenFormat.Protect(ticket)
                    }, Configuration.Formatters.JsonFormatter)
                };
            }

            return new HttpResponseMessage(HttpStatusCode.BadRequest);
        }
    }

When I add `&lt;add key=&quot;owin:AutomaticAppStartup&quot; value=&quot;false&quot; /&gt;` to web.config

Ninject works fine, 
but **Startup.OAuthBearerOptions.AccessTokenFormat** becomes to null

How to use DI container with OWIN?

**UPDATE**

Implement IDependencyResolver and use the WebAPI Dependency Resolver as below

    public void ConfigureWebApi(IAppBuilder app)
    {
        HttpConfiguration config = new HttpConfiguration();

        config.DependencyResolver = new NinjectDependencyResolver(NinjectWebCommon.CreateKernel());

        app.UseWebApi(config);
    }

[NinjectDependencyResolver](http://www.peterprovost.org/blog/2012/06/19/adding-ninject-to-web-api)

---

In Simple Injector case

    public void ConfigureWebApi(IAppBuilder app)
    {
        HttpConfiguration config = new HttpConfiguration();

        var container = new Container();
        container.Register&lt;IUserService, UserService&gt;();
        config.DependencyResolver = new SimpleInjectorWebApiDependencyResolver(container);

        app.UseWebApi(config);
    }

[SimpleInjectorWebApiDependencyResolver](http://simpleinjector.codeplex.com/wikipage?title=Web%20API%20Integration)

How to use DI container when OwinStartup

I have a Model object with a required attribute

    public class ApiPing
	{
		[Required]
		public DateTime ClientTime { get; set; }

		public DateTime ServerTime { get; set; }
	}

I have a Controller method that checks model state.

    public IHttpActionResult Ping(ApiPing model)
	{    
		if (!ModelState.IsValid)
			return BadRequest(ModelState);

		model.ServerTime = DateTime.UtcNow;

		return Ok(model);
	}

If I submit a submit a proper request (with a model) to the action method I get an correct value from ModeState.IsValid (true). However, when I submit an invalid request (without a model, so the model is null) I get an erroneous ModelState.IsValid (also true).

I could simply check if the model is null in my code, but that smells. Is this an intended &#39;feature&#39; or a bug in ModelState validation? Am I doing something wrong ? Am I expecting too much ?

ModelState is valid with null model

I know that I can use `Url.Link()` to get URL of a specific route, but how can I get Web API base URL in Web API controller?

How to get base URL in Web API controller?

Let&#39;s assume this is my action method

	public IHttpActionResult Get(int id)
	{
		var status = GetSomething(id);
		if (status)
		{
			return Ok();
		}
		else
		{
			return NotFound();
		}
	}

Test will be

    var httpActionResult = controller.Get(1);

How do I check my http status code after this?


How do I unit test web api action method when it returns IHttpActionResult?

(ASP.NET MVC 5, EF6, VS2013)

I&#39;m trying to figure out how to **change the type of the &quot;Id&quot; field from string to int** in the type:

    Microsoft.AspNet.Identity.EntityFramework.IdentityUser

in order to have new user accounts be associated with an integer ID rather than a GUID. But it seems like this will be more complicated than simply adding a new Id property with type int in my derived user class. Take a look at this method signature:

(from Assembly Microsoft.AspNet.Identity.Core.dll)

    public class UserManager&lt;TUser&gt; : IDisposable where TUser : global::Microsoft.AspNet.Identity.IUser
      {
      ...
      public virtual Task&lt;IdentityResult&gt; AddLoginAsync(string userId, UserLoginInfo login);
      ...
      }

So it seems that there are other methods baked into the ASP.NET identity framework which require the userId to be a string. Would I need to reimplement these classes as well?

**An explanation of why I don&#39;t want to store GUIDs for ids in the user table:**

-There will be other tables that relate data to the users table via a foreign key. (When users save content on the site.) I see no reason to use the larger field type and spend extra database space with no clear advantages. (I know that there are other posts about using GUIDs vs int ids, but it seems like many suggest that int ids are faster and use less space, which still leaves me wondering.)

-I plan to expose a restful endpoint to allow users to retrieve data about a particular user. I think:

    /users/123/name

is cleaner than

    /users/{af54c891-69ba-4ddf-8cb6-00d368e58d77}/name

Does anyone know why the ASP.NET team decided to implement IDs this way? Am I being short sighted in trying to change this to an int type? (Perhaps there are benefits I&#39;m missing.)

Thanks...

-Ben

How to change type of id in Microsoft.AspNet.Identity.EntityFramework.IdentityUser

I am creating a brand new projet with Visual Studio 2013, I choose Asp.Net MVC and the framework 4.5.1 The project is created, then, I do nothing else than F5 to start the default web page. Unfortunately, it produces a redirect to the login page which is redirecting into the login page too. Here is a short version of the url I have in the browser:

    http://localhost:5285/Account/Login?ReturnUrl=%2FAccount%2FLogin%3FReturnUrl%3D%252FAccount%252FLogin%253FReturnUrl%253D%25252FAccount%25252FLogin%25253FReturnUrl%25253D%2525252FAccount%2525252FLogin%2525253FReturnUrl%2525253D%252525252FAccount%252525252FLogin%252525253FReturnUrl%252525253D%25252525252FAccount%25252525252FLogin%25252525253FReturnUrl%25252525253D%2525252525252FAccount%2525252525252FLogin%2525252525253FReturnUrl%2525252525253D%252525252525

I do not have any error in the Event Viewer. But in the screen I see : 

&gt; &quot;HTTP Error 404.15 - Not Found The request filtering module is
&gt; configured to deny a request where the query string is too long.&quot;

 The website is running with the default setting in IIS Express. How can I fix this problem? I am guessing something is wrong with my Visual Studio 2013?

##Edit
It works if I create a brand new website and I host it in IIS. But if I create a new website (without modifying anything) and just hit play (which start IIS Express by default), it doesn&#39;t.

##Edit 2

I have deleted every **websites** in the Documents\IISExpress\config\applicationhost.config. I have recompiled everything, and it created this entry :


  &lt;sites&gt;
        &lt;site name=&quot;WebApplication3&quot; id=&quot;1&quot;&gt;
            &lt;application path=&quot;/&quot; applicationPool=&quot;Clr4IntegratedAppPool&quot;&gt;
                &lt;virtualDirectory path=&quot;/&quot; physicalPath=&quot;c:\users\patrick\documents\visual studio 2013\Projects\WebApplication3\WebApplication3&quot; /&gt;
            &lt;/application&gt;
            &lt;bindings&gt;
                &lt;binding protocol=&quot;http&quot; bindingInformation=&quot;*:7444:localhost&quot; /&gt;
            &lt;/bindings&gt;
        &lt;/site&gt;

        &lt;siteDefaults&gt;
            &lt;logFile logFormat=&quot;W3C&quot; directory=&quot;%IIS_USER_HOME%\Logs&quot; /&gt;
            &lt;traceFailedRequestsLogging directory=&quot;%IIS_USER_HOME%\TraceLogFiles&quot; enabled=&quot;true&quot; maxLogFileSizeKB=&quot;1024&quot; /&gt;
        &lt;/siteDefaults&gt;
        &lt;applicationDefaults applicationPool=&quot;Clr4IntegratedAppPool&quot; /&gt;
        &lt;virtualDirectoryDefaults allowSubDirConfig=&quot;true&quot; /&gt;
    &lt;/sites&gt;

I am still getting the error with IIS Express, not with IIS.

New Asp.Net MVC5 project produces an infinite loop to login page

There is very little documentation about using the new Asp.net Identity Security Framework.

I have pieced together what I could to try and create a new Role and add a User to it.  I tried the following: https://stackoverflow.com/questions/19541101/add-role-in-asp-net-identity

which looks like it may have gotten the info from this blog: [building a simple to-do application with asp.net identity and associating users with to-does][1]

I have added the code to a Database Initializer that is run whenever the model changes. It fails on the `RoleExists` function with the following error: 

&gt; `System.InvalidOperationException` occurred in mscorlib.dll 
The entity type IdentityRole is not part of the model for the current context.

    protected override void Seed (MyContext context)
    {
        var UserManager = new UserManager&lt;ApplicationUser&gt;(new UserStore&lt;ApplicationUser&gt;(context)); 
        var RoleManager = new RoleManager&lt;IdentityRole&gt;(new RoleStore&lt;IdentityRole&gt;(context));

        // Create Admin Role
        string roleName = &quot;Admins&quot;;
        IdentityResult roleResult;

        // Check to see if Role Exists, if not create it
        if (!RoleManager.RoleExists(roleName))
        {
            roleResult = RoleManager.Create(new IdentityRole(roleName));
        }
    }

Any help is appreciated.


  [1]: http://blogs.msdn.com/b/webdev/archive/2013/10/20/building-a-simple-todo-application-with-asp-net-identity-and-associating-users-with-todoes.aspx

Creating Roles in Asp.net Identity MVC 5

A default MVC 5 App comes with this piece of code in IdentityModels.cs - this piece of code is for all the ASP.NET Identity operations for the default templates:

    public class ApplicationDbContext : IdentityDbContext&lt;ApplicationUser&gt;
    {
        public ApplicationDbContext()
            : base(&quot;DefaultConnection&quot;)
        {
        }
    }

If I scaffold a new controller using views with Entity Framework and create a &quot;New data context...&quot; in the dialog, I get this generated for me:

    using System;
    using System.Collections.Generic;
    using System.Data.Entity;
    using System.Linq;
    using System.Web;
    
    namespace WebApplication1.Models
    {
        public class AllTheOtherStuffDbContext : DbContext
        {
            // You can add custom code to this file. Changes will not be overwritten.
            // 
            // If you want Entity Framework to drop and regenerate your database
            // automatically whenever you change your model schema, please use data migrations.
            // For more information refer to the documentation:
            // http://msdn.microsoft.com/en-us/data/jj591621.aspx
        
            public AllTheOtherStuffDbContext() : base(&quot;name=AllTheOtherStuffDbContext&quot;)
            {
            }
    
            public System.Data.Entity.DbSet&lt;WebApplication1.Models.Movie&gt; Movies { get; set; }
        
        }
    } 

If I scaffold another controller + view using EF, say for instance for an Animal model, this new line would get autogenerated right under `public System.Data.Entity.DbSet&lt;WebApplication1.Models.Movie&gt; Movies { get; set; }` - like this:

    using System;
    using System.Collections.Generic;
    using System.Data.Entity;
    using System.Linq;
    using System.Web;
    
    namespace WebApplication1.Models
    {
        public class AllTheOtherStuffDbContext : DbContext
        {
            // You can add custom code to this file. Changes will not be overwritten.
            // 
            // If you want Entity Framework to drop and regenerate your database
            // automatically whenever you change your model schema, please use data migrations.
            // For more information refer to the documentation:
            // http://msdn.microsoft.com/en-us/data/jj591621.aspx
    
            public AllTheOtherStuffDbContext() : base(&quot;name=AllTheOtherStuffDbContext&quot;)
            {
            }
    
            public System.Data.Entity.DbSet&lt;WebApplication1.Models.Movie&gt; Movies { get; set; }
            public System.Data.Entity.DbSet&lt;WebApplication1.Models.Animal&gt; Animals { get; set; }
    
        }
    } 


`ApplicationDbContext` (for all the ASP.NET Identity stuff) inherits from `IdentityDbContext` which in turn inherits from `DbContext`.
`AllOtherStuffDbContext` (for my own stuff) inherits from `DbContext`.

So my question is:

Which of these two (`ApplicationDbContext` and `AllOtherStuffDbContext`) should I use for all my other own models? Or should I just use the default autogenerated `ApplicationDbContext` since it shouldn&#39;t be a problem using it since it derives from the base class `DbContext`, or will there be some overhead? You should use only one `DbContext` object in your app for all your models (I&#39;ve read this somewhere) so I should not even consider using both `ApplicationDbContext` and `AllOtherStuffDbContext` in a single app? Or what is best practice in MVC 5 with ASP.NET Identity?


ASP.NET Identity DbContext confusion

Is it possible to use the new Asp.net Identity with Database First and EDMX? Or only with code first?

Here&#39;s what I did:

1) I made a new MVC5 Project and had the new Identity create the new User and Roles tables in my database.

2) I then opened my Database First EDMX file and dragged in the new Identity Users table since I have other tables that relate to it.

3) Upon saving the EDMX, the Database First POCO generator will auto create a User class. However, UserManager and RoleManager expects a User class inheriting from the new Identity namespace (Microsoft.AspNet.Identity.IUser), so using the POCO User class won&#39;t work.

I guess a possible solution is to edit my POCO Generation Classes to have my User class inherit from IUser?

Or is ASP.NET Identity only compatible with Code First Design?


++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Update:  Following Anders Abel&#39;s suggestion below, this is what I did. It work&#39;s, but I&#39;m wondering if there is a more elegant solution.

1) I extended my entity User class by creating a partial class within the same namespace as my auto generated entities.

    namespace MVC5.DBFirst.Entity
    {
        public partial class AspNetUser : IdentityUser
        {
        }
    }

2) I changed my DataContext to inherit from IdentityDBContext instead of DBContext. Note that every time you update your EDMX and regenerate the DBContext and Entity classes, you&#39;ll have to set this back to this.

     public partial class MVC5Test_DBEntities : IdentityDbContext&lt;AspNetUser&gt;  //DbContext

3) Within your auto generated User entity class, you must add the override keyword to the following 4 fields or comment these fields out since they are inherited from IdentityUser (Step 1).  Note that every time you update your EDMX and regenerate the DBContext and Entity classes, you&#39;ll have to set this back to this.
    
        override public string Id { get; set; }
        override public string UserName { get; set; }
        override public string PasswordHash { get; set; }
        override public string SecurityStamp { get; set; }

Content Type	Original Author	Original Content on Stackoverflow
Question	Shane	View Question on Stackoverflow
Solution 1 - asp.net Web-Api	Alex Meyer-Gleaves	View Answer on Stackoverflow

MVC5, WebAPI2 and AutoFac not working. All Nuget packages updated

asp.net Web-Api Problem Overview

asp.net Web-Api Solutions

Solution 1 - asp.net Web-Api

Center two fonts with different different sizes vertically in an NSAttributedString

How to add new column to an dataframe (to the front not end)?

Attributions