C# Corner

Resources  
  • 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.
  • Retrieve Real-Time Data In Firebase Using Android StudioApr 20, 2018. Data retrieval is the process of identifying and extracting data from a database, based on a query provided by the user or application. It enables the fetching of data from a database in order to display it on a monitor and/or use within an application.
  • ASP.NET Web API Using MVC, Entity Framework And jQuery For Retrieve Data - Part TwoApr 20, 2018. The most common use case for using Web API is for building RESTful services.
  • 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.
  • Trigger A Microsoft Flow With A Button Click On SharePoint OnlineApr 18, 2018. Microsoft Flow is a cloud-based software tool that allows users to create and automate workflows across multiple applications and services without the need for a developer’s help and is part of the Office 365 suite. It is included in most of Office 365 subscriptions and can be accessed via Office 365 app launcher. Automated workflows are called flows and its most common usage is to trigger notifications, synchronize files & collect data. The focus of this article is to highlight how to trigger a Microsoft flow on a button click event within SharePoint Online.
  • 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).
  • Using Business Rule For Data Import ValidationApr 16, 2018. In this article, we will learn how to use Business Rule for Data Import Validation.
  • What Is Microsoft Graph SDK?Apr 16, 2018. This article is a quick overview of MS Graph SDK. Using MS Graph SDK, you can easily write code which calls MS Graph APIs to interact with Office 365 data.
  • Using Azure Redis Cache On Your .NET Core Application - Part TwoApr 16, 2018. In this article, we will see how to use Azure Redis cache to cache your data and provide a faster way of loading the web pages to the users.
  • 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.
  • Composed Relationship Types - Func<Owned<T>>Apr 10, 2018. It&#39;s the beauty of relationship types, that they can work in conjunction with one another. Therefore, we can compose relationship types to solve a particular problem.
  • Real-Time Data Storage In Firebase Using Android StudioApr 09, 2018. This article demonstrates how to store real-time data in Firebase using Android Studio.
  • Dynamic Objects And Alternatives To ReflectionApr 08, 2018. The CodexMicroORM open source project on GitHub includes several features to help you create fast, concise .NET deliverables. One such feature is implemented in the Performance.cs file and enables dynamic (i.e. run-time) access to properties of any object – faster than what you’d get out of System.Reflection.Type. CodexMicroORM leverages this feature in several places, one being the ability to build composite objects: your existing “POCO” (plain-old C# objects), with additional optional extended properties.
  • Introduction To MS Graph APIApr 08, 2018. In this article, I will introduce you to the MS Graph API which is a powerful way to interact with Office 365 data.
  • 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.
  • Wave View In Android Using Android StudioApr 07, 2018. In this article, we are going create a Wave View in Android using Android Studio. It is a type of library which makes the wave in UI. By using this, we can show the progress status in a percentage. This view is widely used in mobile apps.
  • Creating Custom Pipe Using Safe HTML In Angular 5Apr 07, 2018. A pipe takes in the data as input and transforms it into the desired output. Pipes are declared using @Pipe decorator. We will create a custom pipe here, in this article. Like a filter, a Pipe also takes data as input and transforms it into the desired output.
  • Pulse View In Android Using Android StudioApr 07, 2018. In this article, we are going create a Pulse View in Android using Android Studio. It is a type of library which makes the pulse view for the image as a icon.
  • Console Application To Fetch SharePoint List Data Using REST API With CAML Query In C# Managed CodeApr 05, 2018. SharePoint 2013 has many restful APIs, to fetch data from lists. However, sometimes we need to use CAML query to filter out the data. SharePoint rest API has an option to pass CAML query as a data to API call. Below steps will help you to call a rest API with CAML query filtering.
  • Difference Between Value Type Variables And Reference Type VariablesApr 03, 2018. Before we get started between the difference of value type variables and reference type variables, we need to understand the concept of stack and heap. So let’s get started with stack and heap.
  • How Develop Analytics For SharePoint Online Using Power BIApr 03, 2018. In this article, we will discuss how to use data stored in SharePoint Online Site to develop analytics using PowerBI.
  • Local Authentication Using Node.jsApr 02, 2018. Authentication means validating your credentials like username and password to confirm your identity. The system or application confirms that you are the true user for accessing the private or confidential data. Authorization is a process of verifying that you have access to do something.
  • Learn About Azure Data FactoryApr 02, 2018. Azure Data Factory is a cloud-based data integration service that allows you to create data-driven workflows in the cloud for orchestrating and automating data movement and data transformation.
  • Indexing In-Memory Collections For Blazing Fast AccessApr 01, 2018. The CodexMicroORM open source project on GitHub hosts a few useful .NET goodies that can help you write concise code with great performance. In this article I’ll cover a collection type that supports multi-property indexing and as such, performs very well with equality lookups.
  • 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.
  • Angular - Creating Custom Pipe(|)Mar 28, 2018. As we already know that Pipes (|) in Angular are used to transform the data before displaying in a browser. So in this article, my requirement is to filter the student record based on the value i.e. Name of the student entered in the search textbox given at the top.
  • TN Image View In Android Using Android StudioMar 28, 2018. In this article, we are going create a TN image view in android using Android Studio.It is a type of library which makes the image touchable and movable.By using this we can move the image with a simple touch.
  • Angular - PipesMar 27, 2018. Pipes (|) in Angular are used to transform the data before displaying it in a browser. Angular provides a lot of built-in pipes to translate the data before displaying it into the browser.
  • 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.
  • Learn About Data Binding In Xamarin.FormsMar 26, 2018. In this article, you will learn about Data Binding in Xamarin.Forms.
  • 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 &amp; 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.
  • Implementing Equality For Reference TypesMar 26, 2018. In this article, you will learn to Implement Equality for Reference Types.
  • Separation Of Concern And Data Access From Within CodeMar 24, 2018. In this article, you will learn the separation of concern and data access from within code.
  • Data Binding In Angular 5Mar 24, 2018. In this article, we will go through how can we display data and handling events in Angular.
  • Custom Buttons In Android Using Android StudioMar 23, 2018. In this article we are going to see how to create custom buttons with different attributes such as different color, shape, size, etc.
  • 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.
  • Create Charts In ASP.NET MVC Using Ignite UI jQueryMar 23, 2018. In this article, you will learn to represent Data using Ignite UI jQuery Charts with MVC.
  • Data Governance Using Labels In Office 365Mar 22, 2018. Many organizations have started using Office 365 for their business purpose. With this now we have many documents being stored all across Office 365. With this, organizations are looking for implementing the governance around their data. The documents should be classified and governance should be carried over as per the classification. Performing all these things manually is next to impossible, as the document can be anywhere in Office 365 and can be uploaded by any user.
  • 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.
  • 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.
  • 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 .
  • 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.
  • Defensive Programming - Let Type Checking Work For YouMar 19, 2018. Since I have been a speaker and a teacher, I have always stressed the importance of practicing proper object-oriented programming (OOP) techniques. If you don’t practice OOP, no matter what language you are using, I guarantee you will end up with a “house of cards” and they all eventually fall.
  • Create Shadow For Image In Android Using Android StudioMar 19, 2018. This article will show you how to create a shadow for any type of image in an Android application using Android Studio.
  • Angular From Basic To Expert - Day FourMar 18, 2018. Angular, Scope in AngularJS
  • Using Azure Redis Cache On Your .NET Core Application - Part oneMar 18, 2018. In this article, we will see how to use Azure Redis cache to cache your data and provide a faster way of loading the web pages to the users
  • 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&#39;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.
  • Building A Data Driven App Using WPF XamDataGridMar 15, 2018. A typical rich data-driven Windows client app includes a backend database and a front-end client UI. The app connects to a database, reads the database, displays records in data controls, and implements CRUD operations. The app may also include some advanced UI operations such as sorting, searching, filtering, multiple views, and data export.
  • 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.
  • Implementing Multiple Interfaces With The Same Method Signature In C#Mar 14, 2018. An interface in C# is a type which only defines a group of related functionalities and leaves the implementation of the functionalities to any class or struct which implements the interface. It helps a lot in implementing the SOLID principles and makes the application more decoupled.
  • Azure VPN Point To Site IP AddressesMar 14, 2018. Recently, I got to work with a client on something interesting. We implemented transactional replication to send data to an Azure virtual machine. This was being done to perform some testing for a project.
  • 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.
  • 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.
  • Learn About State Management In ASP.NET MVCMar 11, 2018. In this article, we will discuss various ways to pass the data from Controller to View, or Controller to Controller. However, in ASP.NET web applications, for state management, we use View State, HiddenFileds, Session, etc.
  • Data Cleansing Tools In Azure Machine LearningMar 09, 2018. Data cleansing is an important part of the Data Science Process which will help in having higher and better accuracy on predictive models. In this article, the process and techniques of doing so shall be discussed using Azure Machine Learning.
  • Working With Arrays In JavaScriptMar 09, 2018. Arrays are the collection of same data-types values or a collection of data items. In memory variable, we can store one value at a time but in arrays, we can store many values and retrieve as per index number of stored values.
  • Continue With Learning Indexes In MongoDBMar 08, 2018. This is the continuation of exploring the Indexes on MongoDB. We will be discussing various MongoDB indexes which we can perform on our data.
  • Xamarin.Forms - Working With Application StorageMar 08, 2018. This article covers working with Application Storage to save app settings on the app in the Xamarin forms App.
  • Building Xamarin Mobile Application With Bing Web Search Using Cognitive ServicesMar 08, 2018. The Bing Web Search API provides an experience similar to Bing.com/Search by returning search results that Bing determines are relevant to the user&#39;s query. The API results include Web pages, images, videos, news, and entities, along with related search queries, spelling corrections, time zones, unit conversion, translations, and calculations. The web Search API uses JSON format for data exchange, and API Keys for authentication.
  • Azure Logic Apps - Hello WorldMar 05, 2018. Logic Apps are a relatively new feature of Microsoft Azure that makes it simple to build complex workflows using one or more of the over 200 plus different connectors. Since the Logic Apps are serverless, you do not need to worry about server sizing. The platform will scale to meet your demand, and better yet, you&#39;re only charged for what you use.
  • How To Change HTTP Browser Cache SizeMar 05, 2018. HTTP Caching is available in most browsers and helps make a website more responsive and reduce network bandwidth. In this article, we will understand how to increase or decrease the Cache size in Modern browsers like Google Chrome, Mozilla Firefox, IE.
  • Liquid Templates In Logic AppsMar 05, 2018. Azure Logic Apps support basic JSON transformations through native data operation actions such as Compose or Parse JSON. For advanced JSON transformations, we can use Liquid templates with our logic apps. Microsoft has released the support of Liquid Templates to transform JSON and XML objects.
  • Blockchain, An Unblocked Opportunity For DevelopersMar 04, 2018. My aim with this article is to bring some attention to the size of the opportunity blockchain presents for software developers.
  • 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.
  • Understanding Fragmentation In Distributed DatabasesMar 03, 2018. This article explains about fragmentation types in distributed databases.
  • Entity Framework Core Feature - Global Query FiltersMar 02, 2018. This feature is also refer as Model-level query filters. It allows to specify filter in the model level that are automatically applied to all queries that executed on the context on the specified type. It means that entity framework automatically adds the filter in where clause before executing the LINQ queries. Usually Global query filters are applied in OnModelCreating method of context. This filters are also automatically applied to LINQ queries involving the entity types referenced indirectly like included as navigation property.
  • No Tracking With Entity Framework CoreMar 02, 2018. DbContext in Entity Framework is responsible for tracking the changes made on the entity or object, so the correct update is done to the database when the SaveChange() method of context is called. When we retrieve entities using an object query, the Entity Framework puts these entities in a cache and tracks whatever changes are made on these entities until the savechanges method is called. Entity Framework tracks the query results that return entity types.
  • 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.
  • Using NPoco ORM In ASP.NET CoreFeb 27, 2018. As you know, we have so many ORM available such as NHibernate, Entity Framework, Dapper.Net which are used to communicate with database in order to perform CRUD (Create, Read, Update, Delete), and also retrieving data based on criteria.
  • Data Loss Prevention In Office 365Feb 26, 2018. Nowadays, customers are moving to the Cloud. Office 365 is the most attractive package from Microsoft to help move businesses to the cloud quickly and seamlessly.
  • Inserting Data Into Multiple Tables In MSSQL At Once In .NET (Affecting Multiple Rows)Feb 26, 2018. This article will teach you about inserting data into multiple tables in MSSQL at once in .NET and inserting data into cumulative tables from .NET
  • Handling Different Types Of Web Elements Using SeleniumFeb 25, 2018. In this article, I’ll explain how to handle Web elements using Selenium.
  • Angular, Bootstrap and ASP.NET MVC - Bootstrap Form Controls - Part EightFeb 23, 2018. In previous articles we have learned AngularJS project setup, styling with Bootstrap, AngularJS structure, data-binding, routing, copying of Angular objects when a form is saved or canceled, inserting/updating forms, Bootstrap modal forms, and more.
  • 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.
  • Learn Angular 4.0 In 10 Days - AJAX Request Handling - Day EightFeb 20, 2018. In this article, we will discuss how we can handle AJAX requests for fetching or sending data using Angular 4.0.
  • How To Fetch Data From Task List Using Rest For Workflow History In SharePoint OnlineFeb 20, 2018. I got a requirement to make a history form for a workflow. For that, I had to fetch the data from a task list. We can use Rest API, SP Services, or any other methods for this kind of task. So, I chose REST API for the same. Now, the question is, what will be the scenario? Because Workflow status columns of Assign to and Modified Date are not available in the normal list. Then, I learned that we can fetch it from the task list or history list as in workflow all the information resides in Task list &amp; History List.
  • SQL Database Query Editor In Azure Portal - An IntroductionFeb 19, 2018. Learn SQL Database Query Editor In Azure Portal.
  • VLFs - The Forgotten FoeFeb 19, 2018. How many of you check the amount of Virtual Log Files (VLFs) your transaction logs have?
  • Import And Export Data Using EPPlus.CoreFeb 19, 2018. In this post, we will see how we can import and export excel data in Asp.net Core. We are using EPPlus.Core library which helps us to perform import and export operations. I hope you will like it.
  • Using jQuery DataTable To Display SharePoint 2013 List Data On SharePoint Site PagesFeb 17, 2018. In this article, we will learn how to pass SharePoint List Data to a jQuery DataTable using REST API and display SharePoint list data on SitePages using DataTable.
  • WPF - Dropdown Menu/Combobox Menu Data Binding Using Text FileFeb 16, 2018. This article is about WPF dropdown menu/combobox menu data binding using text file
  • 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.
  • 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.
  • Pipes In Angular 5Feb 13, 2018. In this article we will be discussing Pipes in Angular 5. Pipes are the operators which is used to format data in Angular. This comes from the symbol (|) used to do this operation. Pipes are there in Angular from Angular2 onwards. But it has evolved over the period of time. There are many inbuilt pipes available in Angular 5 and it gives an easy template to create your own pipe using @angular/cli.
  • Stack, Heap, Value Type, And Reference Type In C#Feb 13, 2018. Now, let’s see what happens when we declare any variable like int a=10 in C#. When C# compiler will run, it will allocate a block of memory which will have name of variable i.e. a, its type i.e. int and its value i.e. 10. Now this memory can be of type Stack or Heap i.e. variable gets store in Stack or Heap.
  • 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.
  • Increase Data Disk Size In AzureFeb 11, 2018. Retaining data in the same VM requires us to increase the disk space when the utilization of allocated space is full. Increasing the disk space in Azure is quite easy with a few clicks.
  • Work With CDN On Azure Storage - Part FiveFeb 10, 2018. This article will help you to work on Azure Storage by adding CDN (Content Delivery Network) to access data with high availability.
  • Amazing Guide To SharePoint Framework Development With React - Part TwoFeb 09, 2018. In my previous article, we walked through how to create a SharePoint Framework web part with React to display the mockup contents step by step. We will continue the same source for displaying the SharePoint data in the web part.
  • 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.
  • 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.

About SQL-data-types-Size

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