Rookian

We have continued to research the topic and propose the following alternative solution. We ask Microsoft kindly to verify the solution described below and to inform whether this is an approperiate solution.

Proposed solution
A service principal is configured to create various resources in a subscription. This service principal has to be assigned to the Directory Readers role in the AAD in order to determine the Application Id for a Managed Identity in the context of the deployment process.

The configured “Managed Identity” of the Azure App Service can be registered on the respective Azure SQL database with the following command.

Rookian

NOTE: The note content.

Rookian

[HttpPost]
public ActionResult Test3([BindToPropertyWith(nameof(ViewModel.Command))]Command parameternameDoesNotMatter)
{
    return RedirectToAction("Index");
}

Rookian

public class BindToPropertyWith : CustomModelBinderAttribute
{
    private readonly string _propertyName;

    public BindToPropertyWith(string propertyName)
    {
        _propertyName = propertyName;
    }

    public override IModelBinder GetBinder()

Rookian

public ActionResult Test1([Bind(Prefix = nameof(ViewModel.Command))]Command                                  parameternameDoesNotMatter)
{
    return RedirectToAction("Index");
}

Rookian

public ActionResult Test(Command command)
{
    return RedirectToAction("Index");
}

Rookian

@using (Html.BeginForm("Test", "Home", FormMethod.Post))
{
    @Html.TextBoxFor(x => x.Command.Name)
    @Html.HiddenFor(x => x.Command.Id)

    <input type="submit" value="Submit"/>
} 

Rookian

public class ViewModel
{
    // POST values
    public Command Command { get; set; }

    // Read-only values
    public string Name { get; set; }
}

public class Command // or InputModel

Rookian

public class ViewModel : InputModel
{
     public bool ShowSaveButton { get; set; }
     public string Customer { get; set; }
}

Rookian

using System.Data.Entity;
using System.Linq;
using AutoMapper;

namespace EFTests
{
    public class Program
    {
        public static void Main()
        {