C# Corner

Resources  
  • 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.
  • 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
  • Purchasing A New Service To Your Office 365 TenantSep 21, 2017. This is going to be a very simple article where I’ll be describing about how to add a new service to your Office 365 tenant. Let’s say there comes a scenario where your organization has been using Office 365 for quite some time and all of a sudden, the business shows interest on a new Office 365 service then you need to follow the steps mentioned in this article below to purchase that new service for your existing Office 365 tenant.
  • Getting Started With Android And KotlinSep 21, 2017. It is a new programming language for modern multiplatform applications. It was developed by JetBrains and open source contributors .The first version of Kotlin v1.0 was released on February 15, 2016 and latest version of Kotlin is 1.1.4 which was released on August 15, 2017 .
  • 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.
  • What Is New In iOS 11?Sep 19, 2017. iOS 11 sets a new standard for the world’s most advanced mobile operating system. Your apps can now become more intelligent using the power of machine learning with Core ML. You can create incredible augmented reality experiences with ARKit. And you can deliver a more unified and immersive user experience with new multitasking features, including drag and drop for iPad, the new Files app, new camera APIs, new SiriKit domains, Apple Music integration, and more
  • 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.
  • 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.
  • Start The App In Windows Startup In UWP (Windows 10 Fall Creators Update Features)Sep 17, 2017. A long-awaited feature (other features are LaunchApp, Restart App) has come to Universal Windows Programming i.e. we can run our application on Windows startup (User log in to the system), Previously we had done some workaround to run the app in windows startup, now it's time to say good bye to the workaround.
  • Razor Pages In ASP.NET CoreSep 17, 2017. Razor Pages is a new feature of ASP.Net Core MVC. We can use this approach when there are some page focused scenarios.
  • File Upload With JQuery Progress Bar In ASP MVCSep 14, 2017. First we have to create an Asp Mvc project in visual studio. To do that, Open Visual Studio -> New Project -> A new dialog window will appear -> In left pane select C# ->select Web -> Select "ASP.NET MVC 4 Application" name your project and click ok.
  • Create Immutable Type In C#Sep 14, 2017. A public constructor that accepts initialization data is required so that the client can pass-in minimum state for the type to be valid. Private constructor, on the other hand, is used by methods to construct a new object and set its entire state.
  • 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.
  • 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.
  • 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.
  • Seven Reasons Why Swift Is A Must For iOS App DevelopmentSep 13, 2017. With the launch of several programming languages, a developer is often confused as to which technology to use. They are have the dilemma of choosing between Objective C and Swift, both of which are considered to be fine technologies for IOS app development. Recently in an event, Apple unveiled Swift as its new programming language and thereby created a new demand for Swift developers required for quality IOS development.
  • 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.
  • GitHub Extension In Visual Studio 2017Sep 13, 2017. In this article, I will explore the GitHub Extension for Visual Studio 2017. GitHub is a web-based graphical interface Git or version control repository that mostly used for code. It provides for each project access control and several collaboration features like bug tracking, feature requests, task management, and wikis.
  • 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.
  • 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.
  • Launch UWP App Via CommandLine ( Windows 10 Fall Creators Update Features )Sep 07, 2017. We can launch Win32 application via command line arguments. Let's see how to implement this feature into our UWP application.
  • Visual Studio Team Service - Trigger A Build Using Any HTTP ClientSep 07, 2017. In this post, we are going to see how easily we can trigger a new build in VSTS from any of our widely used HTTP clients likeFfiddler or Postman.
  • 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.
  • Automation Of SharePoint Search Crawl Using PowerShell Scripts - Part OneSep 07, 2017. In this article series, you will learn how to create a new content source in SharePoint Search and automate the Crawl using PowerShell scripts.
  • New Features In ASP.NET Core 2.0Sep 07, 2017. ASP.NET core is a significant redesign of ASP.NET. It is an open source, cross platform framework for developing cloud based applications like web applications, IoT applications, and mobile backend applications.
  • 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.
  • 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.
  • Advantages Of SharePoint 2016 From A User PerspectiveSep 06, 2017. You might have seen many articles/blogs on the internet about new and deprecated features of SharePoint 2016 or about the comparison between SharePoint 2013 and 2016. However, this article is mainly focused on the new changes introduced in SharePoint 2016, which will help the end users or business users in their day-to-day SharePoint usage.
  • ASP.NET Core 2.0 Empty ProjectSep 06, 2017. In this article, we will create an empty ASP.NET Core project that doesn’t include default features, i.e., an empty shell.
  • 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.
  • Construct Readable XML Output From SQL Query From Two Or More Tables Using “For XML PATH” StatementSep 04, 2017. In my previous article I discussed about how to get a XML format output from query and process that by using XML AUTO statement, and I give different types of “for XML”.
  • Connecting To MySql Database In StrapiSep 04, 2017. This article helps you to create a connection to the My SQL database using the Strapi; this is an article for the beginners where the basic connection can be created with the existing MySQL database.
  • 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.
  • Learn About Azure Cognitive ServicesSep 01, 2017. Microsoft Cognitive Services (earlier known as Project Oxford) provides us the ability to build intelligent applications, just by writing a few lines of code. These applications or services are deployed on major platforms like Windows, iOS, and Android. All the APIs are based on machine learning APIs and enable developers to easily add intelligent features – such as emotion and video detection; facial, speech and vision recognition; and speech and language understanding – into their applications.
  • 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.
  • Custom Left Navigation In SharePoint 2013Sep 01, 2017. In this article, I explore how to create a custom left navigation using Out of Box, without custom development. As we know that there are a lot of ways of creating left navigation, here you will see a new approach for creating a custom left navigation in SharePoint 2013.
  • 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.
  • Manage Paths Of Web Applications In SharePoint 2016 Central AdministrationAug 29, 2017. Here, you can include a new path to your web application or insert it through explicit or wildcard entries. This helps you to decide what will be the path of creating websites in the site collection.
  • IoT Remote Access Pi Login Using Raspberry PI 3 Model BAug 29, 2017. This is an introduction of Raspberry Pi 3 Model B. We will explore what Raspberry Pi 3 has to offer in terms of its features and performance.
  • Manage Features On Web Applications In SharePoint 2016 Central AdministrationAug 28, 2017. These features, when activated or deactivated on the Web Application, will reflect on all the site collections and sites.
  • New in Machine Learning - An Intent Based Network ManagementAug 28, 2017. Implementation and application of Machine Learning are growing rapidly across different industries. The next big thing is Intent-Based Network or IBN.
  • 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.
  • More Details About Razor Pages In ASP.NET Core 2.0Aug 27, 2017. I built a simple web app to show you the new feature named Razor Pages in ASP.NET Core 2.0 . However it doesn't contain some useful and basic functions. So I decided to write one more article to show more details of Razor Pages.
  • 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.
  • Expected New Features In C# 8Aug 25, 2017. C# 8, C#, C# 8.0
  • 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.
  • Getting Started With .NET Core 2.0Aug 24, 2017. Microsoft just announced the next version of its open source software development framework, .NET Core. The new version i.e., .NET Core 2.0, is a much improved and mature version compared to its predecessor, 1.0.
  • What's New In Android OreoAug 24, 2017. Android 8.0 Oreo was officially released on August 21, 2017. In this article, I am going to discuss some of the new features of Android 8.0.
  • Understand Azure Cosmos DB - DocumentDB API (SQL)Aug 24, 2017. Azure Cosmos DB is Microsoft’s globally-distributed, multi-model database service "for managing data at planet-scale." It builds upon and extends the earlier Azure DocumentDB, which was released in 2014. It is schema-less and generally classified as a NoSQL database. In this article I am going to create an Azure Cosmos DB using SQL.
  • Virtual Machine Scale SetAug 23, 2017. 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.
  • Building A Simple Web App Using Razor PagesAug 23, 2017. In this article , you will learn how to build a simple CRUD web app using Razor Pages , which is new in ASP.NET Core 2.0. This web app is about the management of the students , and all operations of the database will be through API building by NancyFx.
  • Azure Cloud - A Close LookAug 22, 2017. Every two or three years, a new technology comes along which carries the potential to change the world, and “Cloud Computing” is the one. However, there are numerous terms and definitions floating around in the industry for “the cloud”, “cloud computing”, “cloud services”, etc.
  • 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.
  • 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.
  • 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.
  • Work With Configuration In ASP.NET CoreAug 21, 2017. Before going into the new configuration system, let’s discuss in brief how we used to have a configuration system in the earlier versions of .NET applications.
  • 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.
  • Mission Impossible - Migrating .NET Core 1.x To 2.0Aug 20, 2017. Everybody is praising the new edition of .NET Core framework, and everybody is so interested in publishing new articles on .NET Core, and ASP.NET Core or the Entity Framework Core. Yeah, I get that, but... what about migration from older editions? I personally have had a very tough time with the migration of my ASP.NET Core 1.1 application to ASP.NET Core 2.0 application.
  • Resources In Xamarin.AndroidAug 17, 2017. When a new Android project is created, there are some files that are added to the project, by default. We call these default project files and folders as Android Resources.
  • What Is New In .NET Core 2.0Aug 16, 2017. Learn what is new in .NET Core 2.0
  • 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.
  • What Is New In ASP.NET Core 2.0Aug 15, 2017. What Is New In ASP.NET Core 2.0
  • 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.
  • 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
  • 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 A Flow To Get New Posts From Microsoft Flow Official Blog AutomaticallyAug 09, 2017. Today, we are going to create a simple flow using Microsoft Flow to get new posts from Microsoft Flow Official Blog automatically, so we can be updated and notified when something new shows up.
  • 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.
  • 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 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.
  • 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.
  • 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.
  • 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.
  • What Is Bitcoin CashAug 03, 2017. Yesterday, Crypto currency industry got a surprise when some of the Bitcoin industry leaders announced a new crypto currency forked off original Bitcoin, called Bitcoin Cash.
  • 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.
  • 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.
  • 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.
  • 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.
  • 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.
  • 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.
  • 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.

About SQL-Server-new-feature

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!