Azure Dev Spaces – Debug Containers directly in Azure Kubernetes Service (AKS) from Visual Studio 2017

This is second part of the series on Azure Dev Spaces. The first part of this services describes steps needed to deploy Angular App and ASP.net Core Web API to AKS using Azure Dev Spaces. This article will show ease of debugging containers deployed in AKS from Visual Studio 2017.

In the first part of this series, I had created a sample ASP.net Core Web API app and deployed that to AKS using Azure Dev Spaces. The steps needed to debug ASP.net Core Web API application running in AKS are

  • Install Visual Studio Tools for Kubernetes. Once installation completes, open ‘Tools -> Extensions and Updates’ in Visual Studio and update this extension for any updates.
  • Open SampleWebApp solution in Visual Studio. The source code can be downloaded from GitHub.
  • Select Debug target as Azure Dev Spaces

  • Add a breakpoint in Get method of UsersController which we are going to debug
  • Start Debugging and select AKS cluster and Space in Azure Dev Spaces prompt
  • You can get public URL from Output window by selecting Azure Dev Spaces as displayed below
  • Open http://{URL}/api/users in browser and request will hit the breakpoint added previously

You can check the status of URL by running command azds list-uris. If URL isn’t available for more than 5 minutes you will need to delete PODS as explained in previous article. This completes this article which showed how easy it is to debug containers deployed in AKS from Visual Studio 2017 using Azure Dev Spaces.

Azure Dev Spaces – Deploying Angular and ASP.net Core App to Azure Kubernetes Service (AKS)

This article will show the ease of running and deploying containers in Azure Kubernetes Service (AKS) with minimal dev machine setup with Azure Dev Spaces. I am going to reuse sample application components from my previous article on AKS. With Azure Dev Spaces, you can develop on Windows, Mac, or Linux using familiar tools like Visual Studio, Visual Studio Code, or the command line. I have chosen Visual Studio Code on Mac.

In this article, I will share the steps needed to deploy sample application I created in Angular and ASP.net Core Web API using Azure Dev Spaces.

At time of writing this article Azure Dev Spaces is in preview and is isn’t available in all regions.

Continue reading “Azure Dev Spaces – Deploying Angular and ASP.net Core App to Azure Kubernetes Service (AKS)”

Utility to generate Word documents from templates using Visual Studio 2017 and DocumentFormat.OpenXml 2.8

WordDocGenerator is an utility to generate Word documents from templates using Visual Studio 2017, .NET Framework 4.7 and DocumentFormat.OpenXml 2.8.1. WordDocGenerator helps generate Word documents both non-refresh-able as well as refresh-able based on predefined templates using minimum code changes. Content controls are used as placeholders for document generation.

You can download the code from GitHub.

I had created this utility a few years back and you can read more details by going through older blogs which are still relevant (other than Charts which have been removed).

Azure Kubernetes Service (AKS) – Deploying Angular, ASP.NET Core and SQL Server on Linux

Azure Kubernetes Service (AKS) makes it simple to deploy a managed Kubernetes cluster in Azure. The sample application for this article is developed in Angular, ASP.net core and SQL Server. I will go through the steps needed to deploy these components to AKS.

The dev tools used to develop these components are Visual Studio for Mac/Visual Studio 2017 and Visual Studio Code. AKS Dashboard as well as kubectl commands are used to create Kubernetes resources in AKS.

The sample use case is a front end app (Angular) which loads users from Web API (ASP.net Core) and these users are saved in SQL Server DB. The steps needed to deploy these components to AKS are

  • SQL Server on Linux 
    • Create PersistentVolumeClaim
    • Create Secret to specify sa user password
    • Create service for SQL Server
    • Create deployment for SQL Server
  • ASP.net Core Web API 
    • Create ASP.net Core Web API sample application
    • Create a Docker Hub repository
    • Create a docker image 
    • Publish docker image to Docker Hub 
    • Create service for ASP.net Core Web API
    • Create deployment for ASP.net Core Web API 
  • Angular App 
    • Create an Angular App sample application
    • Create a Docker Hub repository
    • Create a docker image 
    • Publish docker image to Docker Hub 
    • Create service for Angular App
    • Create deployment for Angular App

Continue reading “Azure Kubernetes Service (AKS) – Deploying Angular, ASP.NET Core and SQL Server on Linux”

Visual Studio 11 database projects and Unit Testing SQL Server database

Please find the slides and demos for the session I presented at Microsoft User Group Hyderabad(MUGH). The agenda of the session was

  • Overview about Database Projects
  • Database development with SQL Server Data Tools(Code-named Juneau)
  • DEMO – Database development using SQL Server Data Tools and Visual Studio 11
  • Basics of Database Unit Testing
  • DEMO – Unit Testing Visual Studio 2010 Database projects

Download from

Utility to generate Word documents from templates using Visual Studio 2010 and Open Xml 2.0 SDK – Part 4

[Update: The source code has been updated to Visual Studio 2017 and DocumentFormat.OpenXml 2.8.1You can download the code from GitHub.]

This is the fourth part of this series. The code is available for download at http://worddocgenerator.codeplex.com/.

In Part 1 I discussed about

  • Document generation using Content Controls and Open XML 2.0 SDK
  • Creating Word templates
  • Implementation and Samples

In Part 2 I discussed about

  • List of functionalities that can be achieved using the utility/source code
  • Description regarding Samples provided with utility
  • New samples added in this update

In Part 3 I discussed about

  • Document-level customizations for Word 2007 and Word 2010
  • One of the ways to “Refresh the document from within the Word(e.g. right click on document and click Refresh) using document-level customizations for Word 2007 and Word 2010“

This post will focus on Charts. I’ve added the samples to generate/refresh charts using OpenXML. The screenshot below displays the template having Scatter chart and Line chart and the document generated out of this template using this utility.

Word 2010 Template having Charts –> Generated documents with Charts refreshed:

image

image

Code Changes:

Class diagram for Chart specific classes is displayed below

image

“SampleDocumentWithTableAndChartsGenerator” is the sample that shows how to refresh template having Scatter and Line charts. The code snippets are displayed below

  • “RefreshCharts” method is added to DocumentGenerator class
/// <summary>

/// Refreshes the charts.

/// </summary>

/// <param name="mainDocumentPart">The main document part.</param>

protected virtual void RefreshCharts(MainDocumentPart mainDocumentPart)

{


}

  • “SampleDocumentWithTableAndChartsGenerator” class overrides “RefreshCharts” method
/// <summary>

/// Refreshes the charts.

/// </summary>

/// <param name="mainDocumentPart">The main document part.</param>

protected override void RefreshCharts(MainDocumentPart mainDocumentPart)

{

    if (mainDocumentPart != null)

    {

        foreach (ChartPart chartPart in mainDocumentPart.ChartParts)

        {

            Chart chart = chartPart.ChartSpace.Elements<Chart>().FirstOrDefault();


            if (chart != null)

            {

                DocumentFormat.OpenXml.Drawing.Charts.ScatterChart scatterChart = chart.Descendants<DocumentFormat.OpenXml.Drawing.Charts.ScatterChart>().FirstOrDefault();

                DocumentFormat.OpenXml.Drawing.Charts.Line3DChart lineChart = chart.Descendants<DocumentFormat.OpenXml.Drawing.Charts.Line3DChart>().FirstOrDefault();


                if (scatterChart != null)

                {

                    ScatterChartEx chartEx = new ScatterChartEx(chartPart, this.scatterChartData);

                    chartEx.Refresh();

                }


                if (lineChart != null)

                {

                    Line3DChartEx chartEx = new Line3DChartEx(chartPart, this.lineChartData);

                    chartEx.Refresh();

                }

            }


            chartPart.ChartSpace.Save();

        }

    }

}

  • Refresh method is defined in ChartEx<T>
/// <summary>

/// Refreshes this instance.

/// </summary>

public void Refresh()

{

    ChartData chartData = this.GetChartData();


    if (chartData != null && chartData.IsValid())

    {

        string sheetName = this.UpdateEmbeddedObject();


        Chart chart = chartPart.ChartSpace.Elements<Chart>().FirstOrDefault();


        if (chart != null)

        {

            this.UpdateChart(chart.Descendants<T>().FirstOrDefault(), sheetName);

        }

    }

}

For complete code download the source code.

Summary:

Please provide feedback/comments and I’ll try to incorporate most of them in new releases.

How to use Pex and Moles to generate unit tests for a project having external dependency(WCF Proxy) using Visual Studio 2010 SP1

Source Code:

In this post I’ll discuss about writing unit tests using Pex and Moles. Pex and Moles are Visual Studio 2010 Power Tools that help Unit Testing .NET applications.

  • Pex automatically generates test suites with high code coverage. Right from the Visual Studio code editor, Pex finds interesting input-output values of your methods, which you can save as a small test suite with high code coverage.
  • Moles allows to replace any .NET method with a delegate. Moles supports unit testing by providing isolation by way of detours and stubs i.e. Generate a Mole type from the original type and redefine its behavior using delegates.

Pex and Moles can be downloaded from http://research.microsoft.com/en-us/projects/pex/.

I’ll explain the steps to generate unit tests for a project which calls a WCF service. Pex will be used to generate unit tests. Moles will be generated to isolate the external dependency(WCF proxy) and behavior will be redefined using delegates.

The projects inside the sample solution are

  1. DemoService: This project is a WCF Service.
  2. DemoLibrary: This project is a Class library and service reference to DemoService has been added. Unit tests will be generated for this project.
  3. ConsoleApp: This project is a Console application.
  4. DemoLibrary.Tests: This is a Test project and contains unit tests for DemoLibrary.

The solution structure is displayed below

image

DemoLibrary calls DemoService though proxy as displayed in the Layer diagram

image

I’ll now discuss in brief the code snippets of each project

WCF Service(DemoService): This service provided only a single operation

[ServiceContract]

public interface IDemoService

{

    [OperationContract]

    string Search(string criteria);

}

WCF Service Client(DemoLibrary): It calls the Search method of DemoService through proxy as displayed below

public string GetResults(string s)

{

    DemoServiceReference.DemoServiceClient client = null;

 

    try

    {

        client = new DemoServiceReference.DemoServiceClient();

        client.ClientCredentials.Windows.AllowedImpersonationLevel = System.Security.Principal.TokenImpersonationLevel.Impersonation;                

        client.ChannelFactory.Credentials.Windows.ClientCredential = System.Net.CredentialCache.DefaultNetworkCredentials;

        s = client.Search(s);

        return s;

    }

    finally

    {

        if (client != null)

        {

            if (client.State == CommunicationState.Opened)

            {

                client.Close();

            }

            else if (client.State == CommunicationState.Faulted)

            {

                client.Abort();

            }

        }

    }

}

Unit Testing DemoLibrary using Pex and Moles:

In order to generate unit tests for WCF Service Client(DemoLibrary) project the steps are

  1. Right click on the class for which unit tests needs to be generated and click “Create Parameterized Unit Tests” as displayed belowimage
  2. A popup will be displayed where Filters and Output can be modified. Click Ok to go to next step.image
  3. A new test project will be created. Test Class and Test stub will be be added to this project as displayed below
    /// <summary>This class contains parameterized unit tests for Search</summary>

    [PexClass(typeof(Search))]

    [PexAllowedExceptionFromTypeUnderTest(typeof(InvalidOperationException))]

    [PexAllowedExceptionFromTypeUnderTest(typeof(ArgumentException), AcceptExceptionSubtypes = true)]

    [TestClass]

    public partial class SearchTest

    {

        /// <summary>Test stub for GetResults(String)</summary>

        [PexMethod]

        public string GetResults([PexAssumeUnderTest]Search target, string s)

        {

            string result = target.GetResults1(s);

            return result;

            // TODO: add assertions to method SearchTest.GetResults(Search, String)

        }

    }

  4. There is an external dependency(GetResults makes a service call though the WCF Proxy) so “Run Pex Explorations” will not generate unit tests as displayed below                                                                          image
  5. In order to isolate the external dependency we need to generate Moles before running Pex Explorations. Moles will be generated for DemoLibrary and System.ServiceModel assemblies and behavior will be redefined using delegates. There are two ways to generate a mole for an assembly. I’ll show you both the approaches
    1. Visual Studio: This is the easiest way.
      1. Right click on the reference and generate Moles for that assembly as displayed below.image
      2. A .Moles file will be added to the project. Build the project and Moles.dll will be added to MolesAssemblies folder as displayed below                                                                                 .image
    2. Command Prompt: Moles can be generated from the command prompt.
      1. Run the moles.exe and specify the assembly path for which Moles needs to be created.image_thumb2[1]
      2. Copy the generated assembly to the Project and add reference to it.
  6. Similarly as explained above we need to generate Moles for System.ServiceModel assembly. For Visual Studio 2010 SP1 this may fail with error message “The type or namespace name ‘IHttpCookieContainerManager’ does not exist in the namespace ‘ssm::System.ServiceModel.Channels’ (are you missing an assembly reference?)”. This step however works fine for Visual Studio 2010. The fix is to exclude the type i.e. ‘IHttpCookieContainerManager’ from StubGeneration as displayed belowimage
  7. The next step is to Mock the Service call(redefine behavior using delegates) and add Asserts as displayed in code snippets below
    /// <summary>Test stub for GetResults(String)</summary>

    [PexMethod]

    public string GetResults([PexAssumeUnderTest]Search target, string s)

    {

        MockWCFService<IDemoService>();

     

        MDemoServiceClient.Constructor = (var1) =>

           new MDemoServiceClient { };

     

        MDemoServiceClient.AllInstances.SearchString = (var1, var2) =>

        {

            return "Result";

        };

     

        string result = target.GetResults(s);

        PexAssert.IsNotNullOrEmpty(result);

        PexAssert.AreEqual(result, "Result");

        return result;            

    }

     

    /// <summary>

    /// Mocks the WCF service.

    /// </summary>

    private void MockWCFService<TService>() where TService : class

    {

        MClientCredentials.Constructor = (var1) =>

            new MClientCredentials()

            {

                WindowsGet = () => { return new MWindowsClientCredential(); }

            };

     

        MClientCredentials.AllInstances.WindowsGet = (var1) =>

        {

            return new MWindowsClientCredential();

        };

     

        MWindowsClientCredential.AllInstances.ClientCredentialGet = (var1) =>

        {

            return new System.Net.NetworkCredential();

        };

     

        MWindowsClientCredential.AllInstances.ClientCredentialSetNetworkCredential = (var1, var2) => { };

     

        MWindowsClientCredential.AllInstances.AllowNtlmGet = (var1) => { return true; };

     

        MWindowsClientCredential.AllInstances.AllowNtlmSetBoolean = (var1, var2) => { };

     

        MWindowsClientCredential.AllInstances.AllowedImpersonationLevelGet = (var1) => { return System.Security.Principal.TokenImpersonationLevel.Impersonation; };

     

        MWindowsClientCredential.AllInstances.AllowedImpersonationLevelSetTokenImpersonationLevel = (var1, var2) => { };

     

        MChannelFactory.AllInstances.CredentialsGet = (var1) => { return new MClientCredentials(); };

     

        MClientBase<TService>.AllInstances.ClientCredentialsGet = (var1) =>

        {

            return new System.ServiceModel.Description.ClientCredentials();

        };

     

        MClientBase<TService>.AllInstances.ChannelFactoryGet = (var1) =>

        {

            return new MChannelFactory01<TService>();

        };

     

        MClientBase<TService>.AllInstances.StateGet = (var1) =>

        {

            return PexChoose.EnumValue<CommunicationState>("CommunicationState");

        };

     

        MClientBase<TService>.AllInstances.Close = (var1) =>

        { };

     

        MClientBase<TService>.AllInstances.Abort = (var1) =>

        { };              

    }

  8. Run Pex Explorations to generate unit tests for GetResults method as displayed below image
  9. Unit tests will be added to the Test Class as displayed below                      image
  10. Go to Test View and Run the unit tests as displayed below                  image

 

Summary:

In a similar way we can extract out external dependencies using Moles and then run Pex Explorations. A few examples of external dependencies can be data layer, UI layer, server calls etc. You can read more about Pex and Moles at http://research.microsoft.com/en-us/projects/pex/.