VS2017

General Availability of Azure Database Services for MYSQL and PostgreSQL

March 23, 2018 Azure, Cloud Computing, Cloud Services, Data Services, Emerging Technologies, Microsoft, Tech Newz, VisualStudio, VS2017 No comments

It has been a while I have written something on my blog. I thought of getting started again with a good news that Microsoft Azure team has announced the general availability of Azure Database Services for MySQL and PostgreSQL. In my earlier posts, I have provided some oversight into Preview Availability of these services as part of the Azure cloud. Now that it is generally available, customers should be able to utilize these services for their general purpose or enterprise level database requirements in Azure Cloud.

You may read about it more on Microsoft announcement blog Announcing general availability of Azure database services for MySQL and PostgreSQL  by Tobias Ternstrom Principal Group Program Manager, Azure Data

Getting Started local development with Azure Cosmos DB services – Part 2

May 29, 2017 .NET, .NET Core 1.0, .NET Core 1.0.1, .NET Framework, ASP.NET, Azure, Azure SDK Tools, Azure Tools, Cloud Computing, CodeSnippets, CosmosDB, Document DB, Microsoft, PaaS, SaaS, Visual Studio 2015, Visual Studio 2015 Update 3, Visual Studio 2017, VisualStudio, VS2015, VS2017, Windows, Windows 10, Windows Azure Development, Windowz Azure No comments

In my previous article we discussed about setting local development environment using Cosmos DB Emulator for Windows. With this part 2 of the article, we will cover developing, debugging and integration related aspects of using Cosmos DB Emulator.

Developing with Cosmos DB Emulator

Once you have Cosmos DB emulator installed and running on your machine, you can use any supported Cosmos DB SDK or Cosmos DB REST API to interact with emulator. This process is same as you are using a Cosmos DB cloud service.

Cosmos DB Emulator also provides a build-in visual explorer through which you can view,create and edit collections and documents.

image

Before you integrate Cosmos DB SDK or Cosmos DB REST API you would need to generate master key for authentication. Unlike cloud service, Cosmos DB emulator only support single fixed account and master key.  You would not be able to communicate with Emulator without this master key.

Default Master Key:

Account name: localhost:<port>

Account key: C2y6yDjf5/R+ob0N8A7Cgv30VRDJIWEHLM+4QDU5DE2nQ9nDuVTqobD4b8mGGyPMbIZnqyMsEcaGQy67XIw/Jw==

PS: This key is only to be used in Emulator. You cannot use the same key for Production(Cosmos DB Cloud Service).

Furthermore, if you want to set your own key. You can go to command line references and run DocumentDB.Emulator.exe with sufficient command switch to set your own key. Remember it should meet the key security requirements. See command-line tool reference for more information.

The Azure Cosmos DB Emulator is installed by default to the C:\Program Files\Azure Cosmos DB Emulator  or C:\Program Files\DocumentDB Emulator  directory.

Once you have account name and key, you are good to go with development and debugging using Azure Cosmos DB emulator.

Let us start looking at how to use CosmosDB SDK. Once you add Cosmos DB SDK for .NET from NUGET sources. You would need to import the following namespaces to reference necessary classes.

 using Microsoft.Azure.Documents;
   
 using Microsoft.Azure.Documents.Client;
   
 using Microsoft.Azure.Documents.Linq;

Simple code to establish connection:

// Connect to the Azure Cosmos DB Emulator running locally use DocumentClient class in : 
DocumentClient client = new DocumentClient(
    new Uri("https://localhost:8081"), 
    "C2y6yDjf5/R+ob0N8A7Cgv30VRDJIWEHLM+4QDU5DE2nQ9nDuVTqobD4b8mGGyPMbIZnqyMsEcaGQy67XIw/Jw==");

In the above code block we are directly embedding endpoint, key in the source code.But as a suggested approch keeping in mind to easily point to production service would be maintain the key in Web.config appSettings.

   <add value="https://localhost:8081/" key="endpoint"/>
    <add value="C2y6yDjf5/R+ob0N8A7Cgv30VRDJIWEHLM+4QDU5DE2nQ9nDuVTqobD4b8mGGyPMbIZnqyMsEcaGQy67XIw/Jw==" key="authKey"/>
 

Add NuGet reference to Microsoft.Azure.DocumentDB  (always use the latest version of the library)

image

For the ease of this article, I am going to use the existing ToDoList sample from DocumentDB Samples provided by Microsoft. You can originally find the same source from C:\Program Files\DocumentDB Emulator\Packages\DataExplorer\quickstart.

image

Copy and Unzip DocumentDB-Quickstart-DotNet.zip and open todo.sln in Visual Studio 2017 and your solution structure will look like below:

image

Now run the application in your Visual Studio.

1. You will see an initial screen:

image

2. Click on Create New:

image

3. New record will be added to your Azure Cosmos DB Emulator:

image

4. To verify in Cosmos DB emulator now open Cosmos DB explorer, click on Collections and Select ToDoList

image

5.Expand Documents and select item with id:da305da3-c1dc-4e34-94d9-fd7f82d26c58

image

Hope this article was helpful for you with initial development.  Share your feedback through comments and share this to your friends and colleagues.

Useful Links:

Getting Started local development with Azure Cosmos DB services – Part 1

May 20, 2017 .NET, Azure, Azure SDK, Azure SDK Tools, Azure Tools, Cloud Computing, Computing, CosmosDB, Data Services, Document DB, Emerging Technologies, KnowledgeBase, Microsoft, PaaS, Visual Studio 2013, Visual Studio 2015, Visual Studio 2017, VS2013, VS2015, VS2017, Windows 10, Windows Azure Development, Windows Server 2012 R2, Windows Server 2016, Windowz Azure 1 comment , ,

Azure Cosmos DB is a multi-API, multi-model highly scalable NoSQL database services from Microsoft Azure platform. In order to develop an application consuming Azure Cosmos DB requires an azure live subscription or emulator in your local machine.

The Azure Cosmos DB Emulator provides a local development/test environment for Azure Cosmos DB development purposes. Using Azure Cosmos DB Emulator, you can develop and test your application locally, without needing an azure subscription or without subscription costs.

With this article I am going to take you through necessary steps and requirements to set up your local environment.

1. Pre-Requisites:

Azure Cosmos DB emulator has the following software and hardware requirements:

  • Software requirements
    • Windows Server 2012 R2, Windows Server 2016, or Windows 10
  • Minimum Hardware requirements
    • 2 GB RAM
    • 10 GB available hard disk space

2. Installation:

  • Download Azure Cosmos DB Emulator   (DocumentDb.Install.msi)   ** do not get confused by the name. Azure Cosmos DB is a super set of Document DB, and the DocumentDb emulator they tweaked a bit to support Cosmos Db.
  • Install DocumentDb.Install.msi

Additionally Azure CosmosDB emulator can be run on Docker for Windows. After installing Docker for Windows, you can pull the Emulator image from Docker Hub.

docker pull microsoft/azure-documentdb-emulator

imageimageimage

3. Start/Launch Azure Cosmos DB Emulator:

image image

After some time you can see the emulator started. When the Azure Cosmos DB emulator launches it will automatically open the Azure Cosmos DB Data Explorer in your browser.

The address will appear as https://localhost:8081/_explorer/index.html

Incase you have closed browser and later would like to open the explorer again, you can open the Data Explorer by right clicking on the taskbar menu.

image

image

Now you can write some sample app to try it, or download already created sample applications from Microsoft depending on the preferred platform of your choice.

4. Limitation of Azure Cosmos DB Emulator: (or Differences between Azure Cosmos DB Emulator vs Real Cosmos DB Cloud Service)

Since the Azure Cosmos DB Emulator provides an emulated environment running on a local developer workstation, there are some fundamental differences between the emulator and an Azure Cosmos DB account in the cloud:

The following table is also helpful in determining when to use Cosmos DB Emulator and when direct cloud service. Depending on the choice of requirement, you would need to use associated services efficiently.


Cosmos DB Emulator Cosmos DB Cloud Service
Supports only a single fixed account and a well-known master key. Key regeneration is not possible. Supports multiple accounts and different master keys. You can regenerate keys any time from Azure Portal.
Non scalable Highly scalable
Does not support larger data sets Support for large data sets
Does not simulate consistency levels Different Consistency levels available
Does not simulate multi-region replication Configurable as part of the platform, as needed basis.
Does not support quota override feature Supports document size limit increases, increased partitioned collection storage etc.
Might not support most recent changes to Cosmos Db platform Most recent platform update will be available.

Hope this article was helpful for your initial start. If you would need to understand further on Azure Cosmos DB development follow the links. I will be writing further insights in later sessions.

Visual Studio 2017 Install error– 0x80131500 – Failed to Deserialize packages

April 5, 2017 .NET, .NET 4.7, .NET Core 1.0, .NET Framework, .NET Framework 4.5.2, .NET Framework 4.6, .NET Framework 4.7, ASP.NET, ASP.NET Core 1.0, ASP.NET MVC, C#.NET, Microsoft, Troubleshooting, Visual Studio 2017, VisualStudio, VS2017, WCF, Windows, Windows 10 No comments

I was frustrated by this error when I am trying to reinstall Visual Studio 2017 after my visual studio got corrupted/failed during upgrade to 15.1 ( or after a previous installation failed due to low disk space).

There is a file called ‘state.json’ , in below mentioned path, which is creating this particular issue. 

%ProgramData%\Microsoft\VisualStudio\Packages\Instances\<instance> 

image

image

Solution:

  • Delete/rename the folder as is or rename ‘state.json’ file to ‘something.json’ .

Found from : https://developercommunity.visualstudio.com/content/problem/2877/install-error-0x80131500-failed-to-deserialize-pac.html

Azure SDK for .NET 3.0 available for Visual Studio 2015/2017

April 2, 2017 .NET, .NET Framework, Add-In's, App Service, Azure, Azure SDK, Azure SDK Tools, Cloud Services, General, Microsoft, Microsoft SDKs, Visual Studio 2013, Visual Studio 2015, Visual Studio 2017, VS2013, VS2015, VS2017, Windows 10, Windows 7, Windows 8.1, Windows Azure, Windows Azure Development, Windowz Azure No comments

Windows Azure SDK for .NET, which include SDKs, basic tools, and extended tools for Visual Studio development for Azure Cloud enabled applications.  Microsoft has released latest Azure SDK for .NET along with Visual Studio 2017 (RTW). The new version v3.0 will support only Visual Studio 2015/2017, if you are using Visual Studio 2013 you can use Azure SDK for .NET v2.9.6.

You can have both the version side by side, by uninstalling earlier version first for Visual Studio 2013 and installing latest version to support newer visual studio.

There is not much major changes included in this release:

  • All the tools you need to do Azure development will be part of Visual Studio 2017 going forward.
  • For Visual Studio 2015 the SDK will still be available through WebPI.
  • Microsoft have discontinued Azure SDK for .NET releases for Visual Studio 2013 now that Visual Studio 2017 has been released.

Download: Azure SDK for .NET 3.0  – VS 2015   |  VS 2013 (v2.9.6 )   |  All Versions (including Java/Node.JS)

Creating Visual Studio 2017 Offline Installer

March 8, 2017 .NET, .NET Framework, Add-In's, Editions, Microsoft, Offline Installer, Visual Studio 2017, VisualStudio, VS2017 No comments

In my earlier article, I shared the details to download various Visual Studio Editions. This is an online installer which would require associated packages to be downloaded from online Microsoft sources.  Means Microsoft is not providing an Offline ISO as a download like in Visual Studio 2015. This would be a time consuming process depending of the packages you have selected to install and your internet bandwidth provided by your ISP.

With this few steps I am going to walk you through necessary steps to download all necessary packages to create an offline installer. Depending on the modules you select, package size may grow up to ~23GB.

First Step:   you would need to download associated installer  bootstrapped file.

Edition Setup File Name Command
Visual Studio Enterprise vs_enterprise.exe vs_enterprise.exe –layout c:\vs2017offline –lang en-US
Visual Studio Professional vs_professional.exe vs_professional.exe –layout c:\vs2017offline  –lang en-US
Visual Studio Community vs_community.exe vs_community.exe –layout c:\vs2017offline –lang en-US

Second Step: Go to the folder where you have saved the associated exe. Open Command Prompt(CMD.EXE) and  execute the associated command for the related executable for the edition you want to  create offline setup for.

It would take a while to complete the download of all packages.

Final Step: Once the  above step is completed, without errors, you can find that you yourself has created an offline installer. Take a back to external USB for later use or copy to other machines as necessary.

Now go to “c:\vs2017offline “ and run the associated exe and select the options you would need to install. It would get installed faster, and you can reuse the same installer multiple times without the need of downloading every time.

You can learn more about additional switches to download only what is needed  here