C# Corner

Resources  
  • Upgrading Your Application In Azure Managed KubernetesJan 18, 2018. In the previous article, we deployed an ASP.NET Core 2.0 API app in AKS (Azure Managed Kubernetes). Now, let's quickly look into how to upgrade the application when there is a change in code. Please make sure you read the previous article to follow through this one.
  • Deploying ASP.NET Core 2.0 App To Azure Using DockerJan 18, 2018. Azure provides a highly scalable, configurable and easy to use Platform-as-a-Service (PaaS) environment for our ASP.NET Core web applications. Azure Web App is one of the simplest ways to host web applications and the new Web App Container makes it really easy to host Docker containers.
  • Azure Logic Apps - Integrating Twitter API And Google Drive APIJan 17, 2018. This article will explain about working on Logic Apps, integrating Twitter API and Google Drive API. We will be using Logic Apps here to search for a keyword on Twitter and save the tweets for the Google Drive on the specified location.
  • Deploy Your First ASP.NET Core 2.0 App In Azure Managed KubernetesJan 17, 2018. This guide will help you to get started with AKS. We are going to deploy our first ASP.NET Core 2.0 App in AKS and then do some cool stuff like scaling up and down.
  • Database First In .Net Core 2.0 CRUD Operation - Part OneJan 17, 2018. In my previous post, I have explained how to create an Angular 5 application in Visual Studio 2017 using .NET Core templates which you can find here.
  • Stored Procedures In Azure Cosmos DBJan 16, 2018. There are many performance benefits when executing complex operations like Batching in case of using Stored Procedures. Reason is all these operations get executed closer to data as Stored Procedures are stored at server side.
  • Comparison Of Subquery And JoinsJan 15, 2018. Here, in this article, we are comparing the SQL Join and SQL Subquery.
  • Why Dynamic Query Is BadJan 15, 2018. In this article, we will be talking about Dynamic Query and why it is bad.
  • Angular 5 CRUD Operation Using Node, Express, MongoDBJan 13, 2018. In this article, we’ll learn to create basic CRUD application using angular 5, Nodejs, Express and Mongodb nosql database.
  • AI Series - Part Two - Programming EmotionsJan 12, 2018. I will be showing how to start AI Development with Cognitive Services. Previously, we kickstarted our new article series “AI HowTo” and talked about how to register for Emotion API Preview(Project Oxford) through Azure Portal.
  • Azure CLI With Demo Creating VM Using Azure CLIJan 12, 2018. This articles shows a demo of creating virtual machine in Azure using Azure CLI with explanation of Azure CLI cmdlets.
  • Create An Intelligent Bot Application Using Microsoft Bot FrameworkJan 12, 2018. In our previous article, we learned how to create and connect a chatbot with Azure Bot Service. But in this article, we are going to create an intelligent Bot Application using Microsoft Bot Framework.
  • Bind Menu And Sub Menu Dynamically In ASP.NET MVC From Database Using LINQJan 12, 2018. Many times we need to create a menu for a simple application. We ususally get stuck on how to bind the menu. Here in this article we you will learn how to bind menu and sub menu dynamically in ASP.NET MVC from database using linq.
  • AI Series - Part One - Registering For Emotion APIJan 11, 2018. I will be showing how to start AI Development with Cognitive Services.
  • Explore Azure Cosmos DB Without Azure SubscriptionJan 10, 2018. Azure Cosmos DB emulator is an exciting tool for getting started with Cosmos Db. This allows us to play with Cosmos DB without even having an Azure Subscription. That means you can write Cosmos DB code in your .net application and view your data on emulator.
  • Simple CRUD Operations In Azure Cosmos DBJan 08, 2018. In this article, you will learn about Simple CRUD operations in Cosmos DB.
  • Deploy SharePoint Remote Event Receiver To Microsoft AzureJan 08, 2018. This article will help even a beginner to deploy a SharePoint Remote Event Receiver easily to Microsoft Azure.
  • Desired State Configuration In Microsoft AzureJan 07, 2018. This article describes how one can automate and align deployment of Azure resources effectively.
  • Store And Retrieve Using FILESTREAM From SQL DatabaseJan 06, 2018. Hello friends today I will explaining you regarding storing and retrieving image, video and other document files from SQL server using FILESTREAM future. If you are new to FIELSTREAM then read my previous article FILESTREAM Feature In SQL Server.
  • Availability Set, Fault Domains And Update Domains In Azure Virtual MachineJan 06, 2018. This article explains why one must plan Availability Set, Fault Domain and Update Domain while configuring Virtual Machines for Azure.
  • How To Install And Start The Reporting Services SharePoint Service In SharePointJan 05, 2018. In this article, we will learn about "How to Install and Start the Reporting Services SharePoint Service in SharePoint".
  • Azure SQL Intelligence For Database Administrator And DeveloperJan 05, 2018. When interacting with large volumes of data, Azure SQL comes into the picture. SQL Azure is a cloud database service owned by Microsoft, which is based on SQL Server database technology.
  • FILESTREAM Feature In SQL ServerJan 04, 2018. Today I am explaining what FILESTREAM is and how to use FILESTREAM in SQL server.
  • Azure Pack Vs Azure StackJan 04, 2018. The article describes key differences between Microsoft's two key hybrid cloud strategies, Azure Pack and Azure Stack
  • Create And Connect A Chat Bot With Azure Bot ServiceJan 04, 2018. This article explains how to Create and Connect a chat bot with Azure Bot Service.
  • Azure PowerShell Login IssueJan 04, 2018. At times we face issues while logging in to Azure PowerShell. There may be different types of error messages while logging in. This article explains about the resolution of the error message “The PowerShell session has not been properly initialized. Please import the module and try again."
  • Azure Stack Architecture In DepthJan 04, 2018. In this article I explain the architecture of Azure Stack in detail, in an easy-to-understand way
  • Working With Azure Storage Explorer In Visual Studio CodeJan 03, 2018. Visual Studio code is an open source source code editor developed by Microsoft which supports all major operating systems like Windows, Linux and Mac OS. It includes support all most all software development activities like debugging, Git control, syntax highlighting, intelligent code completion, snippets, and code refactoring.
  • Using jTable Grid With ASP.NET MVCJan 03, 2018. In this article, we are going to learn how to use jTable Grid with ASP.NET MVC, and along with that we are going to use Entity framework for accessing the database.
  • Azure PowerShell Module InstallationJan 02, 2018. Azure Cloud Shell and Azure PowerShell are the two different types of shells available to manage the Azure resources through cmdlets. Azure Cloud Shell can be accessed through the browser.
  • R Services In SQL Server 2017Jan 02, 2018. Hello Everyone. In this article I will be demonstrating how to use R Services in SQL Server 2017. This article is intended for those who have a basic idea of R language. If you don't, still no worries. You can still go through and grab it easily. I will go into details of R language in some other article.
  • Worker Role In Azure Cloud ServiceJan 02, 2018. From this article, you will learn how to play with worker role in Azure cloud service
  • Azure Service Bus Queues Dec 29, 2017. From this article, you will learn how to work with Azure Service Bus Queues.
  • Building CI/CD Pipeline From Scratch For Azure Deployment Using VSTSDec 28, 2017. Continuous Integration (CI)/Continuous Deployment (CD) are widely used terms in the DevOps world. If you are new or don’t fully understand the buzzword DevOps, do read this article.
  • Creating A CRUD With ASP.NET Core And EF CoreDec 28, 2017. Entity Framework Core (EF) is an ORM that makes it simpler to work with database by using POCO classes that map to database entities and DbContext to interact with them.
  • Create Your First Virtual Machine (VM) Using Azure PortalDec 28, 2017. In this article, we will talk about different free Azure subscriptions available for developers and end users. With this, we will also learn how we can create a virtual machine using Azure Portal.
  • Migrate Your Applications To Azure Virtual MachinesDec 27, 2017. Learn how to migrate your applications to Azure virtual machines.
  • Getting Started With Azure Service BusDec 26, 2017. From this article you will learn an overview of Azure service bus and ow to create an Azure service bus namespace using the Azure portal
  • Build Scalable Web Applications With Azure Database For MySQLDec 26, 2017. Azure Database for PostgreSQL and Azure Database for MySQL bring together community edition database engines and capabilities of a fully managed service—so you can focus on your apps instead of managing a database. See how the service helps you quickly respond to changing customer needs by scaling up and down. And see how capabilities like high availability and replication help you meet and exceed customer expectations.
  • Validation Of Excel Data In C#Dec 24, 2017. This article demonstrates how to validate an Excel sheet before uploading or storing its data into a database.
  • Configure Data Gateway With SQL Server Database Using Recommended Or Enterprise ModeDec 23, 2017. In this article, we will discuss how we can configure Data Gateway for On-Premise SQL SERVER Database for Live Data Connection using Recommended Mode.
  • Create And Deploy An ASP.NET Core Web App In AzureDec 23, 2017. This article will help you to create & deploy an ASP.NET Core web app in Azure.
  • How To Create An Azure Function App Using Visual Studio 2017Dec 21, 2017. In this article, we will learn how to create an Azure Functions App using Visual Studio 2017.
  • Indexing In Azure Cosmos DBDec 21, 2017. By default, the Azure Cosmos DB data is indexed. Azure applies its default indexing policy while creating a collection. However, a user can set their customized indexing policy as per requirement.
  • How To Configure Data Gateway With SQL Server Database For Live Data Connectivity Using Personal ModeDec 21, 2017. In this article, we will discuss how we can configure Data Gateway for On-Premise SQL SERVER Database for Live Data Connection using Personal Mode.
  • Xamarin.Android - Working With Firebase Database - Part TwoDec 20, 2017. Today, we are going to learn how to save and retrieve data from Firebase in Android.
  • Using Gijgo Grid With ASP.NET MVCDec 20, 2017. In this article, we are going to learn how to use Gijgo Grid with ASP.NET MVC along with that we are going to use Entity framework for accessing the database.
  • How To Call Azure Function In Logic AppsDec 20, 2017. Azure Functions is used for executing a small piece of code or “function” in the cloud and you pay only for the time your code executes.
  • Stored Procedures Vs User Defined Functions And Choosing Which One To UseDec 19, 2017. In SQL Server, we usually come across queries, tables, views, stored procedures and functions. People often wonder what are the real differences between User Defined Functions (UDF) or simply functions and stored procedures or just procedures. There are two types of functions: Built-in and user defined. Built-in functions cannot be modified where as you can create and modify your own UDF. To utilize the full advantage of these features, we should understand their capabilities and what we can do with them and what we cannot. I am going to explain this in terms of SQL Server.
  • How To Create Azure Function App To Delete SharePoint Online List Using CSOMDec 19, 2017. Azure Functions are used for executing a small piece of code or “functions” in a cloud and you will pay only for the time your code executes. You can use development language of choice such as C#, F#, PHP, Java etc. Some of the key features of Functions are Choice of language, Pay-per-use pricing model, bring your own dependencies, integrated security, simplified integration, flexible development, and open-source. Please refer Azure Functions for more details.
  • Querying ConsmosDB Using SQL APIDec 19, 2017. Here, we can find the first name and number of pets from child entity but to find out the last name we need to refer to family entity. To select last name along with first name we need to use join operator In DocumentDB
  • Cosmos DB ConsistencyDec 19, 2017. This article gives overview on consistency models available in Azure Cosmos DB
  • Xamarin.Android - Working With Firebase Database - Part OneDec 19, 2017. Today, we are going to learn how to save and retrieve the data from Firebase in Android.
  • Building Multitenant Architecture Using ASP.NET Core And Micro ServicesDec 18, 2017. Instead of deploying an application per client, organizations prefer multitenancy to save infrastructure cost and deployment time. Multitenant architecture helps to adapt changes for different clients under the hood. In this article I am not going to discuss database design for multitenant applications but I will be focused on achieving separation for different clients.
  • How To Create A Simple Azure Function App Using C#Dec 18, 2017. Azure Functions are used for executing a small piece of code or “functions” in a cloud and you will pay only for the time your code executes. You can use development language of your choice such as C#, F#, PHP, Java etc. Some of the key features of Functions are Choice of language, Pay-per-use pricing model, bring your own dependencies, integrated security, simplified integration, flexible development, and open-source. Please refer to Azure Functions for more details. In this article you will see how to create a simple Azure Function using C# that will run whenever an HTTP request is received.
  • Getting Started With Apache SparkDec 18, 2017. In Big Data, Hadoop components such as Hive (SQL construct) , Pig ( Scripting construct), and MapReduce (Java programming) are used to perform all the data transformations and aggregation . Now with Apache Spark the same is being achieved with many more advantages like unified API performance, and support for multiple languages, 10X-100X faster than MapReduce.
  • Partitioning In Azure Cosmos DBDec 18, 2017. This article gives an overview of partitioning in Azure Cosmos DB. The partition key is the JSON property (or path) within your documents that can be used by Cosmos DB to distribute data among multiple partitions.
  • Export SQL Result To A Text FileDec 18, 2017. This article gives an overview of how to export SQL query results to a text file.
  • Xamarin.Android - SQLite DatabaseDec 17, 2017. In this article, I shall show you how to handle all database CRUD operations using SQLite.
  • Xamarin Android - Working with Existing DBDec 16, 2017. In this article, I shall show you how to retrieve user data from existing SQLite Database.
  • Introducing Hadoop /Big Data For BeginnersDec 14, 2017. Companies like Facebook ,NASA, and Google have huge amount of data (can be hundreds of petabytes or exabytes). Each and every like, click, comment, review, update, search, call, visit, piece of financial and health information, transaction, photo upload etc., which is a very huge data set, gets stored somewhere(database).This data is called Big Data.
  • Create Your First Azure SQL Database Using Azure Portal Dec 14, 2017. In this article, we will talk about how we can create a new database in Azure SQL. We will learn each step in a brief manner. Most of the time when we are beginner in Azure we always have a question how we can create a database in Azure SQL. It’s very easy and simple.
  • Exploring And Managing Azure Resources Using Microsoft Azure Mobile App Dec 13, 2017. Microsoft has introduced Azure mobile app for Android & iPhone azure subscribers to get connected with there own Azure resources 24 by 7. Mobile being human chore partner, app made life easier for developers, entrepreneurs or Admin to manage provisioned azure resources anytime from anywhere. Not only can access & manage, but also can monitor health & status of Azure resources. This helps in quick resolving the issues encountered if any.
  • Getting Started With Azure Machine Learning Studio And Azure StorageDec 13, 2017. This write-up is a continuation of my previous one by which we will be sketching across how to get started with Azure Machine Learning and an introduction to Azure Storage.
  • Deep Walk On Azure Machine Learning - Why On Cloud And That Too On AzureDec 12, 2017. This article goes up with a deep walk on Azure Machine Learning covering the topics with lot many modules which heads up with loading data in azure machine learning, data preparation, azure machine learning modelling, deploying the models and about r scripts in Azure.
  • Getting Started With CosmosDBDec 12, 2017. DocumentDB is a NoSQL database which is massively scalable and it works with schema free JSON documents.
  • Starting With Google Cloud Firestore Database With AngularDec 12, 2017. Cloud Firestore is a NoSql Document database built for automatic scaling, high performance, real time, and ease of application development.
  • Remove Duplicate Rows In SQL Server Using CTEDec 11, 2017. In this article, you will learn how to remove duplicate rows in SQL Server using CTE.
  • Roles And Responsibilities Of SQL Developer Dec 09, 2017. In this article, I have shared the Roles and Responsibilities of a SQL Developer.
  • Demystifying - Azure StackDec 09, 2017. In this article, I will simplify Azure stack and in which scenarios any organization should go with Azure Stack.
  • How To Control SQL Injection In PHPDec 07, 2017. This is an interview question, when a person showcases himself as the FULL Stack developer, it is very important that the developer should have base knowledge on the security aspects of the applications.
  • Audit Made Easy Without Audit Log - Part OneDec 07, 2017. In Microsoft SQL Server, the activity of each of the database table is tracked in the other table and that is called the Audit trail or Audit log of the database table.
  • Graph API Using Android ApplicationDec 07, 2017. This article demonstrates how to add Microsoft Graph API using Android Application to get access token and call Microsoft Graph API or other APIs that require access tokens from Azure Active Directory v2.
  • Object-Relational Mapper For SQLite3 In Node.jsDec 07, 2017. Node.js is getting more popular day by day and many frameworks and platforms are supporting Node.js for its high-performance web server development. In this post, you will learn the database development in Node.js with the popular ORM library; Sequelize.
  • Step By Step Procedure To Create An Azure Logic AppDec 06, 2017. The article is on the detailed procedure of building an Azure Logic App. These steps are described with photos.
  • Azure Face API - Hands-On Using Python (Basic)Dec 06, 2017. In this article, I will be working on Azure 's Face recognition API. I will be showing you how to exploit this very powerful API in order to add recognition capabilities to your applications by detecting human faces in images.
  • Introduction To Azure Machine LearningDec 06, 2017. Watch this video to get started with Azure Machine Learning.
  • Role Of Text Analytics Service As A Connector In Azure Logic AppsDec 06, 2017. In this article, we will learn, via a demo application, about the role of Text Analytics Service, a Cognitive Services offering, as a connector in Azure Logic Apps.
  • Getting Started With Bing AutoSugesstion API On The Azure PortalDec 05, 2017. This article demonstrates how to create the Bing autosuggestion API on the Azure Portal.
  • Accessing Azure Key Vaults Using Certification Dec 05, 2017. In the old days, we used to access the Azure Key Vaults using Vault URL and its Secret Key, we were placing this in config file and going from there.
  • How To Give An Approval When A New Cognito Forms Entry Is Submitted With Microsoft FlowDec 05, 2017. This article helps you to learn how to Give an Approval when a New Cognito Forms entry is submitted using Microsoft Flow.
  • Building An ASP.NET Core Application With Web API And Code First DevelopmentDec 05, 2017. In the previous article, we’ve learned the high-level overview of what Entity Framework is all about and learned how to build a web application quickly using Entity Framework’s Database-First development.
  • Learn About Bing Image Search APIDec 05, 2017. This article demonstrates how to create the Bing Search API on the Azure Portal.
  • How To Notify Me When A Cognito Forms Entry Is Submitted With Microsoft FlowDec 04, 2017. This article helps you to learn how to Notify me when a cognito forms entry is submitted using Microsoft Flow
  • Creating An Emotion API On The Azure PortalDec 02, 2017. This article shows how to create the Emotion API on the Azure Portal and access the keys to use the Emotion API in our applications.
  • Creating An HDInsight Hadoop Cluster On LinuxDec 01, 2017. This article shows how to create the HDInsight Hadoop cluster with Linux installed on the cluster nodes in the Azure Portal.
  • Mounting Azure File Share With WindowsNov 30, 2017. This article shows how to create an Azure Storage account
  • How To Connect Box To OneDrive with Microsoft FlowNov 30, 2017. This article helps you to learn how to Connect Box to OneDrive using Microsoft Flow.
  • View Product Details Using Kendo ScrollView In ASP.NET MVC5 With Entity FrameworkNov 29, 2017. Here, I will demonstrate how to work with Kendo ScrollView to View the product details from a database using Entity Framework in ASP.Net MVC5
  • A Beginner's Guide To Windows Server SetupNov 29, 2017. All developers must be familiar with how to interact with a server for various project requirements. This server interaction varies depends on the project requirements. Some of may be just connecting to an SQL Server database server through an application, some of you may be hosting your application to an IIS server.
  • Creating Blob Storage In Microsoft Azure Using C# ASP.NETNov 29, 2017. This article will discuss how can we create/Use MS Azure storage in ASP.NET Web application using MS Libraries. I am not an expert to discuss all the part of Azure Storage, but I am sharing the things about Blob Storage.
  • Virtual Entity - New Way Of Integration - Part TwoNov 28, 2017. This is our second article regarding virtual entity, if you have not checked our earlier article, we suggest you check that first here. In this article we are going to demonstrate about create OData Web API without Entity Framework and hosting it in Azure to consume into Dynamics 365. Let say we have employees data that we want to show into virtual entity, so let’s get started!!
  • Creating A Windows Virtual Machine On The Azure Portal And Expanding The OS DiskNov 28, 2017. This article demonstrates how to create a Virtual Machine on the Azure portal and also how to expand the OS Disk for high space availability.
  • What Is Azure Databricks?Nov 28, 2017. Learn what Azure Databricks is.
  • Adding A DataDisk To Our Virtual MachineNov 28, 2017. This article shows how to add a disk to our Virtual Machine for additional data storage.
  • How To Notify Me About Positive Twitter Posts Using Microsoft FlowNov 28, 2017. This article helps you to learn how to notify me about Positive Twitter posts using Microsoft Flow
  • Chat Bot With Azure Authentication - Part TwoNov 27, 2017. In the previous part of the article series, we have completed initial setup such as app registration, Azure Active Directory Authentication and saving AccessToken to Bot State Service. In this part of the article, we will implement chat bot which will get the AccessToken from Bot State Service and make Azure service call.
  • Configuring Log4Net With Database - A Tutorial For BeginnersNov 26, 2017. Log4Net is a framework for logging .NET applications. It is an open source library that can be used to log output for different targets like logging output in Text files, Database, Console, Mail (SMTP), Remote and others. In this article, I will explain how to log output in a database.
  • How To Build A Kubernetes Cluster On Azure Using KubesprayNov 26, 2017. The concept of sticking our compiled code into containers is becoming quite popular at the moment, and for very good reason. If you develop for the cloud, and don't use containers or similar technology now, then you should really take a look at whats involved. The huge benefits of using containerized infrastructure/deployment are being pushed by the cloud vendors, and also increasingly being recognized by mainstream enterprise as an all round good egg and something worth investing time and resources into embracing. Containers and 'server-less computing' are two technologies that most developers are going to have to embrace in the next short few years.
  • Pug Vs HTMLNov 26, 2017. In the holy wars of "Pug vs HTML", it is really confusing sometimes to realize which one of these to use. The same is true for SQL vs NoSQL, and the similar is true for Java vs Python. Then people think why not talk about Pug vs HTML as well. HTML is always the perfect language to consider, however for the case of Pug there might be a bit of confusion. Some developers don't know Pug, and some who know it, know it as a Jade framework.

About Database-SQL-Azure

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!