C# Corner

Resources  
  • SharePoint 2016 June 2017 CUJan 21, 2018. In this article, we will list all the issues which are fixed in this June 2017 CU. MSFT released two versions of it, one includes the Fixes for LPs and others don’t include the Fix for LPs. Now it is irrelevant what language pack you installed or what the base language of the SharePoint is. You just simply install both exes and it will take care of everything.
  • SharePoint 2016 May 2017 CUJan 20, 2018. In this article, we will list all the Issues, which are fixed in this May 2017 CU. This Month MSFT released two versions of it, one includes the Fixes for LPs and others don’t include the Fix for LPs. Now it is irrelevant that what language pack you installed or what base language of the SharePoint. You just simply install both exe and it will take care of everything.
  • SharePoint 2016 April 2017 CUJan 20, 2018. In this article, we will list all the Issues, which are fixed in this April's 2017 CU. This Month MSFT released two versions of it, one includes the Fixes for LPs and others don’t include the Fix for LPs. Now it is irrelevant what language pack you installed or what the base language of the SharePoint is. You just simply install both exes and it will take care of everything.
  • CRUD Operation In MVC Using Elastic SearchJan 17, 2018. Elastic search is a search engine based on Lucene. It provides a distributed, multitenant-capable full-text search engine with an HTTP web interface and schema-free JSON documents. Elastic search is developed in Java and is released as open source under the terms of the Apache License.
  • 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.
  • Angular Material Design Components With Reactive Form - Part TwoJan 15, 2018. This is continuation part of Angular material component with Reactive forms , in which we are going to learn how to implement reactive forms with Angular material controls
  • Basics Of Angular And Its Versions - Part TwoJan 15, 2018. Module is nothing but a package like a package in Java, a namespace in C# and like a header-file in C / C++. Java, C#, and C++ have their own modularity system which contains classes, interfaces, enumerations etc. In the same way, Angular also has its own modularity system called NgModules which helps to organize an application into adhesive blocks of functionality. Every Angular application should have at least one NgModule and the root module is called AppModule.
  • Comparison Of Subquery And JoinsJan 15, 2018. Here, in this article, we are comparing the SQL Join and SQL Subquery.
  • Angular 5 CRUD Operation Using Node, Express, MongoDBJan 13, 2018. In this article, we’ll learn to create basic CRUD application using angular 5, Nodejs, Express and Mongodb nosql database.
  • Bind Menu And Sub Menu Dynamically In ASP.NET MVC From Database Using LINQJan 12, 2018. Many times we need to create a menu for a simple application. We ususally get stuck on how to bind the menu. Here in this article we you will learn how to bind menu and sub menu dynamically in ASP.NET MVC from database using linq.
  • AI Series - Part Two - Programming EmotionsJan 12, 2018. I will be showing how to start AI Development with Cognitive Services. Previously, we kickstarted our new article series “AI HowTo” and talked about how to register for Emotion API Preview(Project Oxford) through Azure Portal.
  • 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 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.
  • Singleton Design Pattern In C# - Part Two (Eager and Lazy Initialization in Singleton)Jan 09, 2018. In this article, we’ll discuss Lazy initialization, the lazy keyword, why to make singleton class a sealed class and what are the differences between singleton and static class.
  • 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.
  • Kanban - An IntroductionJan 05, 2018. This article is an introduction to Kanban and how it is similar and different as compared to Agile
  • 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.
  • Learning Angular - Lab TwoJan 04, 2018. Components are the main way we build and specify elements and logic on the page, through both custom elements and attributes that add functionality to our existing components.
  • 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
  • The Burn Up Charts In ScrumJan 04, 2018. I would like to propose the less taken path in my maiden article to track the progress in scrum. We usually do it using the burn down chart which is relatively easier to understand as compared to Burn up chart. These charts help the team and stakeholders to see and track the progress at any point in the release process or sprint.
  • SignalR Chat App With ASP.NET WebForm And BootStrap - Part TwoJan 03, 2018. In previous articles, we learned how to create a real-time chat application using SignalR.
  • Angular From Basic To Expert - Day ThreeJan 03, 2018. In the previous articles - AngularJS from basic to expert Day One and Day Two, we have learned what AngularJS is, its basics, and usage of AngularJS expression and directives. Here we will learn Models, Modules, and Controllers in AngularJS.
  • Using jTable Grid With ASP.NET MVCJan 03, 2018. In this article, we are going to learn how to use jTable Grid with ASP.NET MVC, and along with that we are going to use Entity framework for accessing the database.
  • Azure PowerShell Module InstallationJan 02, 2018. Azure Cloud Shell and Azure PowerShell are the two different types of shells available to manage the Azure resources through cmdlets. Azure Cloud Shell can be accessed through the browser.
  • 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!
  • Creating A CRUD With ASP.NET Core And EF CoreDec 28, 2017. Entity Framework Core (EF) is an ORM that makes it simpler to work with database by using POCO classes that map to database entities and DbContext to interact with them.
  • How To Create Page Loader Using CSSDec 28, 2017. A page loader is any quite animation that visually communicates to a visitant that the page is loading and to simply remain for a couple of seconds. ... it's the previous situation wherever a CSS page loader will work okay.
  • What And How Of Requirement Gathering - Part TwoDec 27, 2017. Prototyping allows gathering information by faking the production environment. In this technique, quite a lot of tools can be used to collect information, such as software programs to monitor/record mouse clicks or keystrokes, camera to monitor visual activity.
  • Build Scalable Web Applications With Azure Database For MySQLDec 26, 2017. Azure Database for PostgreSQL and Azure Database for MySQL bring together community edition database engines and capabilities of a fully managed service—so you can focus on your apps instead of managing a database. See how the service helps you quickly respond to changing customer needs by scaling up and down. And see how capabilities like high availability and replication help you meet and exceed customer expectations.
  • Validation Of Excel Data In C#Dec 24, 2017. This article demonstrates how to validate an Excel sheet before uploading or storing its data into a database.
  • 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.
  • MasterDetailPage In Xamarin Forms ApplicationDec 21, 2017. MasterDetailPage is the main page that is responsible for two related pages. It contains the master page that has items and the detail page that shows the details about the items present on master page.
  • Using Gijgo Grid With ASP.NET MVCDec 20, 2017. In this article, we are going to learn how to use Gijgo Grid with ASP.NET MVC along with that we are going to use Entity framework for accessing the database.
  • Xamarin.Android - Working With Firebase Database - Part TwoDec 20, 2017. Today, we are going to learn how to save and retrieve data from Firebase in Android.
  • Generating XML Root Node Having Colon-Via SerializationDec 20, 2017. This article discusses some of the issues faced while generating an XML on the fly with some defined schema.
  • Add Email Authentication To Xamarin.Android App Using Firebase - Part TwoDec 19, 2017. Today, I am going to show you how to add Email authentication in Android using FireBase.
  • Stored Procedures Vs User Defined Functions And Choosing Which One To UseDec 19, 2017. In SQL Server, we usually come across queries, tables, views, stored procedures and functions. People often wonder what are the real differences between User Defined Functions (UDF) or simply functions and stored procedures or just procedures. There are two types of functions: Built-in and user defined. Built-in functions cannot be modified where as you can create and modify your own UDF. To utilize the full advantage of these features, we should understand their capabilities and what we can do with them and what we cannot. I am going to explain this in terms of SQL Server.
  • Xamarin.Android - Working With Firebase Database - Part OneDec 19, 2017. Today, we are going to learn how to save and retrieve the data from Firebase in Android.
  • Building Multitenant Architecture Using ASP.NET Core And Micro ServicesDec 18, 2017. Instead of deploying an application per client, organizations prefer multitenancy to save infrastructure cost and deployment time. Multitenant architecture helps to adapt changes for different clients under the hood. In this article I am not going to discuss database design for multitenant applications but I will be focused on achieving separation for different clients.
  • ASP.NET Core 2.0 Tag Helper ComponentDec 18, 2017. In case you’re wondering if the solution above is missing a Tag Helper for head HTML element, it’s not. ASP.NET Core team has provided us with two built-in Tag Helpers, one targets head and the other targets the body element: HeadTagHelper and BodyTagHelper.
  • Xamarin.Android - SQLite DatabaseDec 17, 2017. In this article, I shall show you how to handle all database CRUD operations using SQLite.
  • Xamarin Android - Working with Existing DBDec 16, 2017. In this article, I shall show you how to retrieve user data from existing SQLite Database.
  • Directives In Angular 5 - Part Two (Structural Directives)Dec 15, 2017. These are responsible for the HTML layout they shape or reshape the html element by simply adding or removing the elements in the DOM. These directives are the ways to handle how the component or the element renders in the template .
  • Two-Way Binding Or MVVM In Xamarin.Forms ApplicationDec 15, 2017. In this article, we are going to learn how to apply two-way binding in Xamarin forms application with the help of InotifyPropertyChanged System component model.
  • Special Class Of C# Series - Part Two - OLE DB (Extended Properties)Dec 14, 2017. In this series of C# Special classes, we are going to see the special features available with the “OleDbConnection” class and its specialties.
  • 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.
  • Introducing Hadoop /Big Data For BeginnersDec 14, 2017. Companies like Facebook ,NASA, and Google have huge amount of data (can be hundreds of petabytes or exabytes). Each and every like, click, comment, review, update, search, call, visit, piece of financial and health information, transaction, photo upload etc., which is a very huge data set, gets stored somewhere(database).This data is called Big Data.
  • Xamarin.Android - Stop Watch Seconds And MillisecondsDec 14, 2017. In this article, I shall show you how to make a simple stop watch app in Xamarin Android. A stopwatch is a handheld timepiece designed to measure the amount of time elapsed from a particular time when it is activated to the time when the piece is deactivated. A large digital version of a stopwatch designed for viewing at a distance, as in a sports stadium, is called a stopclock. In manual timing, the clock is started and stopped by a person pressing a button.
  • DirectQuery Mode In Power BIDec 13, 2017. In this article, we will talk about the two ways to import data into Power BI. When we connect any data source, it will import copy of the data in Power BI. For some data sources, an alternative approach is available: connect directly to the data source using DirectQuery.
  • Getting Started With CosmosDBDec 12, 2017. DocumentDB is a NoSQL database which is massively scalable and it works with schema free JSON documents.
  • Starting With Google Cloud Firestore Database With AngularDec 12, 2017. Cloud Firestore is a NoSql Document database built for automatic scaling, high performance, real time, and ease of application development.
  • If I Ran A Software Company - Part TwoDec 11, 2017. This is part 2 of my article on this subject. I hope you read part 1 before reading this post.
  • Xamarin.Android - Flags Quiz Game App - Part TwoDec 08, 2017. In this article, we shall learn how to build a flags quiz game in Xamarin Android. Flag quiz basically is a simple game that can develop your knowledge about countries' flags.
  • 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.
  • 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.
  • Building An ASP.NET Core Application With Web API And Code First DevelopmentDec 05, 2017. In the previous article, we’ve learned the high-level overview of what Entity Framework is all about and learned how to build a web application quickly using Entity Framework’s Database-First development.
  • Implement Validations In Angular 5 AppDec 03, 2017. In this post, we are going to implement Two Way binding and validations in Angular 5 registration form. So at the end of this article, you will be proficient in how to do validations in Angular. I hope you will like this article.
  • Object Comparison In C# - Part Two [N Level Down List Comparison]Dec 02, 2017. This article will demonstrate the comparison of the objects (or list of objects) with n level down list comparison.
  • 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.
  • Comparing Objects In C#Nov 29, 2017. In this article, we are going to compare two objects of the same class having collection property or multiple collection properties.
  • Passing Data Between Components - Day TwoNov 29, 2017. We have seen that we can pass the data between the components using the @Input and @Output directives and using event emitters. Let’s see the other two methods - @View child and the services which can be used to pass the data between components.
  • View Product Details Using Kendo ScrollView In ASP.NET MVC5 With Entity FrameworkNov 29, 2017. Here, I will demonstrate how to work with Kendo ScrollView to View the product details from a database using Entity Framework in ASP.Net MVC5
  • Virtual Entity - New Way Of Integration - Part TwoNov 28, 2017. This is our second article regarding virtual entity, if you have not checked our earlier article, we suggest you check that first here. In this article we are going to demonstrate about create OData Web API without Entity Framework and hosting it in Azure to consume into Dynamics 365. Let say we have employees data that we want to show into virtual entity, so let’s get started!!
  • 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.
  • Building API Gateway Using Ocelot In ASP.NET Core - Part TwoNov 27, 2017. In this article, I will continue with the topic of Building API Gateway In ASP.NET Core and will show you something about authentication later.
  • 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.
  • Configuring Log4Net With Database - A Tutorial For BeginnersNov 26, 2017. Log4Net is a framework for logging .NET applications. It is an open source library that can be used to log output for different targets like logging output in Text files, Database, Console, Mail (SMTP), Remote and others. In this article, I will explain how to log output in a database.
  • Highcharts Drilldown Functionality With Angular Custom Directive And Web APINov 25, 2017. This is the second part of this series, “Highcharts with Angular JS custom directive and Web API”. In the first part, we discussed the preparation of the charts using the Highcharts library and Web API.
  • 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.
  • Creating An Event Hub On The Azure PortalNov 24, 2017. In this article, I am going to describe and demonstrate the creation of Event Hubs on the Azure Portal.These Event Hubs are used to act as a port to collect the streaming data and processing of that data per second.
  • Connecting R Software With Oracle DBNov 24, 2017. This article is about how to connect the R software with Oracle database so that the data can be brought inside R environment for analysis
  • Xamarin.Android - Working With MongoDBNov 21, 2017. Today, I will show you how to create MongoDB and how to use MongoDB using Xamarin.Android.
  • Your Singleton Might Not Be "Single"Nov 21, 2017. Singleton has been a very popular design pattern as it is proven to have some advantages compared to the global variables
  • Migrate From TFS To VSTSNov 21, 2017. Migrate from TFS to Team Services with the TFS Database Import Service.
  • Implement DropDown MultiSelect Using Kendo UI MultiSelect In ASP.NET MVC5Nov 21, 2017. In this article, I am going to explain how to bind the value to a dropdown from the database, how to implement drop-down multi-select, how to group the drop-down values, and how to implement Custom Template using Kendo UI MultiSelect in ASP.Net MVC5.
  • Creating A 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.
  • Learn Angular 4.0 In 10 Days - Component - Day TwoNov 20, 2017. In this article, we will discuss about component concept in Angular 4.0.
  • Uploading, Validating, And Storing A File Into Database Using EF In ASP.NET MVC5Nov 20, 2017. Here, you will learn how to upload a file, validate a file and store a file into database using JQuery, Entity Framework in ASP.NET MVC5
  • Auto Complete with ngTagInput using Web API in AngularJSNov 16, 2017. AutoComplete,ngTagInput,Web API,AngularJS,AutoComplete in AngularJS using Web API
  • Two Way Data Binding In Angular Without $scope Object Using MVCNov 16, 2017. Data binding is the most useful and powerful feature among any of the existing or upcoming software development technologies. It is actually a process that bridges a connection between the view and business logic of the application.Basically we will see one-way and two-way data binding with respect to AngularJS applications. But before we jump to that section we will try to learn something about the scopes in AngularJS.
  • Passing Parameters To Middleware In ASP.NET Core 2.0Nov 15, 2017. I discussed in an earlier post that it is good practice to define middleware in a separate class and add to the pipeline using extension methods. We may also need to pass information to our middleware classes though and I’ve come across two patterns for this when digging into ASP.NET Core source code and other samples online.
  • Using Optional Query Parameters With Microsoft Graph API - Part TwoNov 14, 2017. When you fire an API call to MS Graph, it will return the JSON result with all the properties. You may not need all the properties of a result set always. When you want MS Graph API to return only certain properties, then use $select parameter to specify which properties you want in result set.
  • Steps To Configure Xamarin.Android Emulator Performance - Part TwoNov 14, 2017. Xamarin is a cross-platform development tool. With Xamarin, you can use C# for iOS, Android, and Universal Windows apps. And with Xamarin Forms, interface design for all three platforms can be accomplished within its XAML-based framework.
  • Building A Questionnaire Site With Node.jsNov 14, 2017. This was our first project with Node.js, and by God, it was a pain. Node.js is an excellent framework, with blazing fast speed, and an intuitive development framework. For those who are familiar with HTML, CSS and JavaScript, Node.js is one of the best alternatives to PHP, ASP.NET or other server-side scripting languages that require a language to be learnt. Node.js is light-weight, resilient and community-led and in-development framework. This article is primarily focused on teaching the beginners in Node.js development. You can expect to learn a few basics of Node.js setup, how to manage the databases in Node.js environment and a bit more (less too, maybe).
  • Introduction To Power BI Visuals - Part Two (Stacked Column Chart)Nov 13, 2017. This is the second part of the Introduction to Power BI visuals.The main aim for this article is for the end user to learn these visuals in an easy manner.
  • Server Side Custom Paging In Angular-UI Grid Using Web APINov 13, 2017. In this article, you will learn how to implement server side custom paging using Angular UI-Grid with Web API and SQL Server database and stored procedure. In this article, I will demonstrate server side paging and sorting only, Filtering we should learn in next article.
  • Introduction To Power BI Visuals - Part Three (Clustered Column Chart And Clustered Column Chart)Nov 11, 2017. Here, I am writing the introduction series for all Power BI visuals so the end user or beginner will gain a basic idea of how visuals work During this series of Power BI visuals, we will learn about each OOTB Power BI visuals step by step. In this article we will talk about below two visuals provided by Power BI Desktop OOTB. 1. Clustered Bar Chart 2. Clustered Column Chart
  • Get Your Hands On Entity Framework Code First Workflow With New Database And Existing DatabaseNov 10, 2017. In this article we are going to learn how to create code first workflow with new database and existing database.
  • Working With View Components In ASP.NET Core MVCNov 09, 2017. View component is newly introduced feature in asp.net core MVC. It is very similar to partial view but it very powerful compared to partial view. It does not use model binding but works only with the data we provide when calling into it.
  • Using Objects Comparer To Compare Complex Objects In C#Nov 07, 2017. Objects Comparer framework provides a mechanism to compare complex objects, and allows us to override comparison rules for specific properties and types.
  • Step By Step Guide To Setup Sample SSAS Multi Dimension CubeNov 06, 2017. Create one Windows account and give full access to that account to read OLTP database or add an account on which SSAS Service is running and give full permission to that account for OLTP Database.
  • If The Boot Configuration Data For Your PC Is Missing Or Contains ErrorsNov 06, 2017. The Boot Configuration Data (BCD) is a firmware-independent database for boot-time configuration data. It is used as new Windows Boot Manager. It replaces the "boot.ini" file that was used in the old Operating System. For more details check Windows startup process.
  • How To Create A SQL Database In AzureNov 03, 2017. In this article you will see how to create an Azure SQL Database in the Azure portal. Azure SQL Database is a relational database-as-a-service which provides high performance, reliable and secure database used to build data-driven applications and websites.
  • Create An Azure SQL Database Using PowerShellNov 03, 2017. A resource group is a logical container into which Azure resources are deployed and managed as a group. So let's create a resource group for that using New-AzureRmResourceGroup command.
  • Implementation Of Stack And Queue Using Linked ListNov 02, 2017. In this article, I will be discussing two data structures - Stack and Queue and their implementation using another data structure - Linked List.
  • Populating A ListView With Data Using Kendo Listview And Entity Framework In ASP.NET MVC 5Oct 31, 2017. Here, I am going to demonstrate how to load the data from a database to Kendo listview in ASP.Net MVC5.
  • Useful URL Shortcuts For SharePoint Online - Part TwoOct 29, 2017. In this second part of URL shortcuts, I am going to write some useful URLs which will help developers or administrators perform their daily tasks in a very easy manner. As a developer these shortcuts are very useful to us. These URL shortcuts make our work faster. This article covers eight shortcut URL which we can use in our daily practice.
  • Getting Started With Azure Cosmos DBOct 29, 2017. Azure Cosmos DB is a globally distributed database service designed to enable you to elastically and independently scale throughput and storage across any number of geographical regions with a comprehensive SLA. You can develop document, key/value, or graph databases with Cosmos DB using a series of popular APIs and programming models.

About Compare-the-Schemas-of-two-Databases

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!