C# Corner

Resources  
  • Database First In .Net Core 2.0 CRUD Operation - Part OneJan 17, 2018. In my previous post, I have explained how to create an Angular 5 application in Visual Studio 2017 using .NET Core templates which you can find here.
  • 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.
  • 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.
  • 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.
  • 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.
  • C# 7.2 - "In" Parameter Method Overloading TiebreakerJan 14, 2018. This article explains the “in” parameter method overloading with Visual Studio 2017 Version 15.6. Preview 2.
  • Google Chart With ASP.NET Core And Visual Studio CodeJan 13, 2018. The Google Chart API lets you dynamically generate charts with a URL string and embed these charts on a web page, or download the image for local or offline use. The Google Chart Tools enable adding live charts to any web page. They provide advantages such as a rich gallery of visualizations provided as image charts and interactive charts and they can read live data from a variety of data sources. Users embed the data and formatting parameters in an HTTP request, and Google returns a PNG image of the chart. Many types of chart are supported, and by making the request into an image tag the chart can be included in a web page.
  • How To Install TypeScript Plug-in In Visual Studio 2015Jan 13, 2018. In this article, we will see the simple step by step process to install TypeScript Plugin for Visual Studio.
  • How To Control An LED Using Raspberry Pi 3, Windows IoT Core, And Visual Studio UWPJan 13, 2018. This is an introduction to Raspberry Pi 3 Model B. We will explore what Raspberry Pi 3 has to offer in terms of its features and performance.
  • Create Your First Bot Using Visual Studio 2017 - Step By Step GuideJan 11, 2018. Seeing how fast the companies are adopting the Bots, it is really the best time for you to start learning Bot framework and start adopting Bots for your business.
  • 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.
  • Using Bitbucket Extensions With Visual Studio 2015Jan 10, 2018. In this article we are going to learn how to use Bitbucket Extensions with Visual Studio 2015, in the previous article we have learned how to create Bitbucket account and new repositories and push repositories to remote Bitbucket account but in that it was all manual process, but if we get little automation in it that we are going to love it right, in this part we are going to add Bitbucket Extensions to project from visual studio “Extensions and Updates” and work little faster.
  • Draggable Panel In An Android ApplicationJan 10, 2018. This article demonstrates how to create a draggable panel in an Android application using Android Studio.
  • 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.
  • State Management In ASP.NET MVCJan 08, 2018. HTTP is a stateless protocol. Each HTTP request does not know about the previous request. If you are redirecting from one page to other pages, then you have to maintain or persist your data so that you can access it further. To do this, there were many techniques available in Asp.Net like ViewState, SessionState, ApplicationState etc.
  • 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.
  • 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.
  • 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".
  • Create Angular 5 Application Using .Net Core 2.0 Template In Visual Studio 2017Jan 04, 2018. Angular 5 has been announced recently and we already have a template added in the Visual Studio 2017 with .Net Core 2.0.
  • FILESTREAM Feature In SQL ServerJan 04, 2018. Today I am explaining what FILESTREAM is and how to use FILESTREAM in SQL server.
  • 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.
  • Exploring Angular Fundamental With Visual Studio 2017Jan 02, 2018. This article explains the fundamentals of Angular by creating a simple Angular application with Visual Studio 2017 using the default template available with .NET Core.
  • Device Year Class Library Using Android ApplicationJan 02, 2018. Android device's specifications and calculates which year the device would be considered.
  • Using Bitbucket With Visual Studio 2015Jan 02, 2018. In this article, we are going to learn how to use Bitbucket version control system with Visual Studio 2015.
  • Optical Character Recognition Using Google Vision API On AndroidJan 02, 2018. In this tutorial, we will learn how to do Optical Character Recognition in Android using Vision API. Here, we will just import the Google Vision API Library with Android Studio and implement the OCR for retrieving text from image.
  • Integrate Angular 5 With Visual Studio 2017Jan 02, 2018. If installation file finds any open Visual Studio instances it will stop the installation and ask us to click on “EndTask”, by clicking , it will close the all the instances of Visual Studio.
  • 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.
  • 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.
  • Xamarin.Forms - Expandable ListView AppJan 01, 2018. In this article, we will discuss how to create an expandable listview in Xamarin.Forms application using Visual Studio 2017.
  • C# 8.0 - Experimenting With Non-Nullable Reference Type Using Visual Studio 2017Dec 28, 2017. Nullable Reference Type is one of the most popular upcoming features of C# which may be released with C# 8.0. However, C# 8.0 has not been released yet; development is going on so till the final release, its behavior may be a little bit different than the current behavior explained in this article.
  • 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.
  • Build Or Set Up Your First Angular App With Visual Studio CodeDec 27, 2017. In this article, we will learn how to set up an environment for building the first Angular app (with Visual Studio Code).
  • 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.
  • 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.
  • 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.
  • 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.
  • Continuous Integration And Delivery With Visual Studio App CenterDec 22, 2017. Continuous integration and delivery with Visual Studio App Center
  • 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.
  • How To Create An Azure Function App Using Visual Studio 2017Dec 21, 2017. In this article, we will learn how to create an Azure Functions App using Visual Studio 2017.
  • 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.
  • 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.
  • Xamarin.Forms - Bottom NavigationBarDec 20, 2017. In this article, you will learn how to create a Bottom NavigationBar in Xamarin.Forms.
  • Get Started With DevOps With VSTSDec 19, 2017. Zero to DevOps with Visual Studio Team Services.
  • 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
  • Floating Chat Heads Using Android ApplicationDec 19, 2017. We all love the chat head or chat bubbles from the popular Facebook Messanger. This provides very handy and easy access to the chat conversation screen no matter which screen you are on. Chat heads are very convenient for multitasking, as a user can work and chat at the same time. That means if you are using the calculator app on your phone and if any new message arrives, you can open the conversation and replay the message without switching app.
  • 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.
  • Create First Project In VSTS And Clone It Using Tortoise GITDec 18, 2017. In this article, we will learn how we can create a new project in VSTS. Also, we will learn how we can clone that project in our windows system. Once the project has been cloned we will push our files to a VSTS. At last we will talk about Dashboards in VSTS.
  • 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.
  • Understanding LIQUi|>Dec 14, 2017. Understand what LIQUi|> is all about and how it works as a part of Visual Studio.
  • Xamarin.Forms - Messaging AppDec 14, 2017. In this article, we are going to learn about messaging plugin and discuss how to use it in xamarin.forms application by using visual studio 2017 15.5
  • 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.
  • Xamarin.Forms - WebView With ProgressBarDec 13, 2017. In this article, we will learn how to use ProgressBar in WebView in Xamarin.Forms application using Visual Studio 17 15.5 preview.
  • 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.
  • Getting Started With Azure Machine Learning Studio And Azure StorageDec 13, 2017. This write-up is a continuation of my previous one by which we will be sketching across how to get started with Azure Machine Learning and an introduction to Azure Storage.
  • Setup Angular Environment On Visual Studio 2017Dec 12, 2017. Many new JS frameworks are introduced every day. But only some of the frameworks get popular. In this list Angular JS is the most popular one. The Angular Framework team is updating it to get more sophisticated and powerful.
  • Circular Fillable Loader And SeekBar Using Android ApplicationDec 11, 2017. This article demonstrates how to create circular fill loader to an android application using Android studio. This is an Android project allowing to realize a beautiful circular fillable loader to be used for splashscreen.
  • Google Vision API Demo - BarCode Reader Using Android StudioDec 11, 2017. This article is about how we use Vision API in Android Studio.
  • 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.
  • Xamarin.Forms - Multilingual AppDec 10, 2017. In this article, we are going to learn how to create a multi-language application using Visual Studio 2017 15.5
  • Roles And Responsibilities Of SQL Developer Dec 09, 2017. In this article, I have shared the Roles and Responsibilities of a SQL Developer.
  • Introduction To Format Specifiers In Visual Studio DebuggerDec 08, 2017. That is going to be tedious work if we need to keep evaluating the expressions in a lengthy code. Well, there is a way to avoid that. Using format specifiers (while debugging), you can force the evaluation of the expression.
  • 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.
  • 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.
  • 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.
  • Getting Started With Angular 5 Using Visual Studio CodeDec 07, 2017. In this article, we are going to set up Angular 5 app using Visual Studio Code.
  • 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.
  • Building First Console Application Using Command Prompt In .NET Core 2.0Dec 06, 2017. In this post, we will create our very first console application in .NET Core, and we will see how we can build .NET Core based applications without using any IDE or Visual Studio.
  • 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.
  • Creating Angular 5 App With Visual Studio 2017 - An Easy WayDec 05, 2017. There are multiple ways to create an Angular app with Visual Studio and this article explains one of the easiest and simplest ways to create Angular 5 App with Visual Studio 2017 using a template.
  • Xamarin.Forms - Text AppDec 04, 2017. In this article, we are discuss about how to display text in different styles and font sizes in Xamarin.Forms using Visuaal Studio 2017
  • Xamarin.Forms - Hierarchical Navigation AppDec 02, 2017. In this article, we are discussing how to create a hierarchical navigation application in Xamarin.Forms using Visual Studio 2017
  • PyCharm Vs Visual Studio Code For Python DevelopmentDec 02, 2017. One of the most primary questions in the minds of a development startup, a beginner, is which language to use
  • 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.
  • 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.
  • Xamarin.Forms - Border Shadow Effects Using FrameNov 30, 2017. In this article, you will learn how to use Border Shadow Effects in your controls in Xamarin Forms.
  • 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.
  • 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.
  • Notification Alert Android App Using Android StudioNov 29, 2017. In this article, I will show you how to create a Notification Alert Android App using Android Studio.
  • Angular 5, ASP.NET Core CRUD For Inventory Management Using EF And WEB APINov 29, 2017. In my previous article, I have explained how to get started with Angular5 and ASP.NET Core. Now in this article let's see in depth on how to work with WEB API, EF for performing a CRUD operation for Angular5 and ASP.NET Core application.
  • 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.
  • Xamarin.Forms - BugSweeper AppNov 28, 2017. In this article, we will learn how to create BugSweeper application in Xamarin.Forms using Visual Studio 2017.
  • Progress Bar Android App Using Android StudioNov 28, 2017. In this article, I will show you how to create a Progress bar android App using Android studio. We can display the Android progress bar dialog box to display the status of work being done e.g. downloading file, analyzing status of work etc.
  • Battery Level Android App Using Android StudioNov 27, 2017. In this article, I will show you how to create an Android app that shows Battery Level.
  • Introduction To ngrx In AngularNov 27, 2017. In Angular, ngrx is built on the concept of Redux, a state management container. In ngrx, this state management is achieved by a store.
  • 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
  • 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 Use Xamarin Live Player (Preview) Using Visual Studio 2017 15.4Nov 26, 2017. Learn how to deploy a Xamarin.forms or native application using Xamarin Live Player.
  • Creating A Navigation Android App Using Visual StudioNov 25, 2017. This application will take two user inputs for map -- Latitude and Longitude. Clicking on open in map will open the map that can show you directions from the current location to the given address defined by the two user inputs.
  • 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.
  • Transform Web.Config File While Deploying The Web Application ProjectNov 25, 2017. One of the nice features that supports Visual Studio 2010 and above versions is Web.Config (XDT) transformations.
  • 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.
  • 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.
  • CRUD Operation With ASP.NET Core MVC Using Visual Studio Code And ADO.NETNov 23, 2017. In this article we are going to create a web application using ASP Core MVC with the help of Visual Studio Code and ADO.NET.

About SQL-server-Management-Studio

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!