Showing posts with label Visual Studio 2019. Show all posts
Showing posts with label Visual Studio 2019. Show all posts

Monday, October 5, 2020

Install SSIS in Visual Studio 2019

 1. Open Visual Studio 2019,  Click Extensions-> Manage Extensions


2. Search SQL Server Integration Services Projects and click download.

3. Install downloaded File.


4. Follow the wizard to complete installation


We may get any of the following error because Visual Studio is still open and we’re trying to update. Click ‘OK’, close Visual Studio and install again.


Installation wizard takes a while to complete. Once it is installed we see this window and we may require to restart computer.



5. Go to “New” Project, and Integration Services Project is now available in Visual Studio 2019. We can get started with project now.




Friday, September 4, 2020

Call Azure Function using Console Application – Part 4

Previous Post - Calling Azure Function using Postman – Part 3

In this part, we will create a Console Application (.Net Framework) and call Azure Function from it.

Step 1 – Open Visual Studio and create Console Application (.Net Framework) project.

 

Step 2 – Add a class “StudentDetail”and its data members as below.

We will be using these data members to send request to the Azure Function.





















Step 3 – We will "set" static values to data members of the Student Details class. 

Add below code to your “Program” class.


















Step 4 – Create "WebClient" to call Azure Function.

We will use “WebClient” method for sending request and receiving response and “Newtonsoft Json” library to convert student object to json string that will be further used as request parameter to Azure Function.

Add below code to your “Program” class.

Step 5 – Debug code line by line and see the request and response.

Request










Response








The reason why we are getting this response is because of below code in our Azure function that we had deployed.



Yay!! We Did it.

Stay Connected, to see next part of the series.

Reference to MS Documentation - 

https://docs.microsoft.com/en-us/azure/azure-functions/

Happy Learning, LET'S SHARE !

Create Azure Function using Visual Studio – Part 2

Previous Post - Create Azure Function using Azure Portal – Part 1

Step 1 – Go to Visual Studio, create a "New Project" and select "Azure Function" template.

Step 2 – Name Function App and click "Create" button.

Step 3 – Defined Framework and Trigger 

Select ".NET Framework" as a run time stack, select "Http trigger" and then click on "Create" button. 

Step 4 – Below is the code generated.


Step 5 – Right click on the Project Name and click "Publish" button.



Step 6 – Select Publish Target 

Choose the publish target where you want to publish your Azure Function. If you want to publish it in existing Function App then choose Select Existing. 

Here we will publish Azure Function in new Function App.



Step 7 - Click on the "Create" button.



Step 8 – Go to Azure Portal and click on the "Function App".



Step 9 – We will see recently created Function App in the list. Simply Click on it.

Step 10 – Click on the "Functions". But here we will find no Azure Function inside the app as its not yet deployed from Visual Studio.



Step 11 – Return to the Visual Studio and "Publish" it. By doing so Azure Function will be pushed in the Function App recently created.



Step 12 – If in case below popup occurs, Click on the "Yes" button.



Step 13 – Now go back to Azure Portal and refresh browser. We will find Azure Function successfully deployed.


Step 14 – Click on Azure Function and then Click "Code+Test".



Step 15 – In Test window we can not see code as it is deployed from Visual Studio.


Step 16 – Click on the "Get function URL" and copy the End Point URL of Azure Function.



Step 17 – It will look like the url shared below. We can test Azure Function by calling it from Post Man.


To test this, lets jump on to Part 3 -  Call Azure Function using Postman.

Reference to MS Documentation - 

https://docs.microsoft.com/en-us/azure/azure-functions/

Happy Learning, LET'S SHARE !

Popular Posts