C# Corner

Resources  
  • Virtual Machine Scale SetAug 23, 2017. The Virtual Machines are highly flexible such that they can be changed in their size and the performance based on the requirement of the user. The resources which we actually require can be decided by us and then the user can be able to scale up or down the Virtual Machine. When making changes to the Virtual Machine size, the cost that is charged for the Virtual Machine will also vary. Here the size of the Virtual Machine will include the number of cores, the Random-Access Memory, number of data disks, the IOPS range, SSD size, load balancing feature and premium disk support.
  • How To Use Microsoft Graph Provider In Visual Studio Connected ServicesAug 22, 2017. In this article, I am introducing the newly added Microsoft Graph Provider in Visual Studio 15.3.1. This article demonstrates how a developer can use this feature to work with Microsoft Graph API.
  • 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.
  • Transform XML Output Of SQL Query To HTML Using "For XML" AUTO Statement With XSLT In C#Aug 21, 2017. Normally, we execute the query using ExecuteNonQuery statement and fill the output into data table. This article describes how to transform the XML output of SQL query statements using FOR XML AUTO to HTML using XSLT.
  • Areas In ASP.NET Core MVCAug 20, 2017. Area is a beautiful feature of ASP.net MVC that allows you to organize related functionality into a group. We can create a hierarchy for the physical grouping of the functionality or business component.
  • Connecting Login Form In C# With Database For User Type AuthenticationAug 15, 2017. This article describes how to connect a Login Form designed in C# with a database so that the user gets validated based upon the password given by the administrator who has created the login database.
  • 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.
  • Key Capabilities Of Azure Cosmos DBAug 12, 2017. A few years ago, Microsoft offered DocumentDB as a Service (DaaS) that supported a limited set of features and functionalities. Today, most of the cloud-based services, such as Bing, Azure, and Office 365 are using DocumentDB. Microsoft took DocumentDB to the next level and came up with Azure Cosmos DB - A globally distributed, multi-model database.
  • Boosting Up The Reflection Performance In C#Aug 10, 2017. Reflection is a way of obtaining metadata information about the types used in applications, which helps you describing the types, modules or assemblies at runtime. This is an extremely useful feature in the strongly-typed languages like C#.
  • 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.
  • Introducing Central Administration Of SharePoint 2016Aug 09, 2017. Central Admin helps us to control the user activities. It controls even the activities of the site owners, which help us in protecting the environment and keeping it secure. This helps us to activate or deactivate the configurations and features through all the Web Applications, site collections and sites; thereby, saving time and efforts.
  • Creating Login Form With Authentication For User Login Using C#Aug 09, 2017. This article describes how to create a login form and to validate user login with additional feature like changing pictures according to the type of user
  • SQL Azure With Entity FrameworkAug 08, 2017. Exploring SQL Azure With Entity Framework
  • 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 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.
  • Understanding Azure Data Lake AnalyticsAug 07, 2017. This article will give an overview of Data Lake analytics account and create U-SQL job and execute this job to put data into the .csv file.
  • Understanding SQL Azure - Part OneAug 06, 2017. This article will give a idea about creating SQL DB in Azure and using it in Visual Studio
  • 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.
  • Understanding SQL Azure - Part TwoAug 06, 2017. This article will allow us to connect with SQL Azure and perform CRUD operations using EF.
  • Compare Azure SQL Database And Azure SQL Data WarehouseAug 05, 2017. In this article, I am going to compare both Azure SQL database and Azure SQL data ware house. I was reading many articles; below is the tabular compression of both.
  • 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.
  • Setup And Connect To Azure SQLAug 03, 2017. Microsoft Azure SQL Database (formerly known as SQL Azure) is a managed cloud database i.e. Software as a Service (SaaS) provided by Microsoft Azure. In simple words, Microsoft Azure SQL is a cloud database that runs on a cloud computing platform and access to it is provided as a Service.
  • 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.
  • AWS Lambda And Serverless ComputingAug 02, 2017. Before we learn and understand one of the great features provided by AWS known as AWS lambdas, let’s try to understand what Serverless Computing is.
  • 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.
  • 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.
  • Getting Started With Visual Studio CodeJul 31, 2017. In this article, we will discuss in detail about the Visual Studio Code, how to install the VS Code in Windows and walk through with VS Code features and how to add extensions to VS Code.
  • Entity Framework CRUD Operation Performed With SQL Stored Procedure Using ADO.NET Entity Data ModelJul 31, 2017. You can see my pervious article for Entity framework with Ado.Net data Model connection and how to create a new entity framework project and sql database connection maintained with created entity framework project. Also you can see how to create a class in entity framework based on data table.
  • How To Create Web Job in Azure Web appJul 31, 2017. Azure web job is the most useful feature in Azure web app service. It will be great helpful when you want to run the scripts or programs as background processes in app services, api app and mobile app .
  • Installing Docker In Nano ServerJul 31, 2017. This is about the installation of Docker in the Nano Server VM which has been created previously.
  • 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
  • How To Use Visual Studio For Azure SQL DatabaseJul 31, 2017. This article demonstrates using Visual Studio step by step for Azure SQL Database operation.
  • 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.
  • Getting Started With Visual Studio Team ServicesJul 28, 2017. In this article, we will discuss in detail about the Visual Studio Team Services, walk through VSTS features, compare with VSTS and TFS, learn how to create VSTS account and how to publish the source code to VSTS.
  • Managing Your Traffic On Server Applications Using Geographic RoutingJul 28, 2017. Welcome to my first writing on Azure Traffic Manager using Geographic Routing.
  • Progressive Web App - The Latest Technology Disruption Developers Must Master TodayJul 27, 2017. Would you be surprised to learn that some of your favorite apps are web sites? An emerging trend is companies of all sizes are migrating their client strategy to web only, abandoning native apps. There are several reasons for this strategic business decision. Consumers no longer download apps and the web platform has added many key features, elevating the web past native apps.
  • API Testing With PostmanJul 27, 2017. Postman is a rest client with an API development suite with powerful features. Postman is a google chrome application for testing API calls which can also be used with the Developer Tools Utility to test these API calls and not have to worry about importing any files or setting up Authentication.
  • Angular, Bootstrap And ASP.NET MVC - Part Four (Angular Routing)Jul 27, 2017. In this tutorial, we are going to learn how we can navigate from one HTML page to another using angular routing. AngularJS provides a nice feature that we can navigate to another page but without reloading the whole page. We can use “ngRoute” module to achieve this.
  • Visual Studio 2017 New Installation Experience - Workload - Individual Component - Language PacksJul 26, 2017. In this article, I will show the new installation experience feature that was introduced in Visual Studio 2017
  • 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.
  • 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.
  • 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.
  • 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.
  • Learn Web API : Using SQL Helper ClassJul 25, 2017. This article demonstrates how to use Web API Using SQL Helper Class with easy to use data base access in Visual Studio 2017.
  • Lazy-Loading NgModules In ASP.NET Core Angular SPAJul 25, 2017. This article shows you how configure ASP.NET Core Angular SPA starter project to serve a lazy-loaded Angular module. Angular has this cool feature of loading a module lazily. Modules that are set up to load lazily can significantly save application startup time. Lazy-load module set up is done in the application’s routing configuration section.
  • 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 A Weather Forecast Feature With Microsoft Flow, SharePoint And MSN WeatherJul 24, 2017. Today, we are going to create a solution using Microsoft Flow, Microsoft SharePoint and MSN Weather to control the weather forecast feature of my company´s branches in our intranet and I will show you how we can show this information in a simple way to our users.
  • 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.
  • Change SharePoint ListView To jQuery Datatable Using JSLinkJul 21, 2017. Jslink is javascript link [ CSR - Client-side rendering] this feature was introduced in Sharepoint 2013 for customizing Sharepoint list forms Newform, displayform, editform. Using this feature you are able to change the overall look and feel of the sharepoint listp
  • What Is Three State Workflow In SharePoint 2013?Jul 18, 2017. Microsoft has already provided an Out Of Box feature Called Three State Workflow. Using Three State Workflow, we can track our list or library in three states . This is very useful when tracking issues, project tasks, leads, or other similar items.
  • 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/).
  • Create SSRS Drilldown ReportJul 17, 2017. Create SSRS drill down report, add link enable/disable based on specific condition, adding download links in reports.
  • 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.
  • 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.
  • ABC Of WPFJul 15, 2017. Basically I am working on .Net/Sql. For the project requirements I went through the WPF. I visited so many online tutorials and videos to get the knowledge. In this article I am going to share my understanding with you.
  • Site Columns In SharePoint 2013Jul 15, 2017. Site column is on of the good features in SharePoint . You can reuse the column within your site and subsites. you can also reuse within content type in SharePoint.
  • 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.
  • 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!!
  • 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.
  • Connecting And Working With Azure SQL Database Using Visual Studio 2017Jul 12, 2017. This article shows how to connect and work with the Azure SQL Database. In this article, I am going to demonstrate how to connect and work with the Azure SQL Database using Visual Studio 2017.
  • Understanding ASP.NET - Part Three - Building Reusable And Configurable MiddlewaresJul 12, 2017. In this series we are learning about new Owin and Katana features in ASP.Net 4 and above. So, if you are new to OWIN then please go back and check other parts as well where we discussed all the details about OWIN, what benefits it provides and why we should use it.
  • Introduction To SharePoint Event ReceiversJul 12, 2017. Event Receiver is a important feature in SharePoint . The use of Event Receiver is to handle the events. It is like a method that is triggered when an action occurs on a specified SharePoint object.
  • Disposition Approval Workflow In SharePoint 2013Jul 12, 2017. Microsoft has provided so many outbox workflows to manage our list or libraries etc. Disposition Approval workflow is one of the OOB features in SharePoint 2013.
  • 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.
  • Mirroring Database In SQL ServerJul 12, 2017. When there is any automatic failure we need another server that will monitor the principal server.
  • How To Save Site As A Site Templates In SharePoint OnlineJul 11, 2017. If you are using the publishing site template then this option will not be available. Also if you have a team site with publishing feature activated on it then this option will disappear.
  • 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.
  • Enabling Multi-Process Support In Firefox 54 For Faster BrowsingJul 07, 2017. In this article we will see how to enable a new feature of Mozilla Firefox ,called Multiprocess, on your computer.
  • 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.
  • 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.
  • 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.
  • Understanding Interface With Real World ImplementationJul 03, 2017. In our day to day lives we learn new things; similarly in terms of programming we want to keep ourselves updated and learn every new feature. Learning a new thing is good but it doesn't become beneficial for you until you implement it in your application. Thus this article is about one of the topics that every programmer knows very well but they don’t know how to implement get the benefits.
  • How To Download SQL Records In Excel Format Using MVCJul 02, 2017. I will explain how to download records in Excel format from database.
  • 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.
  • 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.
  • How To Create A Grid Dynamically Using AngularJun 30, 2017. Create a grid dynamically with angularjs without hardcoding column names. AngularJS provides various features. One of them is 2 way data binding. In this article I will explain how you can create a grid dynamically from Angular.
  • Debugging With Chrome In Visual Studio 2017Jun 30, 2017. Debugging client side script using IDE is a most exciting feature in Visual Studio 2017, recently I have updated my IDE and after creating a new ASP.Net Core application I have noticed the below splash screen before starting the application, soon later I realize about the new exciting feature and then I decided to explain it to others.
  • Emotion Recognition In Xamarin.Forms With Microsoft Cognitive ServicesJun 29, 2017. Microsoft Cognitive Services offer awesome APIs and services for developers to create more intelligent applications. You can add interesting features, like people's emotions and video detection, face, speech, and vision recognition and speech and language understanding into your application.
  • ECMAScript5 Features - Strict Mode, JSON And MoreJun 28, 2017. Strict Mode is a new feature in ECMAScript 5 that allows you to place a program, or a function, in a “strict” operating context. This strict context prevents certain actions from being taken and throws more exceptions (generally providing the user with more information and a tapered-down coding experience).
  • 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.
  • How To Create Azure SQL Database And Access It Through Visual Studio CodeJun 26, 2017. In this article, I’m going to cover how to create Azure SQL database and how you can access it through Visual Studio code.
  • 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.
  • Getting Started With Microsoft Azure Cognitive Services APIs AccountJun 25, 2017. Microsoft Cognitive Services offer awesome APIs and services for developers to create more intelligent applications. You can add more interesting feature like people emotion and video detection, facial, speech and vision recognition and speech and language understanding into all the applications.
  • Updated Chrome Debugging Tools Worth MentioningJun 24, 2017. As a web developer, I absolutely could not live without great in-browser developer tools. I use them every day, and they can certainly make your life much easier. Typically my browser of choice is Chrome, so I thought I would take some time to introduce a few new features in the latest release that are really, really cool.
  • 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.
  • Automatic Daily Database Backup To Specific Database In SQL ServerJun 21, 2017. Automatic Daily Database Backup To Specific Database In SQL Server.
  • Xamarin.Android - List View Using SQL Server DatabaseJun 21, 2017. In this article you will create a Xamarin Android List View using SQL Server.

About unused-feature-in-Sql-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!