C# Corner

Resources  
  • Custom Model Binding In ASP.NET Core 2.0Jan 17, 2018. In an earlier post I discussed how to prevent insecure object references by encrypting the internal references (e.g. table primary keys) using Data Protection API. To avoid duplication of code that encrypts/decrypts on every controller I used filters in that example. In this post I’ll use another complimentary technique: custom model binding.
  • 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.
  • How To Create An Angular Service And Access It In Multiple ComponentsJan 10, 2018. In our previous article, we developed a single page application using Angular 4. Now in this article, we are going to talk about services.
  • Co-Authoring In SharePoint And Why Check Out A Document Is Necessary In SharePointJan 10, 2018. In this article, I will discuss co-authoring in SharePoint & why we need to check out a document in SharePoint. SharePoint is the platform where multiple users can work on the same document at the same time.Co-authoring in SharePoint helps multiple users to access a document or edit a document simultaneously.
  • How To Bind Data To A Drop-Down List And An HTML Table With *ngfor In AngularJan 07, 2018. In this article, you will learn how to bind a data to a drop-down list and to an HTML table on selected item from a drop-down list with *ngFor in Angular4.
  • Send Email With Attachment In Office 365 (SharePoint Online)Jan 07, 2018. Recently, I came up with a requirement to send an email with attachment in Office 365 (SharePoint Online). This needs to be a custom functionality wherein for each line item in a jQuery Data table (as shown in below image), user needs to send an email with an attachment to specific email address.
  • Working With Dates And Date Table In Power BIDec 29, 2017. In this article we will learn the importance of date in analytics and also how to work with dates and date table in Power BI step by step.
  • Support Multiple Languages In Xamarin.Forms ApplicationDec 27, 2017. In this article, we are going to make an application through which we can support multiple languages in our Xamarin.forms application.
  • 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.
  • 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.
  • 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.
  • Partitioning In Azure Cosmos DBDec 18, 2017. This article gives an overview of partitioning in Azure Cosmos DB. The partition key is the JSON property (or path) within your documents that can be used by Cosmos DB to distribute data among multiple partitions.
  • Uploading Attachment To The New Item On List Using “REST API” jQueryDec 18, 2017. In the previous article, we have seen how to explore multiple attachments to the new item on a list using JSOM and REST API. In this article, we will see how we can upload the documents to SharePoint list items using REST API based approach.
  • Implementing Power BI - Part 1Dec 18, 2017. Power BI is the product of Microsoft. It is used as a tool for developing and creating business analytics. It provides interactive visualizations for creating reports, charts, tables and dashboards.
  • Different jQuery OperationsDec 12, 2017. In this article, we will explore multiple ways to hide, show, and disable control. We are trying to handle multiple scenarios with their solutions.
  • How To Find Duplicate Records In SharePoint ListDec 07, 2017. In this article, we will see how to detect duplicate records in SharePoint Lists. This automation approach will be helpful in scenarios where we need to fix data duplication issues across multiple SharePoint Lists.
  • 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.
  • How To Save Multiple Links In A List Column And UI On Custom List Form In Visual Web PartDec 06, 2017. In this article, we will discuss how we are storing multiple links in the list field and supporting the UI on custom list form in Visual web part
  • 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.
  • How To Delete Attachments Of SharePoint List Item Using Rest APIDec 05, 2017. I have created a custom list named “Attachments” in the host site and have added multiple items with attachments, now let’s say that we want to “Delete” the attachments on any particular item which we want.
  • Creating A Chat Application In Node.js With Express, MongoDB, Mongoose And Socket.ioDec 05, 2017. In this article, we are going to create a chat application in NodeJS with the back end MongoDB. We will also be using Mongoose for creating the MongoDB models and Socket.io for making multi directional chats on multiple client window.
  • Show SharePoint List Item Level Attachments Using REST API And jQueryDec 05, 2017. In this article, we explore in Sharepoint 2013, how to show the Sharepoint list item level attachments using REST API and jQuery. In previous articles, I explained about adding multiple attachments to list item using html and JQuery. Now let’s use some REST API to pull these attachments and display them in list.
  • 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.
  • Routing In Suave.io - Web Development With F#Nov 29, 2017. A web application is generally composed of multiple “routes”. A route means a URL that does not necessarily map a physical file, you can use routes to define some URLs that are semantically meaningful to the user.
  • 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.
  • 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 Track Facebook Wall Messages In An Excel Table Using Microsoft FlowNov 22, 2017. Microsoft Flow is a cloud-based service. It allows us to react to an event in one and do something with the data from that event into another service. It makes it practical and simple for line-of-business. The users can build workflows that automatically do some business tasks and processes across applications and services.
  • Azure Table Storage In ASP.NET Core 2.0Nov 14, 2017. Add a class to encapsulate storage access. Add a private helper method to access storage
  • Custom Search Using Client Side CodeNov 11, 2017. The Custom Search functionality is achieved through JS. The Search produces live results for each key press. This search can be used to filter the data table or html table data dynamically based on the key words entered. The below code explains the search for html table.
  • Enums In C#Nov 09, 2017. Suppose we are creating a program in which we have to use multiple named constants of similar type and on the basis of a particular constant we have to perform some operation. So what we normally do is initialize each named constant with a value. This may require a lot of effort if the number of constants is large. Also the look and feel of the code is not up to the mark. Have a look at the below program to understand more. The program contains months of the year. We have to put lots of effort to assign each month to a value.
  • Retrieve SharePoint Lookup Field Value Via C#Nov 07, 2017. Get and set a SharePoint Lookup Field via SSOM C#. In this article, I have explained how to get & set SharePoint lookup field (single/multiple) values programmatically via Server Side Object Model in C#.
  • Binding DropDown List Using Tuple In ASP MVCNov 05, 2017. Tuple is a generic static class that was added to C# 4.0 and it can hold any amount of elements, and they can be any type we want. So using tuple, we can return multiple values.One great use of tuple might be returning multiple values from a method. It provides an alternative to "ref" or "out" if you have a method that needs to return multiple new objects as part of its response.
  • How To Use jQuery Datatable In AngularOct 24, 2017. In this article I am going to explain how to use and integrate the jQuery datatable with AngularJS. DataTables is a prebuild functionality and a plug-in for the jQuery JavaScript library. It is a highly flexible tool, based upon the foundations of progressive enhancement, and will add advanced interaction controls to any HTML table.
  • ASP.NET Core 2.0 CachingOct 12, 2017. Caching frequently used data can improve the performance of a web application. For applications hosted on multiple servers, using distributed caching means the application can access data regardless of the instance server. Caching should be considered an alternate to using Session State.
  • Excel To XML Using LINQOct 11, 2017. In this article we will show you the easiest way to convert Excel data into Xml files. There is a certain way to convert Excel file to Xml, for example using Excel Library (Com Component)
  • Shared Storage Using Azure File ServiceOct 10, 2017. In most cases, the virtual disks we are creating for an Azure VM are connected to that particular VM with a 1:1 relationship which can’t be accessed by another VM at the same time. In case you need a shared storage by multiple VMs you should use Azure File Shares. Azure File shares can be mounted concurrently by cloud or on-premises deployments of Windows, Linux, and macOS. This is mostly used in case of any requirement of something like a shared application setting or if you need to share any tools or utilities between developers and administrators.
  • Overview Of Let In LINQOct 09, 2017. In general, Let allows create a local variable at the LinQ query. Let has the same operation as to build local variable in a loop. The example with let hast better performance than the without let example, because the first execute one time and second two time for each item.
  • Installing And Using .NET 4.7.x, .NET Core 2.0, And C# 7.x With VS 2017Oct 09, 2017. This article explains how to install and use .NET Framework 4.7, .NET Framework 4.7.1 & .NET Core 2.0 and troubleshooting if you are getting an exception while installing these latest components. This article also explains how to use the different versions of C#, e.g. C# 7, C# 7.1, C# 7.2 with Visual Studio 2017 and installing multiple instances of Visual Studio 2017 side by side.
  • How To Use DataList Control In ASP.NET With Example in C#Oct 08, 2017. In this article I’ll present a tutorial with an example, a way to use the DataList control in Asp.Net for the displaying of information/ records from the database with using SqlDataSource.
  • Upload Multiple Files To SharePoint List On Single Click Using Angular And jQueryOct 07, 2017. This article explains how to upload more than one files into a SharePoint list on just single click using Angular and jQuery.
  • Develop Chatbot On NodeJS Platform Using Microsoft Bot Framework (Part Three) - Manage Conversation Using Multiple DialogsOct 03, 2017. In article Develop ChatBot On NodeJS Platform Using Microsoft Bot Framework (Part Two) - Manage Conversation Using Root Dialog, we have discussed how to handle conversation using root dialog in chatbot developed using Microsoft Bot Framework NodeJs SDK. In this article, we are going to handle the conversation flow with multiple dialogs instead of root dialog. We are also going to use trigger for dialogs.
  • TextBox Validation Client Side And Server Side In ASP.NET WebFormOct 03, 2017. Validation is main thing to process the data. We store the textbox value into database table. Before moving to storing and storing data into database first we check the value of each textbox.
  • Creating A Wave Audio Player Using WinMM The APISep 28, 2017. This is the part two of my three part trilogy concerning the use of windows mixer controls, playing an existing wave file through some available speaker, or recording and saving a wave file from an available audio input device such as a microphone. You might be wondering about the order I am presenting these tutorials. Simple, ...when my father taught me to play pool, we would often come upon a scenario where there are multiple shots available.
  • How To Implement Angular Data Table With CRUD Using ASP.NET MVC And AngularSep 22, 2017. In this article, we will discuss how to implement Angular Data Table with (Insert, Update, and Delete) Short Form (CRUD) using Asp.net MVC + Angular JS in one page without any full page reloads. This table will be similar to JQuery Data Table and this one is implemented using Angular Data table.
  • Encrypt And Decrypt User Password In SQL Server DB Using C# Winform ApplicationSep 18, 2017. In this article we are going to learn how to maintain the user login details in sql server table with password encryption format and decrypt the user password and validate the credentials in login form.
  • Multiple Pages On The Form Using Panel Control In A Simple Windows Forms ApplicationSep 15, 2017. In this article, we will learn how to show multiple pages on the form using Panel Control in a simple Windows Application.
  • Two Ways To Get Data From Entity FrameworkSep 15, 2017. In this article, you will learn about two basic ways to get data from Entity Framework and display data in angular UI-Grid using MVC application with Web API.
  • Step By Step Procedure To Create A Microsoft FlowSep 14, 2017. Microsoft Flow is a part of Office 365 suite which is a cloud-based software tool that allows users to create an automated workflow across multiple applications and services without the need for developer help. Microsoft flows is built on top logic app engine. But as this app is built for targeting business personnel, the total process is UI based. To create a flow, the user specifies what action should take place when a specific event occurs.
  • How To Insert Form Data In Multiple Table In DatabaseSep 13, 2017. In this article, we gonna learn about how to insert from data in multiple tables using jquery ajax in asp.net web application.In real time applications it is not a good practice to save all customer data in one table.They save data in multiple tables and link them using relations(using foreign keys).
  • SharePoint 2013 - On Premises - Powershell Script To Import Termsets On Given Site From .csv File In Specific FolderSep 10, 2017. In this article I’ll explain how to import multiple termsets using .CSV file from one specific folder.
  • Working With Azure Tables - Part TwoSep 09, 2017. Let us look at the basic sample, which retrieves the Azure table data into the applications using Node JS.
  • Getting Started With Azure Cosmos DB - Table APISep 08, 2017. The table is made up of one or more partitions. Partition Key and Row Key are suitable to optimize your solution. The account name, table name, and partitionkKey together identify the partition within the same storage service where your table service stores the entity.
  • Create TableView In Xamarin.iOSSep 07, 2017. In this tutorial, I am going to share how to create a table view in Xamarin IOS applications using C# and how to use navigation controller in our application.
  • How To Consume Web API Through SSIS PackageSep 07, 2017. In this article, I have illustrated the purpose of SSIS with Web API. It shows how SSIS can use Web API to do certain operations, like updating the database table based on Service response, and process the data, etc.
  • Find Out Creation And Modification Date Of Database Objects Like Tables And Stored ProceduresSep 07, 2017. Database Object refers to Table, Stored procedure, View, Function etc.; in other words, all the elements that are created for data storage and manipulation.
  • Construct Readable XML Output From SQL Query From Two Or More Tables Using “For XML PATH” StatementSep 04, 2017. In my previous article I discussed about how to get a XML format output from query and process that by using XML AUTO statement, and I give different types of “for XML”.
  • Use Of Union, Intersect, Distinct And Except In LINQSep 01, 2017. Here, you will learn the uses of Union, Intersect, Except, and their differences, To get a clear picture, we will go with examples.
  • Getting Started With Azure TablesSep 01, 2017. In this article, we will walk through some important concepts of Azure Tables through Emulator. Create the Azure Tables by using Microsoft Azure Storage Explorer.
  • Working With Azure Tables - Part OneAug 31, 2017. You will see the introduction to Azure tables, accessing the table using emulator, and managing tables manually.
  • Use Of Deferred And Immediate Query Execution In LINQAug 31, 2017. Here, you will see about query execution in linq and what is deffered query execution, what is immediate query execution and it's differences, we will see with example for better understanding.
  • How To Work With Multiple Modules In Angular v4Aug 29, 2017. In this article, we will learn how to configure Angular application using multiple module.
  • Learn About Azure Mobile ServicesAug 28, 2017. Azure mobile app service provides high scale functionality of azure app services to add sign -in, push notifications, data sync and many more. It also helps us to connect your app to many Enterprise systems. It provides a scale up facility for many customers across multiple geographies.
  • Transform XML Output Of SQL Query To HTML Using "For XML" AUTO Statement With XSLT In C#Aug 21, 2017. Normally, we execute the query using ExecuteNonQuery statement and fill the output into data table. This article describes how to transform the XML output of SQL query statements using FOR XML AUTO to HTML using XSLT.
  • Use Of Range, Repeat And Empty In LINQAug 21, 2017. Here, we are going to see the uses of the Range,Repeat and Empty keywords in LINQ and we also will discuss their differences.
  • Responsive Tables Using FootableAug 20, 2017. This article explains how to make an html table responsive using footable plugin.
  • Understand Azure Cosmos DB - Table APIAug 18, 2017. Cosmos DB is a globally distributed multi-model database. Using the API, applications running on Azure Table storage can take advantage of secondary indexes, turnkey global distribution, dedicated throughput, and single digit millisecond latency with 99.99% comprehensive SLAs.
  • Reading An Excel File Using HTML 5 And jQueryAug 18, 2017. This article explains how to export data from an Excel file to an HTML table using jQuery & HTML5.
  • Element Operators In LINQAug 17, 2017. Here, we will learn about Element Operators, their uses, and various element operators.
  • Learn Azure Blob StorageAug 11, 2017. Basically, it represents the durable store in the Azure cloud. And also, it allows storing blob, tables, messages, and queues.
  • Use Of Into And Let In LINQAug 07, 2017. Here, we going to see the uses of Into and Let keywords in LINQ and their differences.
  • Pre/Post Build Events Command Line In Visual StudioAug 02, 2017. Pre/Post build events are useful when we wish to perform some operation before/after a project is built. These operations are nothing but the Shell commands being used from the command line. A build event can be formed using a single, multiple, or conditional commands.
  • Entity Framework CRUD Operation Performed With SQL Stored Procedure Using ADO.NET Entity Data ModelJul 31, 2017. You can see my pervious article for Entity framework with Ado.Net data Model connection and how to create a new entity framework project and sql database connection maintained with created entity framework project. Also you can see how to create a class in entity framework based on data table.
  • How To Create Multi-Project Template Using Visual Studio 2017Jul 30, 2017. Visual Studio provides many inbuilt templates for creating a project. Project template will allow a developer to create new projects based on your exported project. The developer will be able to utilize your template for the new project dialog box. In this article, we can create a new project template for solution with multiple project as per your client or product requirement and use your project template for multiple developers.
  • Getting Started With The Custom Project Template Using Visual Studio 2017Jul 27, 2017. Visual Studio provides many inbuilt templates for creating a project. In this article we can create a new project template as per your client or product requirement and use your project template on multiple developers. Visual Studio provides wizards to help you generate templates from projects that are open in the integrated development environment (IDE).
  • How To Use Joins, and Group By Clause In Entity Framework With LINQ C#Jul 15, 2017. In this article will be going to learn How to use Joins, and Group By Clause in Entity Framework with Linq C#
  • SharePoint 2013 - Uploading Multiple Attachments To The New Item On List Using JSOM And REST APIJul 06, 2017. In this article we will explore how we can attach multiple attachments to the new item on list using JSOM and REST API.
  • Data Persistence Using SQLite In Xamarin.FormsJul 04, 2017. In this article, we are going to make our data persistence using SQLite in Xamarin.Forms. Firstly we will setup SQLite db for our project than make a table in it and add some data in this table. After this whenever we open our application we will see that our data is now persisted and saved in local db of application.
  • Multiple Ways To Bind Data To Kendo Grid In MVCJun 24, 2017. In this article, we will learn how to bind data to Kendo Grid in MVC using multiple ways.
  • Writing Complex Queries Using LINQ And LambdaJun 22, 2017. I am writing this article based on request by some developers regarding how to write some complex queries using LINQ & Lambda expression which consist of joins / groupby / aggregate functions
  • Learn About Bootstrap TablesJun 21, 2017. In this article we will see how to create Bootstrap tables.
  • Deploying A Virtual Network With Multiple Subnets Using Microsoft AzureJun 21, 2017. This Article shows how to create the Virtual Network and to create multiple subnets
  • Code Improvement Techniques In C#Jun 13, 2017. General code improvement technique over string.empty, string.Equals, string.Intern, StringBuilder, string.Format, case insensitive comparisons, using Block and Linq - First, FirstOrDefault, Single and SingleOrDefault. Main focus points are - what are the advantages and the purpose to use these.
  • Understanding React Components On SPFxJun 13, 2017. In this article, let us see how React JS components work along with multiple class hierarchy using SharePoint Framework components.
  • Analyzing The Size Of Database And Size Of TableMay 31, 2017. Analyzing The Size Of Database And Size Of Table.
  • Manage Your Cloud Infrastructure As Code With Terraform.ioMay 31, 2017. How to use Terraform.io to manage resources on multiple cloud platforms. Code once, deploy to many!
  • Send Email Using Templates In ASP.NET Core ApplicationsMay 30, 2017. In this article, you will learn how to send email using Email Template in ASP.NET Core Web Application. Also we will discuss how to design a custom HTML Email Template using Images, CSS and Personalized Message, and send that to multiple users in ASP.NET Core Application.
  • How To Create Multiplication Table In C# Window ApplicationMay 30, 2017. How to create multiplication table in C# Window Applications.
  • Add Table Of Contents Webpart In SharePoint Online SiteMay 23, 2017. In this article I would like to share what is Table of Contents webpart and how to add the table of contents webpart in SharePoint Site.
  • Temporary Tables And Table Variables In SQLMay 19, 2017. In this article, I will explain the difference between temporary tables and table variables in SQL server.
  • Write HTML Code In Xamarin Cross Platform With Table ExampleMay 17, 2017. You build your mobile app entirely in HTML, however those apps can suffer from performance problems when trying to accomplish complex processing or UI effects and are also limited in the platform features which they can access.
  • LINQ Basic To Advanced - MVC Demo ApplicationMay 16, 2017. Here, in this post, we are going to see some basic and advanced LINQ queries
  • ASP.NET Core Identity Tables Customization With Visual Studio 2017May 09, 2017. In this article, you will be acquainted with ASP.NET Core identity tables customization with Visual Studio 2017.
  • Column Wise Filter In Web Grid By Jquery Data TableMay 07, 2017. In this article, you will be acquainted with column wise filter in Web Grid by jQuery data table.
  • Add TOC (Table Of Contents) To Your Wordpress Posts Or PagesMay 07, 2017. In this post, we are going to a see how we can add Table of Contents to our WordPress posts and pages. Here, we are going to install a plugin to do this work. I have chosen this plugin because it is so simple and yet does the work very well. It doesn’t have more settings and features but the way it is created is 100% apt for what it is meant to be.
  • Xamarin.Forms - Design Switch Cell With Table View Application Using Visual Studio 2017May 03, 2017. This article enlightens you on designing switch cell with Table View Application, using Visual Studio 2017.
  • What Is Deferred/ Lazy Loading And Eager Loading?Apr 28, 2017. In his article, you will learn about Deferred/ Lazy Loading and Eager Loading.
  • Update And Delete Row From Multi-Table Base Select View With MVC 5.0Apr 28, 2017. This article familiarizes you with how to update and delete row from Multi-Table Base Select View with MVC 5.0.
  • Table View In Xamarin.FormsApr 28, 2017. In this article, you will learn about Table View In Xamarin.Forms.
  • A Brief Introduction To LINQApr 27, 2017. Introduction to LINQ.
  • LINQ Extended JoinsApr 24, 2017. This article illustrates LINQ extended joins.

About LINQ-for-Multiple-Tables

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!