C# Corner

Resources  
  • Hosting Website With Filezilla To AzureOct 19, 2017. We can use the FTP client Filezilla for website hosting to Azure. And it is an FTP method. And sometimes we may face some errors in it. And the solution is also mentioned in this article.
  • How To Return A Pair Of Closest Birthdates Using API, Multi Threading And MVC 5 Using C#.NETOct 18, 2017. This article demonstrates how to use multi-threading to return the name of 2 customers who have the closest birthdate. I also include how create API to add\ retrieve customer details from SQL database using tasks and how to use MVC to call and API to add a new customer.
  • T-SQL - Display Decimal Numbers As MoneyOct 17, 2017. In this article, we will show how to display decimal numbers as money with and without cents
  • Basic Introduction To Power BIOct 17, 2017. In this article I will discuss the fundamental concepts of Power BI. So this article will cover basic knowledge on power BI, the need of power BI, the importance of data visualizations, the components of Power BI, the architecture of Power BI, the building blocks of Power BI & the cost of power BI tools.
  • Missing Office / SharePoint Template In Visual Studio 2017Oct 16, 2017. In this article, we will explain how to install Office Developer Tools to create Office / SharePoint projects in Visual Studio 2017.
  • C# 7.0 And C# 7.1 New Features - Part TwoOct 16, 2017. This article explains the new features of C# 7.0 & C#7.1. It covers new features like Discards, Pattern Matching, Generalized async return types, Async Main (Main Method returning Task), Infer Tuple Element Names, Default Literal Expressions & Type Inference and Pattern Matching with Generics.
  • Cloud Databases In Azure - Part TwoOct 16, 2017. In the first article of this series, I explained about how to create SQL Database in Azure. I recommend you read the first article.
  • C# 7.2 New Features With Visual Studio 2017Oct 16, 2017. This article explains the new features of C# 7.2. It covers ‘ref readonly’, ‘private protected’ access modifier, Digit Separator After Base Specifier (Leading Digit Separator) and Non-trailing named arguments.
  • Always Encrypted In SQL Server 2016 - Step By Step Guide - Part TwoOct 14, 2017. This is part two of "Always Encrypted In SQL Server 2016 - Step By Step Guide" series. In this article, we are going to see the sample queries on encrypted columns and Limitations of Always Encrypted feature. In case, if you have missed out the first part of the series.
  • Delete A SharePoint Subsite By Using Angular And Rest APIOct 14, 2017. In this article I am going to explain how to delete a subsite programmatically using Angular js and rest API call.
  • Understanding Text Analytics API In AzureOct 14, 2017. This article will give an overview on Text Analytics API in Azure. Open azure portal and click on add and choose category “AI + Cognitive Services” and then select an option of “Text Analytics API”.
  • An Easy Way To Encode And Decode File In ASP.NETOct 13, 2017. In this article, I’ll explain a way to encode and decode a file in ASP.NET using C# and VB.NET with example.
  • Let's Move 'On-Prem' Data Warehouse To 'Azure SQL Data Warehouse' With Redgate Data Platform Studio (DPS)Oct 13, 2017. In this article we will learn how to migrate ‘On-Prem’ data warehouse to the Cloud, specifically Azure SQL Data warehouse. I will share the lessons learned and some do’s and don’ts from my experience that may be helpful.
  • User-Defined Types In SQL ServerOct 13, 2017. When we are working with any programming language, we create user defined types as per our requirement. It is a better idea to have this feature in the SQL server.
  • Using Optional Query Parameters With Microsoft Graph API - Part OneOct 12, 2017. While Microsoft already has all the documentation to cover all its technology, in this article I will try to explain these ODATA query parameters with some different angles and usage scenarios. I’m sure you will enjoy reading this article and learn something new.
  • How To Send Notification Via SMS When Dropbox Is Modified With Microsoft FlowOct 12, 2017. This article helps you to learn how to notify someone via SMS when a Dropbox file is modified through Microsoft Flow.
  • T-SQL - Retrieve Task Hierarchy In Project ServerOct 12, 2017. In this article, we will show how to get the Task Hierarchy for a Specific Project in Project Server Database using SQL
  • Understanding Bing Search API In AzureOct 12, 2017. The Bing Search API adds intelligent search to your app, combing hundreds of billions of webpages, images, videos, and news to provide relevant results with no ad requirements. The results can be automatically customized to your users' locations or markets, increasing relevancy by staying local.
  • Create SharePoint 2016 Solutions In Visual Studio 2015Oct 12, 2017. In this article, I will explain how to show the SharePoint 2016 Project Template in Visual Studio 2015.
  • Understanding Translator Speech API In AzureOct 12, 2017. Microsoft Translator Speech API is a cloud-based automatic translation service. The API enables developers to add end-to-end, real-time, speech translations to their applications or services.
  • Create A Subsite By Selecting A Template Using AngularOct 11, 2017. In this article, I am going to explain how to create a subsite programmatically based on a selected template using AngularJS and REST API call.
  • Understanding Face API In AzureOct 11, 2017. Add facial recognition capabilities to your app with the Face API. State-of-the-art algorithms detect human faces in images, opening a range of facial capabilities to your apps. Face detection can also identify attributes, including face landmarks (nose, eyes, etc.), gender, age, and other machine-predicted facial features.
  • Deploying A Virtual Machine Using Azure PowerShellOct 11, 2017. Azure PowerShell provides a set of cmdlets that use the Azure Resource Manager model for managing your Azure resources. You can use it in your browser with Azure Cloud Shell, or you can install it on your local machine and use it in any PowerShell session. It is optimized for managing and administering Azure resources from the command line, and for building automation scripts that work against the Azure Resource Manager.
  • Custom Script Extension For WindowsOct 11, 2017. In this article, we will see how to work with custom script extension in Azure Virtual Machines.
  • Deploying A Virtual Machine Using Azure CLI 2.0Oct 11, 2017. In this article, we will see how to deploy a Virtual Machine in Azure using Azure CLI 2.0 in the portal itself.
  • Understanding Computer Vision API In AzureOct 11, 2017. The Computer Vision API gives you the tools to understand the contents of any image. Create tags identifying objects, beings, or actions present in the image, and then craft coherent sentences to describe it.
  • Cloud Databases In Azure - Part OneOct 11, 2017. In my previous articles on Azure, I have explained about the IaaS features of Azure i.e. creating Virtual Machines, databases etc. In this article, we will see the Introduction of Cloud Databases i.e. PaaS side of Microsoft Azure.
  • Logging Exception in Database Using CustomFilter ExceptionOct 11, 2017. As per request from one of my followers I am writing this article, which will explain how we can handle Errors in an MVC application. In this article I am also going to explain how we can log our exception message in our Data Base.
  • An Overview Of Cookies In ASP.NETOct 10, 2017. In this article explain cookies in Asp.Net
  • Shared Storage Using Azure File ServiceOct 10, 2017. In most cases, the virtual disks we are creating for an Azure VM are connected to that particular VM with a 1:1 relationship which can’t be accessed by another VM at the same time. In case you need a shared storage by multiple VMs you should use Azure File Shares. Azure File shares can be mounted concurrently by cloud or on-premises deployments of Windows, Linux, and macOS. This is mostly used in case of any requirement of something like a shared application setting or if you need to share any tools or utilities between developers and administrators.
  • Introduction To Document DB In AzureOct 10, 2017. In this article, we will see how to create Azure Document Db which we also call Azure Cosmos Db.
  • Installing And Using .NET 4.7.x, .NET Core 2.0, And C# 7.x With VS 2017Oct 09, 2017. This article explains how to install and use .NET Framework 4.7, .NET Framework 4.7.1 & .NET Core 2.0 and troubleshooting if you are getting an exception while installing these latest components. This article also explains how to use the different versions of C#, e.g. C# 7, C# 7.1, C# 7.2 with Visual Studio 2017 and installing multiple instances of Visual Studio 2017 side by side.
  • How To Use Ratings In Lists And Libraries Using Rating Settings, Server Side Coding And PowerShell CommandsOct 09, 2017. In this article I will discuss how to make use of ratings with your lists & libraries. Ratings are the features introduced by Microsoft which allow users to evaluate & rate the authors. Here I will explain how to use ratings on the lists & libraries.
  • How To Connect Facebook to Twitter With Microsoft FlowOct 08, 2017. Microsoft Flow is a cloud-based service. It allows us to react to an event in one place and do something with the data from that event in another one service.
  • Azure App Service - Deployment SlotOct 08, 2017. Azure makes it easy, to create deployment slots for App Services. It’s available in the Standard or Premium App Service plan mode. Deployment slots are actually live apps with their own hostnames. App content and configurations elements can be swapped between two deployment slots, including the production slot.
  • How To Save Email Attachment From Outlook To Dropbox With Microsoft FlowOct 08, 2017. This article helps you to learn how to create a Flow between the Outlook attachment to Dropbox.
  • ASP.NET - Connect To Azure Cosmos DBOct 07, 2017. This article will show how to configure and use CosmoDB on an ASP.Net MVC web application, The tasks will be stored as JSON documents in Azure Cosmos DB.
  • How To Implement Dependency Injection In MVC ProjectOct 07, 2017. Here I am going to explain how to implement dependency injection in MVC Project in detail including separate layers for getting data through Services and Repositories.
  • ASP.NET - Connect to MySQL Azure DatabaseOct 07, 2017. Using MVC, Entity Framework, ASP.NET Scaffolding, and Azure MySQL you can create a web application that stores your information on an MongoDB Azure database. This demo shows you how to create a web application with MVC and Entity Framework 7, that communicate with a MySQL Azure database.
  • Create Simple Azure FunctionOct 07, 2017. Azure functions allow up to run the code in a server-less manner. That means we do not have to create the VM to host the running code nor do we have to create a web application and publish code to web applications to run continuously.
  • Upload Multiple Files To SharePoint List On Single Click Using Angular And jQueryOct 07, 2017. This article explains how to upload more than one files into a SharePoint list on just single click using Angular and jQuery.
  • Deploying A Virtual Machine Using Unmanaged DiskOct 07, 2017. In the previous article, we deployed a Windows VM using the managed disk. In this article, we are going to see how we can deploy a VM using an unmanaged disk. For demo purpose, I am using a Linux VM instead of windows here.
  • Understand Azure Machine Learning WorkbenchOct 07, 2017. Understand Azure Machine Learning Workbench and see what is new and how it works.
  • Azure Blob Storage In ASP.NET Core 2.0Oct 06, 2017. In this article you will learn how to use Azure Blob storage in ASP.NET Core.
  • Always Encrypted In SQL Server 2016 - Step By Step Guide - Part OneOct 06, 2017. Lets say, we have a requirement to encrypt the PII data for an existing ASP.NET web application. Data needs to be encrypted at rest as well as on transit. Considering the existing PROD data, we need to identify an encryption approach that best suits the requirement. I'm going to share my experience in finding the encryption approach and implementing it on a sample database.
  • CRUD Operation With ASP.NET Core MVC Web App Using ADO.NETOct 05, 2017. In this article, I am going to explain how to create a MVC web application in ASP.NET Core 2.0 using ADO.NET.
  • How To Connect OneDrive To Google Drive With Microsoft FlowOct 05, 2017. This article helps you to learn how to create a Flow between the OneDrive files and Google Drive files.
  • ColorPicker Control In UWP (Windows 10 Fall Creators Update Features)Oct 04, 2017. This article explains how to implement ColorPicker control in UWP application. A ColorPicker control is a new control in UWP programming
  • How To Log Messages (Information, Errors, Warnings) In ASP.NET CoreOct 04, 2017. Framework provides logging capability through ILoggerFactory, to which you could attach one or more providers. Providers act on the logged data in some form i.e., log it to file, database, Azure etc.
  • Introduction To Machine Learning In AzureOct 04, 2017. In this article, we will see what machine learning is and how it differs from traditional programming.
  • Deploying A Windows Virtual Machine In The Azure PortalOct 04, 2017. Azure Virtual Machine (VM) is one of the several types of on-demand, scalable computing resources that Azure offers. Typically, you choose a VM when you need more control over the computing environment than the other choices offer. Let's see how to create an Azure VM from the portal.
  • Create New Record To SharePoint List Using Angular With Rest APIOct 04, 2017. In this article, I am going to explain how to create SharePoint list item using Angular js. This will help to create a new record for long SharePoint lists which contain 100+ fields since we no longer specify field names in this code.
  • Azure Machine Learning - Classification Predictive Analysis Using Iris DatasetOct 04, 2017. In this tutorial, you will learn to create a machine learning model in Microsoft Azure Machine Learning Studio.
  • Azure Deployment Details And LogsOct 03, 2017. I am working on Microsoft Azure services from last 3-4 years. I always like to work on cloud platform provided by Microsoft. Microsoft always comes up with new services, features with their products. I have observed one thing with Azure that creating any resources or creating design is not big deal. There are lots of technical material and forums provided by Microsoft. Most challenging thing with azure is troubleshoot any issue till you actual route cause.
  • How To Secure PII Data In SQL Server Using CLE (Column Level Encryption)Oct 03, 2017. PII (personally identifiable information) which is used to identify individual identity such as SSN, DOB, Bank Account Number etc. When you are working with financial application you face the scenario where you have to store the data in encrypted format, so no one can see the actual data.
  • Razor Page Web Application With ASP.NET Core Using ADO.NETOct 03, 2017. In this article, I am going to explain how to create a web application in ASP.NET core using Razor pages and ADO.NET.
  • Migrate SharePoint On-Premises Content To SharePoint Online Using SPO APIOct 02, 2017. Below is the step by step SharePoint Online PowerShell cmdlets to migrate the content. It requires minimal CSOM (Client object model) call to avoid the threshold. It leverages a temporary Azure Blob Storage container to hold the content and Azure Queue, which schedule parallel jobs.
  • Executing Exchange Online PowerShell Command Through SharePoint Online PowerShellOct 02, 2017. For Office 365 administrators there are lists of Exchange Online PowerShell cmdlets available. We can execute these cmdlets through SharePoint Online Management Shell or Windows PowerShell by creating remote PowerShell session with Exchange Online. In this article I’ll explain how to create remote PowerShell session to Exchange Online and then execute Exchange Online PowerShell cmdlets.
  • Convert HTML Files To DOCX Files With MariGold.OpenXHTMLSep 30, 2017. This tutorial explains how to create an HTML to DOCX converter with a C# windows application.
  • How To Start VM Automatically In AzureSep 29, 2017. Virtual Machines provides flexibility to install and configure anything, any time and use it as you want. As well as all these features, VMs are costly so developers or managers of VMs needs to make the cost effective, for this Azure provides Automation Scripting to start and stop a VM automatically so that it will be cost effective besides it is flexible.
  • How To Create Blobs In Microsoft Azure Using C#Sep 29, 2017. This article is in continuation of a previous article - “Understanding Cloud Storage in Azure”, where we created a storage account and a Blob container with the name “images”.
  • Configuring Startup Page In ASP.NET CoreSep 27, 2017. In this article, we will explain how to Configure Startup Page In ASP.NET Core.
  • WebGrid Custom Paging Links To Avoid Load On Server Using Stored Procedure And ASP.NET MVCSep 27, 2017. I will show you how to fetch the data dynamically from the database and bind to the WebGrid control, using the stored procedure in MVC 4.0. In this blog, today, I will show you how to write code in ASP.NET MVC for implementation of WebGrid Control using Static Data. In later sessions, I will show you the process of using GridView Dynamically, that means using SQL Server data source.
  • Azure NoSQL In ASP.NET Core 2.0Sep 26, 2017. The sample code will require you to set up an Azure account, NoSQL database and collection.
  • Web API Token Based Authentication With Angular - Part TwoSep 26, 2017. This article will demonstrate about how to implement Token Based Authentication in Angular JS application. In my previous article, I have explained how to implement Token Based Authentication in Web API.
  • Understanding Cloud Storage In AzureSep 26, 2017. In this article, I will explain about Storage Accounts (Storage Accounts can hold hundreds of terabytes of data.) and we will see how we can use Azure Storage as a place to keep uploaded files for our web application and how we can allow users to download files from storage by creating and handling out what is known as a shared access signature (SAS).
  • Unit Test In .NET Core Application Using MStestSep 26, 2017. In this article, I am going to explain how to perform unit testing in .NET core using MStest.
  • Cloud Platform Basics - Welcome To The New IT WorldSep 24, 2017. If you are an IT Leader, software developer, or IT PRO you need to understand cloud platforms, as they are going to play a big part in the future. In this article, I will explain how enterprises, businesses, government bodies etc. can and should use cloud platforms.
  • Use Log4net In ASP.NET MVC ApplicationSep 22, 2017. You may have read several articles on how to use log4net , however my article explains how you can use it without having to initialize several times.
  • Azure Logic Apps Integration With Microsoft TeamsSep 22, 2017. In this article, you will see how you can use Azure Logic Apps to get your RSS Feeds converted into short links and get them delivered directly into your Microsoft Teams channel and mailbox.
  • CRUD Operation In ASP.NET Core MVC Using Visual Studio CodeSep 21, 2017. In this article, I am going to explain how to create a basic web application using ASP.Net Core MVC and Visual Studio Code in Windows System.
  • An Introduction to BlockchainSep 21, 2017. In this video Mark explains the basic building blocks of blockchain.
  • How To Migrate Your On-Premises / Enterprise Data Warehouse Into Azure SQL Data WarehouseSep 21, 2017. I will share how you can start migrating your data into the Azure SQL Data Warehouse
  • How To Secure PII Data In SQL Server Using .NET AssemblySep 21, 2017. PII (Personally Identifiable Information) is used to identify individual identity markers such as SSN, DOB, Bank Account Number etc. When you are working with financial applications you face a scenario where you have to store the data in encrypted format, so no one can see the actual data.
  • Display And Sort A Slicer Control By Month Or Quarter Name In Power BISep 20, 2017. In this article, we will explain How to display and sort a Slicer control by Month or Quarter Name in Power BI?
  • Create A Website Having Azure Active Directory Authentication Using Visual StudioSep 19, 2017. Azure Active Directory (Azure AD) is Microsoft’s multi-tenant, cloud based directory and identity management service. Azure AD combines core directory services, advanced identity governance, and application access management. Azure AD also offers a rich, standards-based platform that enables developers to deliver access control to their applications, based on centralized policy and rules.
  • 35 Essential Basic-Advanced SQL Query-Questions Asked In Technical InterviewsSep 19, 2017. These are all query-based questions asked in tech interviews, including some simple looking tricky one liner SQL statements and joins.
  • Serve Static Files In ASP.NET Core Using Visual Studio 2017Sep 18, 2017. This article explains about static files and how to set default page using static files in ASP.NET using Visual Studio 2017 in a step by step way.
  • Encrypt And Decrypt User Password In SQL Server DB Using C# Winform ApplicationSep 18, 2017. In this article we are going to learn how to maintain the user login details in sql server table with password encryption format and decrypt the user password and validate the credentials in login form.
  • Create Log Backup Maintenance Plan In SQL Server 2016Sep 17, 2017. In this article, we will explain how to take log backups frequently by creating a Log Backup Maintenance Plan in SQL Server 2016
  • Convert Rows To Columns Using Dynamic Pivot In SQL ServerSep 17, 2017. In this article, we will show how to convert rows to columns using Dynamic Pivot in SQL Server.
  • Building Web Applications And APIs In AzureSep 14, 2017. In this article, we will look at building Web Applications and APIs with Microsoft Azure. We will see how we can use Azure as a platform for our applications, and we will see different options for creating and deploying an application.
  • Azure SQL Data Warehouse - Why Enterprises Should Now Consider It SeriouslySep 14, 2017. Today we will explore some of the reasons why enterprise should choose Azure SQL Data Warehouse.
  • SQL Server DB Backup Using Stored Procedure In WinForm ApplicationSep 14, 2017. In this article we are going to learn how to get database backup using stored procedure in SQL server in C# Winform applications.
  • Update Managed Metadata Field Using SharePoint Designer 2013 WorkflowSep 12, 2017. In this article, I am going to explain how we can update a managed metadata field using SharePoint 2013 Designer Workflow. This solution will work for both SharePoint 2013 On-Premise and SharePoint Online (Office 365). I tested the below solution in Office 365 environment.
  • Kickstart Azure Database For PostgreSQLSep 10, 2017. This blog post will walk you through creating an Azure Database for PostgreSQL in Azure Portal. PostgreSQL is a powerful, open source object-relational database system and has capability to handle workloads ranging from small single-machine applications to large Internet-facing applications with many concurrent users. Azure Database for PostgreSQL is a managed service which enables you to run, manage, and scale PostgreSQL databases in the cloud.
  • SharePoint 2013 - On Premises - Powershell Script To Import Termsets On Given Site From .csv File In Specific FolderSep 10, 2017. In this article I’ll explain how to import multiple termsets using .CSV file from one specific folder.
  • Working With Azure Tables - Part TwoSep 09, 2017. Let us look at the basic sample, which retrieves the Azure table data into the applications using Node JS.
  • Introduction To Translator Speech API - Microsoft Cognitive ServicesSep 09, 2017. In my previous article on Microsoft Azure Cognitive Services, we saw how to register for Microsoft Cognitive Services and how we can use Face and Emotional API’s. In this article, we will see how we can use Translator Speech API and what its features are.
  • Getting Started With Azure Cosmos DB - Table APISep 08, 2017. The table is made up of one or more partitions. Partition Key and Row Key are suitable to optimize your solution. The account name, table name, and partitionkKey together identify the partition within the same storage service where your table service stores the entity.
  • Getting Started With Bing Emotion APISep 08, 2017. In this tutorial, we will learn how to use Bing Emotion API. In our previous example of the cognitive service demo, we had combined two cognitive services, Bing Speech API and Bing Emotion API, so as to find images using speech to text (STT). To extend this demo, we will be using Bing Emotion API which will detect the emotions of a person from the image that we had searched using Bing Image Search API.
  • Getting Started With Bing Image Search APISep 08, 2017. In this tutorial, we will learn how to use Bing Image Search API. Remember, in our first example of cognitive services, we had created a demo Bing Speech API. In this tutorial, we will extend the same demo to search images, i.e., we will pass the text result of Bing Speech API to Bing Image Search API.
  • Azure Cosmos DB With SQL Query Cheat Sheet PDFSep 08, 2017. Microsoft Azure Cosmos DB supports querying documents using SQL (Structured Query Language) as a JSON query language. Cosmos DB is truly schema-free. By its commitment to the JSON data model directly within the database engine, it provides automatic indexing of JSON documents without requiring explicit schema or creation of secondary indexes.
  • Find Out Creation And Modification Date Of Database Objects Like Tables And Stored ProceduresSep 07, 2017. Database Object refers to Table, Stored procedure, View, Function etc.; in other words, all the elements that are created for data storage and manipulation.
  • How To Consume Web API Through SSIS PackageSep 07, 2017. In this article, I have illustrated the purpose of SSIS with Web API. It shows how SSIS can use Web API to do certain operations, like updating the database table based on Service response, and process the data, etc.
  • How Should We Store Images And Blob Files In SQL ServerSep 06, 2017. There is always a requirement from developers: How should I store images and BLOB files in SQL Server ? In this post let's explore the data types and methods used for storing Binary Large Objects also know as BLOBs, such as images and sounds, into SQL Server.
  • New String Function In SQL Server 2017Sep 06, 2017. It requires one separator argument and a minimum of two arguments otherwise it raises an error. All the arguments are implicitly converted to string types and then they are concatenated.
  • Deep Dive Into Microsoft AzureSep 06, 2017. Microsoft Azure is a growing collection of integrated cloud services which developers and IT professionals use to build, deploy and manage applications through our global network of datacentres. With Azure, you get the freedom to build and deploy wherever you want, using the tools, applications and frameworks of your choice.
  • Understanding Bot Service In AzureSep 06, 2017. This article will give an overview about the MS bot framework. Open azure portal and click on add and choose category “Data + Analytics” and then select the option “Bot Service”.
  • Restart An App Programmatically In UWP (Windows 10 Fall Creators Update Features)Sep 06, 2017. This article explains about how to restart an app programmatically in Universal Windows Programming.

About explain-SQL-Azure-Architecture

NA
File APIs for .NET
Aspose are the market leader of .NET APIs for file business formats – natively work with DOCX, XLSX, PPT, PDF, MSG, MPP, images formats and many more!