C# Corner

Resources  
  • Identity Server 4 With ASP.NET Core 2.0Jan 16, 2018. OAuth 2 provides several flows or grant types for various use cases. I personally group them into two categories; flows that require user interaction with authorization server and flows that don’t.
  • Stored Procedures In Azure Cosmos DBJan 16, 2018. There are many performance benefits when executing complex operations like Batching in case of using Stored Procedures. Reason is all these operations get executed closer to data as Stored Procedures are stored at server side.
  • 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.
  • Why Dynamic Query Is BadJan 15, 2018. In this article, we will be talking about Dynamic Query and why it is bad.
  • Learn About Microsoft KaizalaJan 15, 2018. Microsoft Kaizala is a mobile application designed for group communication and work management. It is used to efficiently manage the work or collect data from individuals or large groups, even if they are not part of the organization. It makes easy to connect and co-ordinate work with the field employers, vendors, partners and customer wherever they are.
  • Comparison Of Subquery And JoinsJan 15, 2018. Here, in this article, we are comparing the SQL Join and SQL Subquery.
  • Bulletproof Disposable Types In .NET CoreJan 14, 2018. Whenever I do code review on .NET projects, hands down the number one issue is developers not calling .Dispose() on disposable objects. Ever since .NET was released, I have been preaching how important this is. If not done properly, it’s most likely to create virtual memory issues that will eventually cause the application to stop and possibly freeze server or users’ computer.
  • Create An Intelligent Bot Application Using Microsoft Bot FrameworkJan 12, 2018. In our previous article, we learned how to create and connect a chatbot with Azure Bot Service. But in this article, we are going to create an intelligent Bot Application using Microsoft Bot Framework.
  • FormFlow In Microsoft Bot Framework - Part TwoJan 11, 2018. In this part, we will see some of the advanced stuff that we can use while using FormFlow in real time application while dealing with real business scenarios.
  • How To Take Screenshot Using jQuery And PHPJan 10, 2018. Hello all, today in this article we will learn how to take screenshots using jquery and php. So, basically we will create a webpage and in the webpage we create a button which will take screenshot using the help of library called html2canvas . So once we take the screenshot we will save the screenshot in a json file using the help of jquery, javascript and php. We will be using for jquery and javascript to handel client side request and php to handel server side request. We will also learn about file handling using php.
  • Xamarin.Forms Tools - XAML PreviewersJan 09, 2018. Initially, when Xamarin.Forms were released, the biggest challenge in developing the mobile application was to develop its UI as there were no drag and drop designers available for it like storyboard designer for iOS or Android designer. But, very soon, this issue was solved by many Xamarin previewers launched by several third-party providers and recently by Microsoft also.
  • Introduction TO PowerApps And Creating Template With ItJan 09, 2018. PoweApps is a collection of software services and apps that work together to fundamentally transform and accelerate. It is provided by Microsoft as a service under Office 365 for non-technical users (no coding experience is required) to build business apps. It can be simple and fast.
  • Basic Components In .NET FrameworkJan 09, 2018. A .NET gathering is a standard for segments created with the Microsoft.NET.
  • Add Some Intelligence To Your C# Apps With Microsoft Cognitive ServicesJan 09, 2018. In this article, you will learn how to use Microsoft Cognitive Services from your C# applications.
  • How To Remove And Create User Profile Service Application In SharePointJan 09, 2018. The purpose of this article to is to delete an existing UPA service from the SP server and create the same from scratch. As we know, there are two ways to configure or delete UPA server, Using UI and SharePoint PowerShell. We are going to delete and create UPA using UI.
  • Say Hello To Swift GenericJan 08, 2018. If you have not been introduced to Swift generic yet, then definitely you are missing one of the most beautiful things. In this article, we will try to understand generic in a simple way and we will see how we can beautify our Swift codes with generics.
  • Deploy SharePoint Remote Event Receiver To Microsoft AzureJan 08, 2018. This article will help even a beginner to deploy a SharePoint Remote Event Receiver easily to Microsoft Azure.
  • Desired State Configuration In Microsoft AzureJan 07, 2018. This article describes how one can automate and align deployment of Azure resources effectively.
  • Microsoft Office 2013 UI Design In C# - Visual StudioJan 07, 2018. In this article we will design the UI of Microsoft Office 2013 applications like Word, PowerPoint, Excel etc.
  • 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.
  • Office 365 Modern App DevelopmentJan 06, 2018. Web standard Apps are built using industry proven web Standards such as HTML, JavaScript and REST. Apps are independently scalable which reduces the total cost of ownership. Apps are secured and isolated from SharePoint. These apps can be accessed from any device with a browser.
  • How To Install And Start The Reporting Services SharePoint Service In SharePointJan 05, 2018. In this article, we will learn about "How to Install and Start the Reporting Services SharePoint Service in SharePoint".
  • Azure SQL Intelligence For Database Administrator And DeveloperJan 05, 2018. When interacting with large volumes of data, Azure SQL comes into the picture. SQL Azure is a cloud database service owned by Microsoft, which is based on SQL Server database technology.
  • FormFlow In Microsoft Bot Framework - Part OneJan 04, 2018. In this series we are going to explore a few basic and advanced features of formflow in Microsoft bot framework. In Part 1 we will see what is formflow, and how to implement a basic formflow.
  • FILESTREAM Feature In SQL ServerJan 04, 2018. Today I am explaining what FILESTREAM is and how to use FILESTREAM in SQL server.
  • Azure Pack Vs Azure StackJan 04, 2018. The article describes key differences between Microsoft's two key hybrid cloud strategies, Azure Pack and Azure Stack
  • Azure Stack Architecture In DepthJan 04, 2018. In this article I explain the architecture of Azure Stack in detail, in an easy-to-understand way
  • Working With Azure Storage Explorer In Visual Studio CodeJan 03, 2018. Visual Studio code is an open source source code editor developed by Microsoft which supports all major operating systems like Windows, Linux and Mac OS. It includes support all most all software development activities like debugging, Git control, syntax highlighting, intelligent code completion, snippets, and code refactoring.
  • Leadership Challenge 004 - The Happy Secret To Better Work!!!Jan 03, 2018. Hello my friends and Happy New Year!!! It has been a fun couple of months within Microsoft as a Customer Success Manager, driving adoption across MS solutions (Modern Workplace) within the organization.
  • Intelligent Image Object Detection Bot Using Cognitive Computer Vision APIJan 02, 2018. Microsoft Cognitive services is set of cloud based intelligence APIs for building richer and smarter application development. Cognitive API will be used for searching meta data from Photos and video and emotions, sentiment analysis and authenticating speakers via voice verification.
  • Integrating SharePoint And OneDrive? Check This Post Out!Jan 02, 2018. We all are well aware of the fact that Microsoft has an extensive selection of cloud-based digital storage options. Microsoft SharePoint and Microsoft OneDrive are the two most popular terms buzzing across the globe. Recently, the tech Giant has encouraged its end users to combine OneDrive for business and SharePoint, and here’s why!
  • 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.
  • Host ASP.NET Core On Linux With JexusJan 02, 2018. In this article, you will learn a new and easy way to host your ASP.NET Core project on Linux with Jexus Web Server.
  • How To Connect A Box To Google Drive For Business Using Microsoft FlowDec 30, 2017. This article helps you to learn how to connect a box to Google Drive using Microsoft Flow.
  • Customize SharePoint List Forms Using PowerAppsDec 29, 2017. We are all aware Microsoft announced that there will be no new release for InfoPath and advised us to start using PowerApps instead of InfoPath. The long awaited feature to create custom SharePoint list forms with PowerApps has been released now. This only exists in the SharePoint Modern Experience, so you won’t get this in classic.
  • ASP.NET MVC 5 - Full Calendar jQuery PluginDec 27, 2017. This article is about using Full Calendar jQuery Plugin with ASP.NET MVC5 server side.
  • 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.
  • A Potentially Dangerous Request.form Value Was Detected From The ClientDec 26, 2017. This error can occur in any page, but mostly a client receives this error while entering a new or modified item / product in admin panel of any portal because in admin panel we mostly write html code to fill in blanks, and also to display the product feature in ordered or unordered list.
  • ASP.NET MVC 5 - Buttons In Datatables jQuery PluginDec 26, 2017. Table view is one of the most important and basic forms of presenting data on a web page. However, adding action to each row is equally important simply because action for each row leads to different results. Jquery Datatables plugin is one of the most used plugins, as I have demonstrated its integration in ASP.NET MVC5 - Datables Plugin Server Side Integration in one of my articles.
  • 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.
  • 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.
  • How To Host ASP.NET Core Application on IIS ServerDec 21, 2017. In this article, you will learn how to host ASP.NET Core Application on IIS Server.
  • Create Web API With .NET CoreDec 20, 2017. This article explains the way to create webapi using Asp.net core and Microsoft visual studio core.
  • 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.
  • Understand HTTP.sys Web Server In ASP.NET CoreDec 19, 2017. HTTP.sys is a Windows-based web server for ASP.NET Core. It is an alternative to Kestrel server and it has some features that are not supported by Kestrel.
  • 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
  • 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.
  • Implementing Power BI - Part 1Dec 18, 2017. Power BI is the product of Microsoft. It is used as a tool for developing and creating business analytics. It provides interactive visualizations for creating reports, charts, tables and dashboards.
  • Overview Of Identity In ASP.NET Core 2.0Dec 15, 2017. It is a membership system that allows us to add login functionality to our application. User may create account and login using credential or can use external login provider such as Google, Microsoft Account, Twitter, Facebook etc.
  • 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.
  • Generate Thumbnail From Live URL Of Microsoft Office And PDF file in ASP.NET MVCDec 13, 2017. Recently, I got a chance to create thumbnail images from the live URL. The URLs were not of images but of some DOCX file, some XLSX file, or PDF file. We don’t have any custom library which can directly generate the thumbnail from a live URL. So, here, we will learn how we can customize our code to generate the thumbnail in .NET.
  • Exploring And Managing Azure Resources Using Microsoft Azure Mobile App Dec 13, 2017. Microsoft has introduced Azure mobile app for Android & iPhone azure subscribers to get connected with there own Azure resources 24 by 7. Mobile being human chore partner, app made life easier for developers, entrepreneurs or Admin to manage provisioned azure resources anytime from anywhere. Not only can access & manage, but also can monitor health & status of Azure resources. This helps in quick resolving the issues encountered if any.
  • 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.
  • How To Control SQL Injection In PHPDec 07, 2017. This is an interview question, when a person showcases himself as the FULL Stack developer, it is very important that the developer should have base knowledge on the security aspects of the applications.
  • Audit Made Easy Without Audit Log - Part OneDec 07, 2017. In Microsoft SQL Server, the activity of each of the database table is tracked in the other table and that is called the Audit trail or Audit log of the database table.
  • Graph API Using Android ApplicationDec 07, 2017. This article demonstrates how to add Microsoft Graph API using Android Application to get access token and call Microsoft Graph API or other APIs that require access tokens from Azure Active Directory v2.
  • Creating Server And Host HTML Page Using Node.jsDec 07, 2017. Today my mission is to explain about creating server in Node JS and hosting html pages on this server and accessing it from web browser.
  • Object-Relational Mapper For SQLite3 In Node.jsDec 07, 2017. Node.js is getting more popular day by day and many frameworks and platforms are supporting Node.js for its high-performance web server development. In this post, you will learn the database development in Node.js with the popular ORM library; Sequelize.
  • DropDownList In ASP.NET MVCDec 06, 2017. In this article you will come know how to bind data and get dropdownlist selected value in Asp.Net MVC in Client Side and Server Side.
  • How To Give An Approval When A New Cognito Forms Entry Is Submitted With Microsoft FlowDec 05, 2017. This article helps you to learn how to Give an Approval when a New Cognito Forms entry is submitted using Microsoft Flow.
  • How Email Notification Works In Microsoft PlannerDec 05, 2017. The contents mentioned in this article below describes the current functionality of Microsoft Office 365 Planner and may or may not change in the near future.
  • How To Notify Me When A Cognito Forms Entry Is Submitted With Microsoft FlowDec 04, 2017. This article helps you to learn how to Notify me when a cognito forms entry is submitted using Microsoft Flow
  • Introduction To BotsDec 03, 2017. Introduction to Bots and Bot Framework.
  • Creating An Emotion API On The Azure PortalDec 02, 2017. This article shows how to create the Emotion API on the Azure Portal and access the keys to use the Emotion API in our applications.
  • Building SPA With Angular And ReduxDec 01, 2017. In the current application development era, Single Page Application (SPA) is a great feature to develop modern web based applications. In these SPA applications we tend to move the data level dependency from the server side to browser level as much as possible to improve the application performance. So as much as application level functionality moves to the browser level the amount of the data and way to manage these data is also increased. Modern SPA application frameworks like Angular and React use component based architecture that divides our application into small-small sections. Each component contains its own HTML page, stylesheet and its own state(data). This approach is very efficient because it divides our application into small sections that we can manage very easily and also we can reuse these components in our application.
  • 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.
  • How To Connect Box To OneDrive with Microsoft FlowNov 30, 2017. This article helps you to learn how to Connect Box to OneDrive using Microsoft Flow.
  • Introduction To Microsoft AINov 29, 2017. Introduction to Microsoft AI
  • Getting Started With Kotlin - BasicsNov 29, 2017. Google announced Kotlin as an official language for Android Application development in Google I/O 2017.Kotlin is a statically-typed language, developed by JetBrains and Open source Contributors in the 2011, that runs on JVM(Java Virtual Machine) and is compiled to JavaScript source code. It is very suitable for server-side application development with full compatibility of Java frameworks. You can use multiple frameworks like - Spring, Vert.x, Ktor etc. for web application development.
  • 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.
  • How To Easily Upload Image From Mobile To OneDrive by Flow Button Using Microsoft FlowNov 29, 2017. This article helps you to learn how to Upload image to OneDrive for Business using Microsoft Flow
  • Creating Custom Tag Helpers With ASP.NET Core MVCNov 29, 2017. The tag helper enables us to run server-side code to generate HTML, CSS, Javascript code in Razor view.
  • How To Notify Me About Positive Twitter Posts Using Microsoft FlowNov 28, 2017. This article helps you to learn how to notify me about Positive Twitter posts using Microsoft Flow
  • How To Track Your Work Hours And Work Location Using Microsoft FlowNov 27, 2017. This article helps you to learn how to track your Work Hours and Work Location using Microsoft Flow.
  • Filtering jQuery Data Table Server Side Using MVC And Entity FrameworkNov 27, 2017. This article explains how to work with jquery Datatable on the server side and how to use Search Textbox to do serverside filtering using MVC and Entity Framework
  • Chat Bot With Azure Authentication - Part TwoNov 27, 2017. In the previous part of the article series, we have completed initial setup such as app registration, Azure Active Directory Authentication and saving AccessToken to Bot State Service. In this part of the article, we will implement chat bot which will get the AccessToken from Bot State Service and make Azure service call.
  • How To Build A Kubernetes Cluster On Azure Using KubesprayNov 26, 2017. The concept of sticking our compiled code into containers is becoming quite popular at the moment, and for very good reason. If you develop for the cloud, and don't use containers or similar technology now, then you should really take a look at whats involved. The huge benefits of using containerized infrastructure/deployment are being pushed by the cloud vendors, and also increasingly being recognized by mainstream enterprise as an all round good egg and something worth investing time and resources into embracing. Containers and 'server-less computing' are two technologies that most developers are going to have to embrace in the next short few years.
  • Pug Vs HTMLNov 26, 2017. In the holy wars of "Pug vs HTML", it is really confusing sometimes to realize which one of these to use. The same is true for SQL vs NoSQL, and the similar is true for Java vs Python. Then people think why not talk about Pug vs HTML as well. HTML is always the perfect language to consider, however for the case of Pug there might be a bit of confusion. Some developers don't know Pug, and some who know it, know it as a Jade framework.
  • 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.
  • How To Change Your Facebook Post In One Language To Repost In Another Language Using Microsoft FlowNov 25, 2017. This article helps you to learn how to change your Facebook post in one language to repost in another language using Microsoft Flow
  • 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.
  • How To Save Wunderlist Tasks To OneNote Pages Using Microsoft FlowNov 24, 2017. This article helps you to learn how to save Wunderlist tasks to OneNote pages whenever a new task is added on Wunderlist using Microsoft Flow.
  • Building Intelligent C# Corner FAQ Bot Using QnA Maker And Azure Bot ServiceNov 24, 2017. In this article, we will be learning as how to create or build an intelligent Azure Bot using Microsoft QnA maker and Azure Bot service. Also, we will be deploying this Bot to application live. For novice Cloud developers, aspiring Cloud architects, Pre-sales consultants and all other IT professionals associated with the Cloud computing, especially with Microsoft Azure and Artificial Intelligence, this article will explain the capabilities of Microsoft Bot service and Microsoft cognitive QnA Maker.
  • Sending An Event To The Event Hub Using Microsoft Visual StudioNov 24, 2017. This article demonstrates how to send the events to the Event hub using the Visual Studio.
  • How To Generate Audio For My Facebook Post Using Microsoft FlowNov 23, 2017. This article helps you to learn how to Generate Audio for a Facebook post by creating flow between Facebook and OneDrive.
  • Introduction To Suave With F#Nov 23, 2017. In this article, we will see how to construct a simple web application with the F# language and the Suave web server on Visual Studio Code.
  • Creating An Azure Storage In Microsoft AzureNov 22, 2017. This article shows how to create an Azure storage in the Azure portal and also performing some basic operations like creating Storage accounts and containers and managing the access keys in it.
  • How To Track Facebook Wall Messages In An Excel Table Using Microsoft FlowNov 22, 2017. Microsoft Flow is a cloud-based service. It allows us to react to an event in one and do something with the data from that event into another service. It makes it practical and simple for line-of-business. The users can build workflows that automatically do some business tasks and processes across applications and services.
  • How To Notify A User Of Newly Submitted Microsoft Forms Response Via EmailNov 22, 2017. This article helps you to learn how to send an email when a new response is submitted in Microsoft Forms, using Microsoft Flow.
  • Implementation Of Face API Using Microsoft Azure And Visual StudioNov 22, 2017. This article shows how to create the Face API using Microsft Azure and Visual Studio,
  • Use SQL Server 2017 in Docker ContainersNov 21, 2017. How to use SQL Server 2017 on Docker containers to automate deployment using VSTS
  • Creating A Standalone Automation Account In Azure PortalNov 21, 2017. Microsoft Azure Automation supports a path for the users to automate the manual, long-processing, error tracking and is mostly needed for the continuous repeated process in the cloud and in many companies.Then automation saves the time and increases the reliability of the regular administrative works and it also schedules them to be automatically performed at regular intervals.The Automation can be taken with the help of Runbook.
  • 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.
  • 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.
  • Chat Bot With Azure Authentication - Part OneNov 19, 2017. This article will teach you some tips and techniques about Azure
  • Dynamic Checkbox Functionality Using Angular In ASP.NET MVCNov 17, 2017. Checkboxes in AngularJS and asp.net MVC (server-side) application.
  • Using Custom Document Template And Quick Parts To Get Column Values From SharePointNov 17, 2017. Quite often there is situation when user wants to save documents with metadata in SharePoint library and to accomplish this we can use document template, customize it and by using Quick parts in Microsoft office we can save Meta data in library and in Microsoft office documents.

About Microsoft-SQL-Server-2008

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!