C# Corner

Resources  
  • 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.
  • Exposing Local Web Server To Internet Using NgrokSep 19, 2017. I was recently working on some bot framework applications where I wanted to test if my bot application was working properly with different available channels like Facebook messenger, Skype etc. But there was one problem. Before I could integrate my bot with different channels, I needed to publish my bot application and register it on http://dev.botframework.com/ site. Also the endpoint should support HTTPS. This is where ngrok comes into play.
  • Missing Security Section In PWA Settings In Project Server 2016Sep 18, 2017. In this article, we will discuss and solve the issue of Missing Security Setting in PWA Settings in Project Server 2016 / 2013.
  • 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.
  • Introduction To Tag Helpers In ASP.NET CoreSep 18, 2017. Tag helper is a new feature in ASP.net MVC. It enables server-side code to create and render HTML elements in Razor View. It is feature of Razor View engine. They are the C# classes which participate in view generation by creating the HTML elements. Using the tag helper, we can change the content of HTML element and add additional attributes to the HTML element. It is very similar to HTML helper in ASP.net MVC.
  • 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.
  • 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
  • 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.
  • SharePoint Permission Mode Vs Project Permission Mode In Project Server 2016 / 2013Sep 14, 2017. In this article, we will discuss the Permission Modes in Project Server 2016 / 2013.
  • Build Chat Application On MEA2N Stack - Part OneSep 13, 2017. In this article we are going to build a basic chat application on NodeJs platform using Express and Angular 2. For saving chat history we will use MongoDB. We will be using socket.io for communication between server and client.
  • 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.
  • 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.
  • 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 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.
  • 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”.
  • 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.
  • Understand Serverless Architecture In AzureSep 05, 2017. This article will give an overview about the server-less architecture functionality present in Azure using Logic App.
  • How To Backup A Mirrored Database Using SQL AgentSep 04, 2017. Database mirroring is a primarily software solution for increasing database availability. Mirroring is implemented on a per-database basis and works only with databases that use the full recovery model. The simple and bulk-logged recovery models do not support database mirroring. Therefore, all bulk operations are always fully logged. Database mirroring works with any supported database compatibility level.
  • How To Upgrade AD FS 3.0 To AD FS Server 2016 - Part TwoSep 01, 2017. This article is in continuation of my previous one. Here we will see how to upgrade AD FS 3.0 to AD FS Server 2016.
  • How To Upgrade ADFS 3.0 To AD FS Server 2016 - Part OneAug 31, 2017. Being said that, Now a days ADFS is one of the very critical infra since it is used for Identity services which being used for office365, Azure, Applications be it in any which way it is been created/developed in terms of SAAS, PAAS and On-premises. I have seen the scenarios where ADFS is down, the complete company’s major applications are also going down. So we need to carefully plan and upgrade the ADFS infra. Any wrong command or wrong execution plan can mislead the infra and complete ADS infra can go down.
  • Extend Built In Label Tag Helper In ASP.NET Core ApplicationAug 31, 2017. Tag helpers is one of the new feature introduced in ASP.NET Core which allows us to add server side code while creating and rendering HTML elements. They are similar to HTML helpers in ASP.NET MVC. ASP.NET Core comes with various built in tag helpers for rendering HTML elements like label, input, img, select etc.
  • What Is New In Azure Portal UpdatesAug 29, 2017. In this article I am talking about a video in which Leon Welicki and Scott Hanselman introduce us to an update from Azure Portal.
  • Working With JSON In SQL Server 2016Aug 28, 2017. JSON (JavaScript Object Notation) is a lightweight data interchange format. It is language independent, easy to understand and self-describing. It is used as an alternative to XML. JSON is a very popular data interchange format nowadays. Most modern services return the data into the JSON text.
  • New Features In SQL Server 2017Aug 27, 2017. There are many new features introduced with SQL server 2017 and also there is some performance improvement in existing features. Using the following links, we can learn more details about the new features in SQL server 2017.
  • Creating Login Form For Users With Image Uploading For Password RecallAug 27, 2017. The article is an alternate method of creating a login form where the conventional way of giving a password hint will be given as a question. In this, you can add an image which can be your hint if you forget your password.
  • Create Your Own Home .NET /Apache Web Server In 30 MinutesAug 25, 2017. Most C# developers have been yearning to install their work on Apache and Linux, using the Mono project for years. Unfortunately this has been historically very difficult, since the documentation for how to do this has been lacking. In addition, securing and configuring the system after you've installed it, often requires a whole slew of knowledge with which most C# developers are not very familiar.
  • RSS Viewer Webpart In SharepointAug 23, 2017. In this blog, I will explain how to use RSS Viewer webpart to display feeds from external websites to the SharePoint portal.
  • JavaScript Code For Validating U.S. Format Phone NumbersAug 21, 2017. In this article, we shall learn how to do client side validation of US format phone numbers in three textbox fields. It means the application will be more responsive because the load on the server is reduced. JavaScript uses the client machine processing power.
  • Deploying Traffic Manager On Azure PortalAug 17, 2017. In this article, I am going to describe what Traffic Manager is and how to deploy the Traffic Manager on the Azure portal.
  • Load Twitter Data Into SQL DatabaseAug 15, 2017. The requirement is to extract the data from Twitter and load extracted data into SQL Database. For this demonstration I am going to read the Indian Film actor Kamal Haasan's tweets and load that into SQL Server 2016 Database.
  • How To Create And Test Azure Functions Using Azure PortalAug 15, 2017. Azure Functions is a solution for easily running small pieces of code in the cloud. We can create, execute, and test our custom logic function without creating a VM or web applications and also without needing to install any software or infrastructure to run the function. In this article, you will learn about create and test azure functions using azure Portal.
  • Google OAuth 2.0 Authorization In Azure APIAug 13, 2017. Here, I am going to demonstrate how can we use Google OAuth 2.0 in Azure API. App Service Authentication/Authorization is exposed in the Azure Preview Management Portal.
  • Deploying Batch Services In User Subscription Mode On Azure PortalAug 11, 2017. This article is in continuation of my previous one and we'll learn how to use User Subscription for Batch Services in Azure portal.
  • Deploying Batch Services On Azure PortalAug 11, 2017. In this article, I am going to describe what Batch Services are and show how to deploy them on the Azure Portal.
  • Building Container Image Through AutomationAug 10, 2017. The following is the continuation of the previous document. Here we will work with the automation concept through which the container images can be created.
  • Create SQL Server Database Project With Visual StudioAug 08, 2017. In this article, we’re going to learn about how to we can manage our database scripts using Visual Studio’s SQL server database project.
  • Deploying A Docker On Ubuntu Using Microsoft Azure PortalAug 08, 2017. This article shows how to install docker on ubuntu in the Azure portal. Sign-in into the Azure Portal by entering your email and the password, If you don't have any account press this Link to create a new account.Enter the mail address and press next.
  • Deploying An Ubuntu Server 16.04 LTS Virtual Machine Using Microsoft AzureAug 08, 2017. In computing, a Virtual Machine is an emulation of a computer system. Virtual machines are based on computer architectures and provide functionality of a physical computer. Their implementations may involve specialized hardware, software, or a combination. Azure Virtual Machine (VM) is one of several types of on-demand , scalable computing resources that Azure offers.
  • How To Determine The Version And Edition Of SQL Server And Its ComponentsAug 06, 2017. For Business Intelligence features such as Integration Services, Reporting Services, and Analysis Services, you may have to install the latest service packs, cumulative updates, and hotfixes on the client-side computers to obtain the latest fixes while developing SSIS packages, SSRS reports, or Analysis Services cubes.
  • Building Your Own Container ImagesAug 04, 2017. Here, we will be building our own container images. For doing this we have two different ways, namely manual method and automated method. Let us see both ways.
  • Pulling Base Container ImagesAug 03, 2017. So far, we have deployed our container in the Nano Server VM and Windows Server VM. The next piece of work is to pull down the Images for these containers. The Docker is the container which we have created so far. In the following lab, we will pull some image for that container form the Microsoft Container images repository.
  • Running Windows Containers On Windows Container HostsAug 03, 2017. In this module, we will be seeing the different commanding techniques that can be used to work with the containers. We will check on how to start and stop a container, and to run them interactively or even in the background.
  • Configuring Nano Server For Remote ConnectionsAug 02, 2017. Here, we are going to connect with the Docker engine remotely using the PowerShell. For this we can either use our local machine or a VM. Before we proceed further, make sure that your Nano Server is up and running.
  • Azure Portal New Preview Of App Service DomainAug 02, 2017. Azure team continues working on improvement of their website, and keeps adding more user-friendly and easy options for users. In this series, now they have launched a new preview of app service domain.
  • Creating Windows Server Machine On Virtual Network And Load Balancing itAug 01, 2017. Welcome back to an article about creating another Windows Server Machine on Virtual Network and to work with Load Balancing. Here with this demo article we will be working with the Virtual Network and we will be creating a Load Balancer on it.
  • Connecting To Docker In Nano ServerAug 01, 2017. This is about creating a firewall path in between the local machine and the Nano server to get connected with the Docker. This will give access for local machines to access the docker.
  • Azure Automation Using PowerShellAug 01, 2017. In order to run Azure, we know the Azure web portal where we can modify and manage resources as and when needed. But to manage resources on a regular basis, logging into the portal each time is a hectic job. So, automation can solve most of these problems for us. In this article, we will learn how.
  • Creating A V-Net And Adding A Windows Server Machine On ItJul 31, 2017. Welcome to an article about creating a Virtual Network and adding a Windows Server Machine on it
  • Installing Docker In Nano ServerJul 31, 2017. This is about the installation of Docker in the Nano Server VM which has been created previously.
  • Installing Windows Server-2016 Nano Server Using PowerShellJul 30, 2017. The following exercise is all about the installation of Windows Server 2016-Nano Server. Open your PowerShell in the administrator privileges.
  • Installing Docker In Windows ServerJul 29, 2017. The following document will provide you the step by step guide to create a windows server operating system and install the docker in it. To proceed with this, you need to login into your Microsoft Azure portal.
  • Creating Web API With ASP.NET Core Using Visual Studio CodeJul 28, 2017. Web API is is framework that allows us to build web or http based endpoints. If you are building services today for mobile, HTML 5, and even client-server desktop applications, all these different types of applications need services in the backend.
  • Managing Your Traffic On Server Applications Using Geographic RoutingJul 28, 2017. Welcome to my first writing on Azure Traffic Manager using Geographic Routing.
  • How To Check Long Server-Side Process Progress In Real TimeJul 26, 2017. Today, I will show you a way to monitor a long server-side process (like, a long running process, file generation etc.) in real time in your web application. The whole demonstration will be covered through asp.net C# but you can also implement the same sort of code in other languages.
  • Learn MVC Using Angular Dynamic Control In DataTableJul 26, 2017. In this article, we will learn MVC using Angular data binding for dynamic control in datatable from server side Web API using visual studio 2017.
  • Combination Of Id-ParentId And HierarchyId Approaches To Hierarchical DataJul 26, 2017. How to combine the Id-ParentId and HierarchyId approaches to keep and fetch the data in hierarchical and alphabetical order.
  • Cache Headers For MVC File Action Result (ASP.NET Core 2.0 Preview 2)Jul 25, 2017. I’m pretty sure that you are familiar with StaticFiles middleware of the framework. All it does is serve static files (CSS, JavaScript, image, etc.) from a predefined/configurable file location (typically from inside the web root, i.e., wwwroot folder). But along the way, it also does some cache headers configuration. The reason behind this is you don’t want your server to be called up every time for a file that doesn’t change frequently. Let’s see how a request for a static file looks in the browser’s network tab.
  • Angular, Bootstrap And ASP.NET MVC - Part TwoJul 25, 2017. In this tutorial series, we are going to learn AngularJS as a server side, Bootstrap for layout styling and ASP.NET MVC as server side.
  • Angular, BootStrap And ASP.NET MVC - Part OneJul 24, 2017. In this tutorial series, we are going to learn AngularJS as a server side, Bootstrap for layout styling and ASP.NET MVC as server side.
  • How To Use Query Editor For Azure SQL Database In Azure PortalJul 24, 2017. Azure Portal provided Query editor for database operations, which is very good for us. We don’t need any software installation in our computer; we can access and perform the task online.
  • Creating An Azure SQL Database And Connecting Through SQL Server Management StudioJul 23, 2017. This article demonstrates how to create an azure SQL Database, setting the Firewall rule and connecting through the SQL Server Management Studio.
  • Project Server 2013 Migration From One Farm To AnotherJul 21, 2017. In this article, I will explain step by step how to migrate/move a PWA Instance from one farm to another in Project Server 2013.
  • Create SSRS Drilldown ReportJul 17, 2017. Create SSRS drill down report, add link enable/disable based on specific condition, adding download links in reports.
  • Selecting A Content Management System That Supports Your BusinessJul 17, 2017. Recently, a customer asked for a Content Management System (CMS), and being a SharePoint developer and consultant, I proposed SharePoint Server as CMS. Afterwards, by analyzing different CMS in the market, I thought of writing this article and will focus mainly on a CMS named – “Sitefinity” (http://www.sitefinity.com/).
  • Taking Script From Database In SQL Server In Different ModeJul 17, 2017. This article explains how to take the script from database in SQL server in a different mode. Normally we take back up our entire database as “.bak, .mdf, .ldf” file but sometimes we need to alter, update or delete then create our database based on our database modification.
  • Ability To Develop HTTP Methods Or Verbs (GET, POST, PUT, DELETE etc)Jul 17, 2017. Before going to explain the significant verbs or methods (GET, POST, PUT, DELETE, HEAD, OPTIONS, TRACE and CONNECT) for the communication among different clients and servers, first of all we should understand what HTTP methods are and how they are useful in real time.
  • SharePoint 2016 Build NumbersJul 15, 2017. SharePoint Server 2016 released on March 14, 2016. So let's try to track all the version numbers, Build numbers, and Issue lists.
  • Deploying Event Hubs In Azure PortalJul 14, 2017. This article shows how to deploy the Event hub in the Azure portal. Azure Event Hubs are highly scalable data streaming platforms and event ingestion services capable of receiving and processing millions of events per second. Event Hubs can process and store events, data, or telemetry produced by distributed software and devices.
  • How Autodiscover Service Works In ExchangeJul 14, 2017. In this article, we will cover how Autodiscover works in Exchange to configure outlook profile for users without manual intermission of the user or administrator. Let’s begin!!
  • Deploying Visual Studio 2017 In Azure PortalJul 13, 2017. In this article, I am going to demonstrate how to create and deploy Visual Studio 2017 in the Microsoft Azure portal.
  • How To Create A List/Library Programmatically In SharePoint 2013Jul 13, 2017. We need to install Visual Studio in our machine for creating a list using SharePoint Server Object Model. The Server Object Model will be executed in the server side & it provides a rich set of classes in representing & manipulating SharePoint objects. Server object model is like production server environment to access the data where Sharepoint is installed on the machine.
  • Commands For "Add", "Install", "Update" The Solutions For SharePoint SiteJul 13, 2017. In this article, I would like to share the steps and commands for how to Add, Install and Update, Uninstall and Remove the solutions (WSP Package) in SharePoint server.
  • Mirroring Database In SQL ServerJul 12, 2017. When there is any automatic failure we need another server that will monitor the principal server.
  • Consume Web API In Winform For File HandlingJul 12, 2017. In this article, we will see in detail how to consume Web API in Windows Form for Uploading File to Web server, get the list of file Information from Server folder and download the file from Server using C# Windows application.
  • Creating Internet Connectivity Load Balancer Using Azure PortalJul 11, 2017. Azure provides a variety of networking capabilities that can be used together or separately. But In this Article we will see about the one of the key capabilities (i.e Internet Connectivity).
  • How To Query The Entities In Dynamics CRM From ADX Portal Using JQueryJul 11, 2017. It is difficult to get the Dynamics CRM Entities from ADX Portal using any Web API call, because that may require authorization token, client id and client secret etc. Also, you will not be able to get any client context or to use XRMServiceToolKit.
  • Deploying The Windows Server 2016 Virtual Machine Using Microsoft AzureJul 10, 2017. This article shows how to deploy the Windows server 2016 virtual machine in Azure Portal.
  • Getting Started With MongoDB - MongoDB In Azure Cosmos DBJul 10, 2017. My last article demonstrated how to interact with the MongoDB database server from a simple C# console application. Now, when you build enterprise applications using MongoDB, your local database server should always be up and running for 365 days or more. This is not appropriate for enterprise applications.
  • Monitoring Our Database When Accessing From Outside Or Applications In SQL ServerJul 08, 2017. This article explains how to monitor our database when accessing from outside or any other applications in an easy way.
  • Get Started With Azure DevTest Creating Server Machines With ArtifactsJul 07, 2017. Azure DevTest is an effective resource that Azure has come up with for supporting developers and testers to avoid environment delays, allow self-service actions on turning the VM’s (Virtual Machines) on or off, and works with simple cost effective solutions to leverage the application which we host on the cloud.
  • Microsoft Azure Cloud Shell Startup And Creating A Linux VM WebServer Using Cloud ShellJul 06, 2017. Microsoft Azure Cloud Shell is very interactive, easy and browser accessible shell platform for creating, maintaining and managing all Azure resources using portal only. Azure Cloud Shell provides you access to Azure CLI browser based experience which supports built in tasks.
  • Deploying Logic Apps Service In Azure PortalJul 06, 2017. Logic Apps are used as fully managed iPaaS (integration Platform as a Service) allowing developers not to have to worry about building hosting, scalability, availability and management.A logic app begins with a trigger after firing and can begin many combinations of actions, conversions, and condition logic. It also provides the path to simplify and implement scalable integrations and workflows in the cloud. It provides a visual designer to model and automate your process as a series of steps known as a workflow.
  • Simulate SharePoint Online Timer Jobs Using Azure FunctionsJul 05, 2017. SharePoint Server provides native Timer Jobs that inherit SPJobDefinition class to run at regular intervals defined in the SPSchedule object. This way we can create solutions that have to be iteratively run to process logic at regular intervals. However, in case of SharePoint Online Native Timer Jobs cannot be used.
  • Get Started With Azure Portal Mobile AppJul 04, 2017. Azure client app provides high-level access to Azure Resources which helps the user to perform basic operations with just a click from your mobile. This article focuses on the Azure mobile app, which helps to manage/supervise Azure Resources on the fly.
  • Installing SQL Server vNext On Linux - Part TwoJul 04, 2017. With the release of Microsoft SQL Server on Linux, it is a huge step towards gaining markets in Database Technologies giving competition to other RDBMS software. Microsoft SQL Server is not only on Windows but it is on Linux also and people who love Linux can check the flavor of SQL Server in the Linux environment.
  • Deploying An Azure SQL Database In Microsoft Azure PortalJul 03, 2017. This article shows how to create and configure the firewall and how to run sample sample queries in the SQL Database using Azure Portal.
  • Getting Started With MongoDB - MongoDB With C#Jul 01, 2017. In my previous article, you got a little knowledge of MongoDB basics. This article will focus on doing CRUD operations from a C# console application. The working mechanism will be same for web applications and desktop applications. Open up the mongod.exe in the command prompt to keep the MongoDB server running while executing our C# application.
  • Learn AWS With MS-SQL(DB) Using SQL ClientJul 01, 2017. You want to login to the AWS console here. If you have no login register new users in here. After registering amazon will provide one year free access.
  • Deploying The Azure DNS Using Microsoft Azure PortalJun 28, 2017. An Azure DNS is used to host the DNS records for a particular domain and the Domain Name System, or DNS, is responsible for translating (or resolving) a website or service name to its IP address. Azure DNS is a hosting service for DNS domains, providing name resolution using Microsoft Azure infrastructure. By hosting your domains in Azure, you can manage your DNS records using the same credentials, APIs, tools, and billing as your other Azure services.
  • Angular Demo Application With ASP.NET Core MVC (Rent A Car)Jun 26, 2017. This project is a simple rent a car project developed in ASP.NET Core MVC and Angular with backend as SQL Server 2008 R2.
  • Help System In Windows PowerShellJun 26, 2017. Windows PowerShell Help system is the most important resource in PowerShell. Starting with Windows 8 and Windows Server 2012, PowerShell doesn’t come with help already in the system, you have to update it. So the first thing you have to do when you launch PowerShell is to update the help.
  • Daily Shrink Database Log Automatically Using Jobs In SQL ServerJun 24, 2017. This article explains how to shrink database log daily using jobs in SQL server by step by step. We can shrink database logs automatically using jobs in SQL Server that we no need to run SQL Script manually.
  • Different Formats In Report Generation Using JSReport ServerJun 23, 2017. The JSReport Server supports different types of formats in report generation like pdf, xlsx, html, text, html to xlsx etc. In previous article the report was generated in PDF format.
  • Building Apps With Polymer And ASP.NET CoreJun 23, 2017. I’M USING ASP.NET CORE WEB API TEMPLATE FOR CREATING A SERVER TO HOST THE PROJECT. IN THE NEXT PART OF THIS SERIES WE WILL SEE HOW TO MAKE APIS AND CALL THEM FROM THE CLIENT SIDE.
  • Xamarin.Android - List View Using SQL Server DatabaseJun 21, 2017. In this article you will create a Xamarin Android List View using SQL Server.
  • Automatic Daily Database Backup To Specific Database In SQL ServerJun 21, 2017. Automatic Daily Database Backup To Specific Database In SQL Server.
  • Creating Azure Data Lake Analytics Using Microsoft Azure PortalJun 20, 2017. This article shows how to create a data-lake analytics using Azure portal.
  • CRUD Operation Using Stored Procedure In ASP.NET GridView Real TimeJun 16, 2017. A GridView is a graphical control element that presents a tabular view of data.
  • To Get All File Details From Local File Into SQL ServerJun 14, 2017. TO Get All File Details From Local File Into SQL Server.
  • Concept Of Change Data Capture (CDC) In SQL Server - Part ThreeJun 13, 2017. Concept Of Change Data Capture (CDC) In SQL Server.

About portal-server

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!