C# Corner

Resources  
  • ASP.NET Core - CRUD With React.js And Entity Framework CoreApr 24, 2018. CRUD Operations in ASP.NET Core application using React.js, Web API and Entity Framework Core DB first approach with the help of VS 2017.
  • Hide And Group Columns In SSRS Using A ParameterApr 24, 2018. Ever had users come to you and request another version of a report just to add another field and group data differently? Today, was such the day for me. I really don’t like having multiple versions of the same report out there. So, I got a little fancy with the current version of the report and added a parameter then used expressions to group the data differently and hide columns. For those new to SSRS I've embedded some links to MSDN to help you along the way.
  • Backup And Recovery In Azure Virtual MachinesApr 24, 2018. In this article I am going to brief you about Backup and Recovery in Azure Virtual Machines and also show a step by step demo to set up a Backup Services Vault.
  • SQL Server Updates Tricked Me For YearsApr 24, 2018. When applying a new SQL Server cumulative update, hot fix, or upgrade to SQL Server, it doesn’t always apply all the fixes in the patch. When you upgrade the database engine in-place, databases you already had stay at their pre-upgrade compatibility level, which means they run under the older set of optimizer rules.
  • Creating Simple API In Node.jsApr 22, 2018. In this article, we are going to learn how to create a simple API in node js and using MS SQL as a data source on which we are going to perform CRUD operation.
  • Step-By-Step Demo Of Deploying Azure Resource Manager TemplatesApr 19, 2018. In this article, I am going to show you the step-by-step demo of how you can deploy an Azure Resource Manager template.
  • ASP.NET Web API Using MVC And Entity Framework - Part OneApr 18, 2018. Web API concepts in different fields and Its implementation using Asp.Net MVC and Entity Framework . Web API Controller connects with Sql Server by Entity Framework. Web API Route can be used in different types of clients Like IOTs.
  • Angular 5 - Reactive Forms With Dynamic FormArray And Simple ValidationApr 17, 2018. I am sharing an article on how to dynamically display controls in <em>FormArray</em> using Angular 5 <em>Reactive Forms</em> and enabled/disabled the validators based on the selection.
  • Logic Apps 101 - Inserting Data Into Multiple Tables Using SQL Connector And Trigger(SQL)Apr 17, 2018. In this article, you will learn Logic Apps 101 - Inserting Data Into Multiple Tables Using SQL Connector And Trigger(SQL).
  • Star Rating In Angular 5Apr 16, 2018. In this article, I am going to explain how can we create a Star Rating In Angular 5.
  • Azure SQL Database - Create And Connect SQL Database In The Azure PortalApr 11, 2018. This article explains how to create and connect Azure SQL database to the Azure portal.
  • How To Upload Audio In Database And Play In GridView Using ASP.NETApr 10, 2018. In this article, we are going to discuss how to upload an audio file in our project folder and save its path in SQL server database table.
  • How To Upload Video In Database And Play In GridView Using ASP.NETApr 08, 2018. In this article we are going to learn how to upload video in project folder and save its path in SQL server database table. We will bind that table to gridview and play audio using html5 video element.
  • Learn About Xamarin.Forms PopupApr 08, 2018. I am here with a new post on (Rg.Plugins.Popup).
  • How To Create Temperature Gauge Using Micro - BitApr 02, 2018. In this article, I am going to write about how we can create a simple temperature gauge
  • Learn SharePoint In Series - Part Two - Web ApplicationApr 01, 2018. This article is the second part of Learn SharePoint in Series. You can read the first part here Learn SharePoint In Series-Part One-Introduction. In previous article I have described about the introduction of SharePoint and some basics of SharePoint such as history, choosing between SharePoint and Other technology. So in this article I am moving one more step ahead.
  • How To Read Temperature Using BBC Micro:Bit Mar 31, 2018. In this tutorial, I am going to write about how to read temperature using Micro:Bit.
  • System-Versioned Temporal TablesMar 29, 2018. Every once in a while, I like to take a moment and learn something new about the latest SQL Server gizmos and gadgets. Today I came across system-versioned temporal tables and it piqued my interest, so I figured I’d investigate and share my findings with you.
  • Monitoring Specific Table Using SQL ProfilerMar 27, 2018. This article helps you to understand how to use the SQL Profiler, and how to trace a particular table.
  • MVC CRUD Operations Using Entity FrameworkMar 27, 2018. In this article I am going to talk about MVC CRUD Operations Using Entity Framework 6 without writing any code. First, you should learn about MVC and the basics of Entity Framework.
  • Ref And Out KeyWords - Two Separated TwinsMar 26, 2018. In this article, I am going to explain the concepts of some useful keywords like Ref & Out parameters. These keywords are used along with the data to be passed to a function as parameter. Below I will explain a brief explanation about each of these keywords with an example.
  • VNet Peering With Step By Step DemoMar 25, 2018. In this article, I am going to explain what VNet peering is and how to establish it in Microsoft Azure.
  • What Are These Backup Settings All AboutMar 23, 2018. I ran across a client the other day that had these Backup and Recovery options set like the picture below because it defaults this way.
  • Step-By-Step Demo Of Creating A VNet To VNet Connection In Microsoft AzureMar 23, 2018. In this article, I am going to show you how to create a VNet to VNet connection using Virtual Network Gateways.
  • File Logging And MS SQL Logging Using Serilog With ASP.NET Core 2.0Mar 22, 2018. In this article, you will learn File Logging and MS SQL Logging using Serilog with ASP.NET Core 2.0.
  • Angular @Output() DirectiveMar 22, 2018. In this article we are going to talk about how to send data from child component to parent component using the @Output() directive. For simplicity I am going to use the same code which I have used in my previous article and I will add some more code to explain output directive so in case you missed my previous article then I would recommend you to read that first.
  • Step-By-Step Demo Of Creating A Point-To-Site VPN ConnectionMar 22, 2018. In this article, I am going to show you the demo of how to establish a point to site VPN connection.
  • Let's Import Data To Azure SQL Data Warehouse Using SSISMar 21, 2018. We have already discussed many ways to import data in Azure DWH. Today I will discuss an OLD SCHOOL approach of data import by SQL Server Integration Services (SSIS). In my opinion, this is the most promising way to import data from different data sets/ types like SQL Server, Oracle, MySQL, Flat File, CSV, DB2 .
  • Step-By-Step Demo Of Creating Azure Virtual Network, Subnets And Network Security Groups - Part ThreeMar 21, 2018. In this article, I am going to show you how to create Azure Virtual Machines, Subnets and Network Security Groups.
  • Pre-Deployment And Post-Deployment Script - SQL Database ProjectMar 20, 2018. In this article, we will learn Pre-Deployment And Post-Deployment Script on SQL Database Project.
  • Step-By-Step Demo Of Creating Azure Virtual Network, Subnets And Network Security Groups - Part TwoMar 20, 2018. In this article, I am going to show you how to create Azure Virtual Network, Subnets and Network Security Groups.
  • Keywords - Const, ReadOnly, And Static ReadOnly In C#Mar 20, 2018. In this article, I am going to explain about const, read-only, & static keywords in C#.
  • Step-By-Step Demo Of Creating Azure Virtual Network, Subnets And Network Security Groups - Part OneMar 19, 2018. In this article, I am going to show a step by step demo of how to create Azure Virtual Networks, Subnets and Network Security Groups.
  • Xamarin.Android - Chat Application Using Firebase - Part OneMar 19, 2018. Hello everyone, I am glad that you are here to learn some amazing stuff. In this episode, i shall show you how to make chat application with Firebase on Xamarin Android. This chat application is based on Firebase Auth and Firebase Database by using Xamarin.Firebase plugins.
  • Process Followed In Agile Scrum MethodologyMar 19, 2018. In this article, I am going to share with you the process followed in Agile methodology.
  • Learn About SSMS Output WindowMar 17, 2018. In my experience, there have been occasions where SQL Server Management Studio (SSMS) becomes unresponsive for a length of time. In one particular case, this occurred while I was expanding the list of databases. SSMS just sat there and waited for some unknown reason and became frustrating. The client eventually did respond and life was good again.
  • Hide And Group Columns In SSRS Using A ParameterMar 16, 2018. Ever had users come to you and request another version of a report just to add another field and group data differently? Today, was such the day for me. I really don’t like having multiple versions of the same report out there. So, I got a little fancy with the current version of the report and added a parameter then used expressions to group the data differently and hide columns. For those new to SSRS I've embedded some links to MSDN to help you along the way.
  • WPF - Data Storage Using SQL ServerMar 15, 2018. For any development domain, be it mobile or web or desktop or service-based, data storage is an essential component whether it is done on the server side or the client side. WPF application is a client-side application and it also supports many data storage resources which depend on the business requirement or business choice.
  • Android Kotlin-Variables, Data Types And If-Else, When Statements - Part TwoMar 14, 2018. In this article we will learn variables, constants, and data types as well as If Else and When statements in Kotlin.
  • Cascading Dropdown List By Country, State And City Using MVC, Web API And AngularMar 14, 2018. Today, in this article, I will explain how to perform Cascading dropdown list using MVC, Web API, and AngularJs. Here I am using three tables respectively: Country, State and City.
  • Learn About Some Useful Angular CLI CommandsMar 14, 2018. In this article, I am going to discuss some useful Angular CLI commands.
  • ASP.NET Core - CRUD Using Angular 5 And Entity Framework CoreMar 13, 2018. CRUD Operations in ASP.NET Core application using Angular 5 , Web API and Entity Framework Core DB first approach with the help of VS 2017.
  • No More Dreaded XHR! Fetch API Is HereMar 13, 2018. In this article, I am explaining about JavaScript Fetch API.
  • Four Rules Of Right When Running A QueryMar 13, 2018. Earlier this year, I participated in the Idera #sqlchat. This is a monthly chat meeting that is organized by Idera Software and hosted by a SQL Server community member. This one was hosted by Monica Rathbun (B|T) and her topic for the month was “SQL Server Bad Habits in Configurations, Security, and Code”. It was a fun and entertaining way to spend an hour over lunch. Plus it helps to get you engaged with the SQL Server community, which is never a bad thing.
  • Using SWITCH On A Single PartitionMar 12, 2018. Several months ago, I was looking at a question posted on ask.sqlservercentral.com. I discovered an answer to a question regarding how to move a large amount of data around quickly. The solution was related to an aspect of table partitioning that I was not aware of. If you aren’t familiar with partitions in SQL Server, you can “divide” up a table into different segments or partitions. Often this is found in large tables (think millions/billions of rows) in order to quickly and efficiently move data around. Moving partitions around is a meta-data operation which is what makes it so efficient.
  • How To Insert Bulk Records Into SQL Server Using XML Data TypeMar 11, 2018. Sometimes, there is a need to insert bulk records into a database. In some cases, we have multiple unique records and that all needs to be inserted into the database. Instead of hitting the database for each record, we need to insert bulk records into database.
  • Is Quantum Computing Used In Time Traveling?Mar 07, 2018. In this article, I am going to explain the role of quantum computing in time traveling.
  • React Introduction - Day OneMar 07, 2018. I am going to write a series of articles on React. On the first day of learning, we are going to see the basics of React.
  • O365 Consuming Azure PAAS SQL DB Through BCSMar 03, 2018. This document explains the steps to configure BCS using Office 365 that can pull data from Azure PaaS SQL DB and also to configure firewall IP ranges and network possibilities.
  • Learn MongoDB With Me - Part TwoMar 02, 2018. This is the second article of the series “Learn MongoDB with Me,” and if you haven’t read my previous post on this topic, I strongly recommend you find it here. This is a continuation of exploring the Mongo shells. We will be performing some commands on the Mongo shells. For easy reference I will try to add screenshots for each of the steps I am following. I hope it will help you to come along with me. Thanks for reading.
  • Execute SQL Server Stored Procedure With User Parameter In Power BIFeb 28, 2018. Sometimes there is a situation in which we need to get data by consuming SQL Server stored procedure. SQL Server stored procedure has parameters which we need to pass dynamically. Power BI provides a functionality to execute Stored Procedure using Managed Parameters. During this article we will talk about, • How to create Manage Parameter • How to pass manage parameter to a Stored Procedure • Invoke Query Result and load data to Power BI Desktop
  • What Is Date Correlation Optimization?Feb 28, 2018. OK So, I am doing some digging and peaking around again in SQL Server and came across a database option called Date Correlation Optimization Enabled = False. Honestly, I had no clue what it did, so I took it as a learning opportunity to look into it and do a little research. Who knows, it may actual help me solve one of the many problems I run into day to day for clients.
  • Introduction To Cloud Computing And Microsoft AzureFeb 25, 2018. In this article, I am going to write about cloud computing
  • Introduction To ReturnType KeyFeb 25, 2018. Today, I would like to tell you about Entry Key ReturnType. How to change ReturnKeyType keys like Search, Done, Next etc. In this article I am using Xamarin Forms PORTABLE and XAML.
  • Insert And Display Records With Model Binder Using ASP.NET MVCFeb 23, 2018. In this blog, I am going to explain how to insert and display records with Model Binder using ASP.NET and Entity Data Model (DB First Approach).
  • What Does This Little Check Box DoFeb 21, 2018. Ever wander around SQL Server properties and wonder what these little check boxes turn on? I do, and I get very tempted to check them. Here is one of those tempting little boxes that seems pretty handy. Use query governor to prevent long running queries.
  • VLFs - The Forgotten FoeFeb 19, 2018. How many of you check the amount of Virtual Log Files (VLFs) your transaction logs have?
  • SQL Database Query Editor In Azure Portal - An IntroductionFeb 19, 2018. Learn SQL Database Query Editor In Azure Portal.
  • Download User License Information For PowerApps And Microsoft FlowFeb 16, 2018. PowerApps is one of the services available in the Office 365 environment that enables us to create apps or forms for business and other uses without coding experience. We can connect against external data sources like SQL, SharePoint, Salesforce, etc... to develop an application. PowerApps has its own data source called Common Data Service.
  • Combine Multiple Observables Using combineLatest In Angular AppFeb 16, 2018. In this article, I am going to show you the benefits of using the combineLatest operator in an Angular application.
  • Why Am I Unable To Contact People In Other Organizations From Skype For Business?Feb 16, 2018. Most organizations have blocked users from contacting people in other other organizations due to some protocol within their company.
  • How To Get Started With Always Encrypted For Beginners - Part ThreeFeb 15, 2018. A few weeks ago, I wrote Part 1 and 2 of this series, which was a beginner’s guide to Always Encrypted. In part 3, I am going to go over what road blocks I ran into when trying to implement this solution for a client. The goal of the project was to prevent the DBA from being able to view salary information, while still allowing the application to function without issue.
  • Publish ASP.NET Core 2.0 Application On Azure With SQL ServicesFeb 15, 2018. In this article, we will learn how to deploy or publish an Asp.Net Core 2.0 application on Azure.
  • SQL Coding Best PracticesFeb 14, 2018. While executing your procedure, the system will first scan through all system procedures and then user defined procedures. This means that the procedure might take more time for execution thus decreasing system performance.
  • How To Get Started With Always Encrypted For Beginners - Part TwoFeb 12, 2018. In this post we will pick up where we left off in Part 1, if you haven’t read that please go back and do so. Now that we have encrypted our columns, it’s time to take a look at how we decrypt them inside SQL Server Management Studio or through our applications. You’ll be surprised to see how easy it is.
  • Creating An Azure Database For PostgreSQL ServerFeb 11, 2018. In this article, I am going to demonstrate how to create a database in Azure for the PostgreSQL server in the Azure Portal.
  • ASP.NET Request Life CycleFeb 08, 2018. In this article, I am trying to go through the various tasks and events involved in the ASP.NET request processing cycle.
  • Introduction To LINQ With Entity Framework In Visual StudioFeb 08, 2018. LINQ queries are similar to SQL query created for developers to maintain standardized coding approach. It deals with the data objects therefore it is similar to OOPs.
  • Leadership Challenge 005 - Coach To Win, Not To FixFeb 08, 2018. Hello my friends!!! I am starting to see success in my role helping drive adoption by leveraging the Modern Workplace. My hometown is going crazy over the Super Bowl win by our Philadelphia Eagles.
  • How To Get Started With Always Encrypted For Beginners - Part OneFeb 08, 2018. Encryption has always been intriguing to me but seemed like it could be a very complex process to set up. However, SQL Server made it very simple when they introduced Always Encrypted (AE) into SQL Server 2016 and Azure SQL Database.
  • Synchronous VS Asynchronous Statistics UpdatesFeb 07, 2018. Implement to help with performance is changing from Update Statistics Synchronous to Auto Update Statistics Asynchronously.
  • Cursors In SQL ServerFeb 06, 2018. A cursor is a database object which is used to retrieve data from result sets one row at a time.The cursor can be used when the data needs to be updated row by row.
  • SQL Sequence Vs Identity ColumnFeb 06, 2018. Let’s take a look at what a Sequence is in relation to an Identity Column in SQL Server. Did you know Sequence even existed? I didn’t until I was asked about them. It’s amazing how much you can skip over and never notice in SSMS. See this little folder, ever notice it under Programmability in Management Studio. Yep it’s there, SQL Server has this very handy thing called Sequences. Sequences are a relatively new feature that have only existed since SQL Server 2012, but have long existed in Oracle (where there a no identity columns).
  • Automating SVN Check-Ins And Building A Project Via JenkinsFeb 05, 2018. A few weeks back, while sitting with my team, I learned that they run a Jenkins job which has to execute the automation scripts using the robot framework, daily around 1:00 a.m. The primary purpose of the job is to place all the necessary files and folders over the node machine of Jenkins (after copying them from the machine pointed as master on Jenkins), execute those scripts accordingly, generate the reports, and finally copy the output files back to the master machine to analyze the logs for the overall reporting and analysis purposes. This whole efficient job starts with a slack manual step which was enough to tag this activity 'not fully automated' because they had to place the updated work regularly on the specified path over the master machine before leaving the office (this includes taking the updated code, files, and automation scripts, building the project to take the DLLs etc.). This may sound tedious but more than that, there is no sense to do it manually.
  • CRUD In Excel File In C#Feb 02, 2018. In this article, I am going to explain how we can CREATE, UPDATE, DELETE and READ the records in Excel files.
  • Basics Of Angular And Its Versions - Part SixFeb 01, 2018. In this article, I am going to discuss more about async/await support. This async/await feature officially announced in TypeScript 2.1. We can say this is one of the very import feature in TypeScript 2.1 release.
  • Performing CRUD Operations On Azure SQL Database Using SharePoint Framework Web Part And ASP.NET Web API - Part TwoJan 30, 2018. Normally, you would want to put your css classes in the .scss file (i.e. YourWebpartName.scss) and import it into the YourWebpartName.ts file (this is actually done automatically during project creation). But I decided to put it in a SharePoint list because my css selectors are grouped and I could not reference them using "styles.selector".
  • Azure WebApp - Rollback Your Deployment Using Deployment SlotJan 29, 2018. We generally find issues in our deployed application while it is in production. This is a really awkward situation in the development cycle. It is also painful for the customer. I am going to discuss the solution to this issue in this article.
  • Performing CRUD Operations On Azure SQL Database Using SharePoint Framework Web Part And ASP.NET Web API - Part OneJan 24, 2018. Supposing there is an existing data in an SQL database, be it Azure or an on-premise database server, you are required to make the data available for CRUD operations in SharePoint for your users. This is a scenario where this article will be of help to you. In this article, I will show you how you can perform CRUD operations on Azure SQL database from a SharePoint web part. Note that the steps are same for on-premise SQL database except for the steps required in setting up Azure database.
  • ASP.NET Core Apps In Docker SwarmJan 23, 2018. First, we need a few Virtual Machines to make a cluster of machines to run Docker on. I am using Windows 10 and will use Hyper-V for this purpose. If you’re using another OS then skip the first part of the tutorial where I setup VMs.
  • Different Ways To Deploy A Website On AzureJan 23, 2018. I am here again with a new article. In this article, I am going to talk about the deployment of websites on Azure.
  • SharePoint Online Automation - O365 - Upload Your Files Remotely Using PowerShell To SPO Document LibraryJan 23, 2018. Continuing with SharePoint Online Automation, today, I am going to demonstrate “O365 SharePoint Online- How to Upload your files remotely using PowerShell to SPO document Library”.
  • 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.
  • Azure Media - Implement Media Content EncryptionJan 15, 2018. I am writing this article on the encryption of a video using Azure Media Service.
  • 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.

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

NA
Hire a remote developer
Looking to add more bandwidth to your software team? Web Developers, designers, testers are now available on demand. Flexible hours, very competitive rates, expert team and High Quality work.
X

Build smarter apps with Machine Learning, Bots, Cognitive Services - Start free.

Start Learning Now