C# Corner

Resources  
  • Publish Nuget Packages In .NET CoreJan 19, 2018. Now that you have a registry and key to upload your packages, let’s create and push a package. I am using here a simple .NET Core class library I wrote to work with CSV files, the source code can be found on GitHub. You can of course use any of your projects.
  • CRUD Operations In SharePoint Using REST API - CREATE OperationsJan 18, 2018. REST API is a powerful CSOM concept that can be leveraged in SharePoint for converting sophisticated business designs into working and efficient SharePoint Artifacts (Add-Ins, CSOM solutions, etc.). REST does not require any separate references for its working unlike other frameworks (SPservices!)
  • SharePoint Online Automation - Checking Site Quota For SharePoint Online TenantJan 16, 2018. Today, I am writing about SharePoint Online Automation script for checking the site quota.
  • Basics Of Angular And Its Versions - Part ThreeJan 16, 2018. In this article, I am going to explain more on one of the 8 main building blocks, that is, Services.
  • Why Dynamic Query Is BadJan 15, 2018. In this article, we will be talking about Dynamic Query and why it is bad.
  • Comparison Of Subquery And JoinsJan 15, 2018. Here, in this article, we are comparing the SQL Join and SQL Subquery.
  • An Introduction To Q#Jan 15, 2018. In this article, I will be explaining about Q# - the new programming language introduced by Microsoft for quantum computing. We will understand the data type, expressions, and statements of Q# with the help of code snippets.
  • Create Site Collection In SharePoint Online Using PowerShellJan 13, 2018. In my last article, I have demonstrated about how to create Site Collection in SharePoint Online Using GUI, today I am demonstrating “Create Site Collection in SharePoint Online Using PowerShell”.
  • 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.
  • 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.
  • 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".
  • FILESTREAM Feature In SQL ServerJan 04, 2018. Today I am explaining what FILESTREAM is and how to use FILESTREAM in SQL server.
  • Steps To Configure A VPNJan 04, 2018. In this article I am going to show you the steps to configure a VPN.
  • 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.
  • ASP.NET Core 2.0 Cookie AuthenticationJan 02, 2018. Cookie Authentication allows developers to hook into events at various lifecycle stages of the authentication process. For instance you could log successful sign-ins using OnSignedIn or use OnValidatePrincipal (runs on every request) to invalidate the user (e.g. if you want to force sign-out).
  • CRUD Operations With ASP.NET Core Using Angular 5 And ADO.NETJan 02, 2018. Here, I am going to explain how to create an MVC web application in ASP.NET Core 2.0 with Angular 5.
  • Setting Up Add-In Development Environment In SharePoint Server 2016Dec 26, 2017. In this article, I have explained how to configure Sharepoint add-ins development environment and create a simple hello world web part in s=Sharepoint server 2016 on-premises.
  • Linking Android-Kotlin Application With Google Play Store For RatingDec 26, 2017. In this article, I am going to illustrate how a developer can link their app with Google Play store so that a user can navigate to the play store to rate applications by clicking on a particular button or image.
  • 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.
  • OOP Implementation In KotlinDec 22, 2017. Like other OOP languages, we can implement all the features of OOP in Kotlin. In this article, I am going to implement all features.
  • Some Useful JavaScript Methods, Variable And Objects In Sharepoint 2013Dec 21, 2017. In my previous blog, I explored _spPageContextInfo variable properties. This time, I am exploring some SharePoint-provided useful methods and objects in JavaScript.
  • 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.
  • Weather Updates In Console Application Using APIDec 20, 2017. Here, I am writing an article to give a basic idea of consuming a Web API from Yahoo Weather and display it in the Console.
  • Add Email Authentication To Xamarin.Android App Using Firebase - Part TwoDec 19, 2017. Today, I am going to show you how to add Email authentication in Android using FireBase.
  • 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.
  • 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
  • MVC Angular CRUD Operation Using WEB API 2 With Stored ProcedureDec 18, 2017. In this article, I am going to explain how to do CRUD Operation in Asp.Net MVC AngularJS Using WEB API 2 With Stored Procedure.
  • 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.
  • 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.
  • 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.
  • Add Email Authentication To Xamarin.Android App Using Firebase - Part OneDec 18, 2017. Today, I am going to show you how to add Email authentication in Android using FireBase.
  • MySQL Data Access API Development Using Express.JS, Node.JSDec 14, 2017. In this article, we are looking into introduction of Node.JS, Express.JS and then I am going to create Simple MySQL data access API using Express.JS, Node.JS.
  • 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.
  • An Introduction To Quantum ComputingDec 13, 2017. In this article, I am going to cover some of the basics of Quantum computing and also set up an environment on our local machine with Visual Studio 2017 to get started with Quantum programming.
  • Code Reusability In KotlinDec 12, 2017. In this article, I am explaining how you can reuse your existing code of Kotlin using Inheritance with examples and diagram.
  • 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.
  • Xamarin.Android - Upload An Image To Firebase StorageDec 08, 2017. Today, I am going to show you how to upload an image to Firebase storage and then show that uploaded image in Firebase Storage.
  • 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.
  • 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.
  • AppIntro Library Using Android ApplicationDec 05, 2017. In this article I am creating a simple app that contains few intro slides with next and skip navigation.The user can navigate through each slide using swipe gesture or using the next button.
  • NodeJS - Getting Started With Some Basic FunctionsDec 02, 2017. Today, I am explaining about getting started with NodeJS. Node.js is a powerful JavaScript-based framework/platform built on Google Chrome's JavaScript Engine.
  • Tips And Best Practices To Improve ASP.NET Web Application PerformanceDec 01, 2017. This article suggests you a few tips to improve the performance of an ASP.Net application. There are many more things which may ensure a better performance and faster response time for a web application. I am discussing only a few of the best practices that will help you avoid some unwanted performance hitters from your application. So, you will have a more light weight application which runs quicker and gives a better response time.
  • CRUD Operations On A SharePoint List Using REST APINov 29, 2017. In this article, I am going to explain how to perform CRUD (Create, Read, Update, Delete) operations on a SharePoint list using REST API.
  • 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.
  • 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.
  • How To Create A Stored Procedure In SQL Server Management StudioNov 25, 2017. In this article you will learn about how to create store procedure in sql server’s SQL SERVER MANAGEMENT STUDIO and very informative information and interview questions and answers about store procedure.
  • Creating An Event Hub On The Azure PortalNov 24, 2017. In this article, I am going to describe and demonstrate the creation of Event Hubs on the Azure Portal.These Event Hubs are used to act as a port to collect the streaming data and processing of that data per second.
  • Introduction To SSISNov 24, 2017. SSIS stands for SQL Server Integration Services. It is one of the services of SQL Server and was introduced for the first time in SQL Server 2005. It’s a powerful replacement for the legacy DTS (Data Transformation Services) that exists in SQL Server 2000.
  • Use SQL Server 2017 in Docker ContainersNov 21, 2017. How to use SQL Server 2017 on Docker containers to automate deployment using VSTS
  • Implement DropDown MultiSelect Using Kendo UI MultiSelect In ASP.NET MVC5Nov 21, 2017. In this article, I am going to explain how to bind the value to a dropdown from the database, how to implement drop-down multi-select, how to group the drop-down values, and how to implement Custom Template using Kendo UI MultiSelect in ASP.Net MVC5.
  • Creating A Data Science Virtual Machine(DSVM) For Linux In The Azure PortalNov 21, 2017. In this article, I am going to demonstrate how to create the Data Science Virtual Machine for Linux on the Azure Portal and connect the DSVM to visualize the VM using X2Go Client Software.
  • Creating A SQL Database And SQL Server On The Azure PortalNov 20, 2017. This article shows how to create a SQL Database and Server on the Azure Portal and also the process of configuring the threat protection to our Database.
  • Introduction To SQL Operations Studio And Connecting It With SQL ServerNov 20, 2017. Learn how to use SQL Operations Studio (preview) to connect to SQL Server, and then use Transact-SQL (T-SQL) statements.
  • Interviewing - Have An Awesome Resume AvailableNov 19, 2017. It is very important to keep your resume up to date. I update my resume at least every quarter. I also update it when I am done with a project worthy of putting what I did in my resume. Remember to also update your LinkedIn profile whenever you update your resume.
  • Automation Configuration Using JenkinsNov 18, 2017. In this article, I am going to show you the automation configuration using Jenkins.
  • Auto Complete with ngTagInput using Web API in AngularJSNov 16, 2017. AutoComplete,ngTagInput,Web API,AngularJS,AutoComplete in AngularJS using Web API
  • Always Encrypted In SQL Server 2016 - Step By Step Guide - Part ThreeNov 15, 2017. This is part three of "Always Encrypted In SQL Server 2016 - Step By Step Guide" series. In this article, we are going to see how to search on encrypted column and how to deploy a certificate to a different environment.
  • What Is SQL Operations StudioNov 15, 2017. Learn and download SQL Operations Studio
  • What Is New And How To Set Up Our First Angular 5 ApplicationNov 15, 2017. Here, in this post, I am going to discuss a few updates in Angular 5. By saying that, I will not be discussing all the items which have been released with this version. Here, we will also be checking how to create our first Angular 5 application. So by the end of this article, you will have your own sample application with you.
  • Comment Or Reply To A Post In SharePoint Using AngularNov 15, 2017. Nowadays commenting or replying to a post is the most common thing in all social networks. Hence, in this article I am going to explain how it works in SharePoint using AngularJS. By the help of this article you will learn how to set comment or reply feature to a post in SharePoint using AngularJS.
  • MVC : Display Image From Byte ArrayNov 14, 2017. In this tutorial, I am going to explain how to display image from a byte array in ASP.NET MVC using C# .NET and VB.NET.
  • How To Use StringBuilder And File Class For .NET ApplicationNov 14, 2017. Here, I am going to share how and why should we create error log in our application.
  • SSMS 2016 - Enhanced ScrollbarNov 14, 2017. Detailed description with screenshots of the enhanced scroll bar introduced in SSMS (SQL Server Management Studio) 2016.
  • DROP IF EXISTS In SQL Server 2016Nov 13, 2017. With this very small but handy tip, we’ll check the enhancement that has been made to DROP statement in SQL Server 2016. Earlier, we used to write additional checking logic to make sure that the object exists to drop. If we miss writing the check and if the object is not available, then we are being served with an error message. With SQL Server 2016, now we can check the existence of the respective object without any error being generated.
  • Server Side Custom Paging In Angular-UI Grid Using Web APINov 13, 2017. In this article, you will learn how to implement server side custom paging using Angular UI-Grid with Web API and SQL Server database and stored procedure. In this article, I will demonstrate server side paging and sorting only, Filtering we should learn in next article.
  • Introduction To Power BI Visuals - Part Three (Clustered Column Chart And Clustered Column Chart)Nov 11, 2017. Here, I am writing the introduction series for all Power BI visuals so the end user or beginner will gain a basic idea of how visuals work During this series of Power BI visuals, we will learn about each OOTB Power BI visuals step by step. In this article we will talk about below two visuals provided by Power BI Desktop OOTB. 1. Clustered Bar Chart 2. Clustered Column Chart
  • Introduction Of New Useful Features In SSMS 2016Nov 10, 2017. This article is an effort to list out a few exciting improvements that have been made to SQL Server Management Studio 2016. I believe, most of these new features can help improve the speed of our work and are more convenient to use the SSMS.
  • Masking Sensitive Data With SQL Server 2016Nov 10, 2017. SQL Server 2016 has many features which you can use to make your data and application more secure, more maintained and easily retrieved as per your requirements. It has introduced both client side security such as Always Encrypted as well as server side security such as Data masking etc. In this post we’ll examine how Dynamic Data Masking can help secure our data.
  • Azure Data Factory - ETL Solution To Azure DB And To Azure SQL Data WarehouseNov 09, 2017. In this article we will learn how to use Azure Data Factory to Extract, Transform, Load (ETL) data especially for the data warehousing purposes.
  • Configuring SQL Server 2016 Express On LAN For C# Connection StringNov 08, 2017. In this article I will share my experience about configuring SQL Server 2016 Express on LAN for SQL connection using my C# application’s connection string
  • Power BI And Excel File As Data SourceNov 06, 2017. Though we have several options for data sources to connect with Power BI in this blog, I am going to write about how we can use Excel data with Power BI and how to refresh the report when Excel data is changed.
  • Step By Step Guide To Setup Sample SSAS Multi Dimension CubeNov 06, 2017. Create one Windows account and give full access to that account to read OLTP database or add an account on which SSAS Service is running and give full permission to that account for OLTP Database.
  • Power BI On-Premises Server Installation And ConfigurationNov 06, 2017. On October 31, 2017 Microsoft released the latest version of Power BI report server, in this version on-premises reports can connect to different data sources (SQL Server, Oracle, SAP HANA ...Etc.). Users can also use direct Query option or import data option and create schedule to refresh the imported data. This article will give the step by step process to install and configure a Power BI on premises server.
  • SQL Server 2016 - How To Detect The Current Cumulative Update/Service Pack That Was InstalledNov 05, 2017. In this article, I will explain how to detect the current Cumulative Update / Service Pack installed on your SQL Server.
  • Create An Azure SQL Database Using PowerShellNov 03, 2017. A resource group is a logical container into which Azure resources are deployed and managed as a group. So let's create a resource group for that using New-AzureRmResourceGroup command.
  • How To Create A SQL Database In AzureNov 03, 2017. In this article you will see how to create an Azure SQL Database in the Azure portal. Azure SQL Database is a relational database-as-a-service which provides high performance, reliable and secure database used to build data-driven applications and websites.
  • Using Perfect Scrollbar In Angular v2 And AboveNov 01, 2017. In this article, I am going to show you the usage of perfect-scrollbar using ngx-perfect-scrollbar package.
  • Introduction To Power BI Visuals - Part One - Stacked Bar ChartNov 01, 2017. Here, I am writing Introduction series on all Power BI visual so end user or beginner have a basic idea how visuals are working. During this series of Power BI visuals, we will learn about each OOTB Power BI visuals step by step.
  • Populating A ListView With Data Using Kendo Listview And Entity Framework In ASP.NET MVC 5Oct 31, 2017. Here, I am going to demonstrate how to load the data from a database to Kendo listview in ASP.Net MVC5.
  • Angular 2+ Filter Pipes And Custom Filter PipesOct 30, 2017. In this article, I am going to show you the predefined filter pipe usage as well as show you how we can create our own custom filter pipe and its usage.
  • Building WordPress Theme From Scratch - Part OneOct 30, 2017. Hi all, I am writing a series to create a theme in WordPress with all functionalities like show blog post and add widgets on the front page. I will create this series for absolute beginners who want to improve his skills in php so here you can learn to build your own theme with all those functionalities you want in your own theme.
  • How To Use ServerSide Processing With jQuery DatatableOct 29, 2017. Create one WebService to Getdata(Here I am using asp.net WebService to get data). You can see my Solution Explorer . I have two web pages and one service, and the name of the service is webService.asmx.
  • Useful URL Shortcuts For SharePoint Online - Part TwoOct 29, 2017. In this second part of URL shortcuts, I am going to write some useful URLs which will help developers or administrators perform their daily tasks in a very easy manner. As a developer these shortcuts are very useful to us. These URL shortcuts make our work faster. This article covers eight shortcut URL which we can use in our daily practice.
  • Office 365 Public CDN OverviewOct 27, 2017. Microsoft has recently announced (over a months’ time ago now as I am writing this article) availability of Office 365 Public Content Delivery Network (CDN). This gives us the good option to host the static content such as JavaScript files, CSS, images, documents in CDN. The files in CDN will help better performance with SharePoint pages.
  • Useful URL Shortcuts For SharePoint Online - Part OneOct 26, 2017. In this article, I am going to write some useful URLs which will help developers or administrators perform their daily tasks in a very easy manner.
  • Generate PDF From An HTML Page Using AngularOct 24, 2017. In this article, I am going to explain how to generate PDF file from an HTML page using AngularJS in SharePoint. This is the effortless way to port the SharePoint list data or any other list data to carry, print, and make a hard copy.
  • How To Use jQuery Datatable In AngularOct 24, 2017. In this article I am going to explain how to use and integrate the jQuery datatable with AngularJS. DataTables is a prebuild functionality and a plug-in for the jQuery JavaScript library. It is a highly flexible tool, based upon the foundations of progressive enhancement, and will add advanced interaction controls to any HTML table.
  • Angular 2+ Logger Using ng2.loggerOct 23, 2017. In this article I am going to show you the process to log messages in Angular 2+ applications with examples. Ng2 Logger is a simple logging module for Angular 2+ applications. This allows you to log messages based on the log level setup.
  • How To Return A Pair Of Closest Birthdates Using API, Multi Threading And MVC 5 Using C#.NETOct 18, 2017. This article demonstrates how to use multi-threading to return the name of 2 customers who have the closest birthdate. I also include how create API to add\ retrieve customer details from SQL database using tasks and how to use MVC to call and API to add a new customer.
  • T-SQL - Display Decimal Numbers As MoneyOct 17, 2017. In this article, we will show how to display decimal numbers as money with and without cents
  • Cloud Databases In Azure - Part TwoOct 16, 2017. In the first article of this series, I explained about how to create SQL Database in Azure. I recommend you read the first article.
  • Always Encrypted In SQL Server 2016 - Step By Step Guide - Part TwoOct 14, 2017. This is part two of "Always Encrypted In SQL Server 2016 - Step By Step Guide" series. In this article, we are going to see the sample queries on encrypted columns and Limitations of Always Encrypted feature. In case, if you have missed out the first part of the series.
  • Delete A SharePoint Subsite By Using Angular And Rest APIOct 14, 2017. In this article I am going to explain how to delete a subsite programmatically using Angular js and rest API call.
  • Creating A Dynamic YearPicker Plugin Using JQuery And HTMLOct 14, 2017. We have seen many year pickers that allow you to select years from the dropdown. I have seen a requirement of selecting years from the year picker as we select date from the datepickers. Now I am going to create a dynamic Year picker plugin to select the year using jquery and html
  • User-Defined Types In SQL ServerOct 13, 2017. When we are working with any programming language, we create user defined types as per our requirement. It is a better idea to have this feature in the SQL server.
  • Let's Move 'On-Prem' Data Warehouse To 'Azure SQL Data Warehouse' With Redgate Data Platform Studio (DPS)Oct 13, 2017. In this article we will learn how to migrate ‘On-Prem’ data warehouse to the Cloud, specifically Azure SQL Data warehouse. I will share the lessons learned and some do’s and don’ts from my experience that may be helpful.
  • Getting Started With SharePoint Framework For SharePoint 2016 On-PremisesOct 12, 2017. Once you have installed and upgraded the September 2017 Public Update for SharePoint 2016, you will be able to upload and deploy SharePoint Framework packages that contain web parts via the SharePoint App Catalog just as you would with SharePoint Add-ins.
  • T-SQL - Retrieve Task Hierarchy In Project ServerOct 12, 2017. In this article, we will show how to get the Task Hierarchy for a Specific Project in Project Server Database using SQL

About What-is-DDL-statement-in-sql

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!