Resources  
  • Leveraging Compiled Queries for Enhanced Performance in LINQMar 09, 2024. Compiled queries in LINQ allow developers to pre-compile LINQ queries into executable delegates, reducing the overhead of query compilation and optimization. By caching the compiled query execution plan, compiled queries improve the performance of frequently executed or complex queries in C# applications.
  • Misconceptions About the Four LINQ methodsMar 09, 2024. Misconceptions about the four LINQ methods. Single(), SingleOrDefault(), First(), and FirstOrDefault(). This article addresses misconceptions surrounding four LINQ methods—Single(), SingleOrDefault(), First(), and FirstOrDefault(). Clarifying differences and potential pitfalls helps prevent null references and invalid operator exceptions in code.
  • What is New in .NET 9Mar 04, 2024. .NET 9, succeeding .NET 8, places particular emphasis on cloud-native applications and enhancing performance. It will receive standard-term support (STS) for 18 months.
  • Why we should learn C#?Feb 26, 2024. This article explores the reasons behind choosing C# over other languages, delving into its evolution, key features like object orientation, lambda expressions, LINQ, generics, and its adaptability for modern development needs.
  • What are Higher-Order Components in React.jsFeb 22, 2024. Higher-order components (HOCs) in React.js enable reusable logic by creating functions that enhance components. Understand their role, advantages, and usage with a detailed explanation and practical example.
  • What is a Wrapper Component in React?Feb 09, 2024. Wrapper components in React.js refer to components that encapsulate other components or elements within them. They are commonly used for various purposes such as styling, behavior modification, context management, implementing Higher-Order Components (HOCs).
  • What is Components in ReactFeb 05, 2024. Explore React.js components, the core building blocks of React applications. Learn about six types of components: Functional, Class, Pure, High Order, Controlled and Uncontrolled.
  • Smart Sorting: Finding the Middle Number of Two Ordered ListsDec 11, 2023. Efficient C# code uses a binary search approach to find the median of two sorted arrays. The algorithm intelligently partitions arrays, ensuring logarithmic runtime complexity (O(log(min(m, n)))).
  • Sorting Arrays in C#Nov 24, 2023. This article guides us through sorting arrays in C# using the Array.Sort() method and LINQ queries. It covers both ascending and descending orders, providing code snippets for clarity.
  • Difference Between Concurrency and Parallelism in C#Nov 09, 2023. The article you provided gives a comprehensive overview of the concepts of concurrency and parallelism and their relevance in C# programming. It highlights the distinctions between the two concepts and provides clear examples and use cases for each. The discussion of best practices and considerations for managing concurrency and parallelism effectively is a valuable addition, as it helps developers avoid common pitfalls and make informed decisions when implementing these concepts in their applications.
  • Pagination in SQL ServerOct 09, 2023. Pagination is the process of dividing large data into smaller data sets in discrete pages. It is widely used in web applications.
  • Why Ignoring Your Order Numbers Could Be A Costly OversightOct 03, 2023. This article is about how Order No can reveal the vital information of a company, and how programmer can help to protect it
  • Understanding LINQ in C#: Query Syntax and Method SyntaxOct 03, 2023. This article is an informative and in-depth exploration of LINQ (Language Integrated Query) within the context of C#, a widely used programming language in the software development industry. The guide delves into both the query syntax and method syntax aspects of LINQ, providing readers with a thorough understanding of how to effectively use LINQ to query and manipulate data in C# applications.
  • Understanding LINQ in .NETSep 11, 2023. LINQ, or Language Integrated Query, is a powerful feature in the .NET framework that simplifies data querying and manipulation in C# and VB.NET applications. It provides a uniform and SQL-like syntax for querying data from various sources, including in-memory collections, databases, XML, and more.
  • Exploring the Diverse Flavors of LINQ with ExamplesAug 22, 2023. LINQ is a powerful feature in modern programming languages like C# that allows developers to perform queries on different types of data sources using a consistent syntax. With LINQ, you can query and manipulate data without worrying about the underlying data source, whether it's an in-memory collection, a database, or XML
  • Types of Functions in JavaScriptAug 17, 2023. Explore various JavaScript functions in this article: Named, Anonymous, Arrow, IIFE (Immediately Invoked Function Expression), Higher-Order, and Constructor Functions. Simplified explanations and examples for each type are provided.
  • Using the OrderBy and OrderByDescending Operator in LINQAug 08, 2023. Using the OrderBy and OrderByDescending Operator in LINQ: Sorting Collections
  • Learn About Programming Logic And LINQJul 25, 2023. In this article, you will learn about the basics of programming logic.
  • EF Core in .NET 7 APIJul 13, 2023. Using EF Core in .NET 7 API
  • C# LINQ With Select and SelectMany OperatorJul 10, 2023. C# LINQ with select and select many operator
  • How To Use Order By in MySQLJun 23, 2023. Order by is a useful feature in MySQL that allows you to sort query results based on one or more columns in ascending or descending order. In this article, we will discuss how to use order by in MySQL with step-by-step examples.
  • LINQ MethodsJun 16, 2023. Linq Methods
  • Difference between IQueryable, IEnumerable, IList and ListJun 12, 2023. when to use what IQueryable, IEnumerable, IList and List
  • Order of SQL ExecutionApr 16, 2023. In this article we are going to learn about the Order of the SQL execution
  • LINQ (Language Integrated Query) Jan 31, 2023. In this article, you will learn about LINQ (Language Integrated Query).
  • Find Blank Column Using LINQ In UiPath Jan 03, 2023. In this article, you will learn how to find blank column Using LINQ in UiPath.
  • Difference Between Single Vs SingleOrDefault And First Vs FirstOrDefaultNov 28, 2022. In this article, you will learn about the Difference Between Single Vs SingleOrDefault And First Vs FirstOrDefault.
  • Reverse Words In A String In C#Nov 07, 2022. Given a string s, reverse the order of characters in each word within a sentence while still preserving whitespace and initial word order.
  • How To Add Custom Add-Ins To MS WordOct 07, 2022. This article shows you how to add add-ins to word desktop.
  • How To Add Add-Ins In PowerPoint Sep 20, 2022. In this article, you will learn how to add custom add-ins.
  • LINQ Partitioning Operators - Take, TakeWhile, Skip & SkipWhileSep 13, 2022. Take, TakeWhile, Skip and SkipWhile are called Partitioning Operators and we’ll discuss and investigate them. Not only that we’ll also see an equivalent loop construct to appreciate where these operators derived.
  • How To Deploy Excel Add-ins To Your OrganizationAug 12, 2022. This article show you how to deploy excel add-ins in your organization.
  • How To Add Custom Add-Ins To ExcelJul 05, 2022. In this article, you will learn how to add Excel add-ins.
  • How To Deploy PowerPoint Add-ins To Your OrganizationJun 15, 2022. This article shows you, how to deploy PowerPoint add-ins.
  • How To Deploy Word Add-Ins To Your OrganizationJun 03, 2022. This article show you how to deploy word add-ins to your organization.
  • How To Create Excel Add-InsMay 10, 2022. in this article i will show you how to create Excel Add-ins
  • How To Create PowerPoint Add-InsApr 04, 2022. in this article, I will show you how to create PowerPoint Add-ins
  • How To Deploy Outlook Add-ins To Your OrganizationMar 19, 2022. This article provides a comprehensive guide on deploying Outlook add-ins to organizations for other users. It covers the step-by-step process of deploying add-ins using Office 365, ensuring easy access for users within the organization.
  • How To Publish Outlook Add-Ins Using Visual Studio CodeMar 17, 2022. In this article, you will learn how to publish outlook add-ins using visual studio code.
  • How To Create Word Add-InsMar 16, 2022. in this article I will show you how to create word add-ins.
  • Awesome LINQ Features In .Net 6Feb 21, 2022. In this article, you will learn about awesome LINQ features in .Net 6.
  • Awesome LINQ Impovements In .NET 6.0Jan 20, 2022. These are the articles for to show the LINQ improvements in .NET 6.
  • How to Convert an Array to a List in C#?Jan 13, 2022. Converting an array to a list in C# involves transforming the data structure from an array, which has a fixed size, into a list, which can dynamically adjust its size. This process is essential when flexibility in modifying the collection is needed. In C#, this can be achieved using the `ToList()` method provided by LINQ (Language Integrated Query) or by using the `List<T>` constructor, passing the array as an argument. Both approaches enable seamless conversion, allowing for easier manipulation and utilization of the collection's elements. This guide provides insights into the step-by-step process of converting an array to a list, emphasizing its utility and demonstrating practical use cases.
  • Advanced Entity Framework Core - Output EF SQL Queries To The Console And Tips To Setup Dbcontext With The Development In MindJan 10, 2022. When you work with abstractions over SQL Database you may be wondering what does Entity Framework constructs from your Linq queries. To get a clue on it here are 3 options. Tips to setup DbContext with the development in mind for development purposes, you may sometimes decide to use an in-memory database for all environments including production, you may set up HealthChecks, below shows how to add health checks for the DbContext also for the development environment good to have set o.EnableDetailedErrors(); and o.EnableSensitiveDataLogging(); ?to manipulate with all these options you may consider adding configuration options
  • Pandas - Investigating Pipe FunctionDec 31, 2021. The article explains the pipe function in Pandas, the ‘pipe’ function is a very useful function through which we can chain multiple processing operations into one.
  • Order Of Constructors Calling With Inheritance In C#Dec 29, 2021. In this article, you will learn about Order of constructors calling with inheritance in c#.
  • How To Change The Tools Order In Dynamics 365 CE XrmToolBoxDec 06, 2021. In this article, you will learn how to change the Tools order in Dynamics 365 CE XrmToolBox.
  • Working With Temporal Tables In EF Core 6.0Dec 06, 2021. Get started with creation of SQL Server Temporal Tables using Entity Framework Core 6.0 Code First approach and querying the historical data using LINQ.
  • Collection Performance - How Do You LINQ?Dec 04, 2021. In this article, you will learn how do you LINQ?
  • How To Create Outlook Add-insNov 24, 2021. In this article, you will learn how to create outlook Add-ins.
  • Higher-Order Components In ReactAug 17, 2021. In this article, you will learn about Higher-Order components and how to implement it in React applications.
  • SQL - Order By ClauseJun 15, 2021. In this article, you will learn about SQL "Order By" Clause.
  • Higher Order Components In ReactjsMar 24, 2021. In this article, you will learn about Higher Order Components in Reactjs.
  • Calculate The SUM Of The DataTable Column In C#Jan 25, 2021. In this article, I am going to explain how to calculate the sum of the DataTable column in ASP.NET using C#. Here, I'll also explain what a DataTable is in C#, as well as different kinds of ways to calculate the sum of the DataTable column, like using the compute method of a DataTable as well as using LINQ.
  • Updating Display Order In Database With Drag And DropJan 21, 2021. In this article i have explained how to manage display order with drag and drop server side.
  • ASP.NET Web API 2 In MVC 5 Using C# With ExampleJan 11, 2021. in this article, I am going to explain how to create and access the Web API 2 in the ASP.NET MVC 5 application using C# and bootstrap with Example. Here I'll also show you how to create the step by step Web API 2 in ASP.Net MVC 5 Using C# and bootstrap with the simple example, In this tutorial, you will use ASP.NET Web API 2 to create a web API and that returns a list of employees.
  • Create An Ordering System Using Laravel, RabbitMQ, And TwilioDec 28, 2020. By the end of this article, you will be able to create a web application using PHP which will be able to store the message in the queue and will be able to send messages to the users on their phone.
  • Overview Of Yeoman Generator For Office Add-insDec 08, 2020. In this article, you will learn about the Overview of Yeoman Generator for Office Add-ins.
  • Standards In Defining The AutoMappersOct 04, 2020. This article describes the tips or standards in defining mapping profiles.
  • Using LINQ Expressions In C#Sep 18, 2020. In this article, you will learn how to use LINQ Expressions in C#.
  • Understanding Middleware In ASP.NET CoreSep 02, 2020. In this article, you will learn about Middleware in ASP.NET Core.
  • LINQ QueriesSep 02, 2020. In this article, you will learn about LINQ Queries.
  • Optimizing LINQ Queries In C#.NET For MS SQL Server Aug 13, 2020. In this article, you will learn about some aspects of LINQ query optimization for MS SQL Server.
  • JavaScript Functions vs LINQ C#Jul 05, 2020. This is a comparison between Javascript functions and LINQ in C# for collections.
  • Multi-Select Dropdown With Checkboxes Using jQuery In MVCJun 09, 2020. This article is about creating a multi-select dropdown with CheckBoxes in MVC by using Jquery on a country sample data. This kind of scenario is taken on applications such as on insurance domain. When a customer needs to be provided with travel or health insurance from the origin to the destination country, or if the person is traveling to multiple destinations.
  • EF Core - SELECT DISTINCT on a Few Columns OnlyApr 26, 2020. In this article, you will learn about implementing EF Core - SELECT DISTINCT on selected columns only.
  • Efficient Data Modification with Entity Framework CoreApr 16, 2020. In this article, you will learn about efficient data modification with Entity Framework Core.
  • Develop Outlook Add-ins with SharePoint FrameworkFeb 25, 2020. In this article, you will learn how to develop Outlook Add-ins with SharePoint Framework.
  • Create And Deploy Outlook Add-Ins Using SPFx 1.10Feb 04, 2020. Create And Deploy Outlook Add-Ins Using SPFx 1.10" is a guide for integrating custom functionalities into Microsoft Outlook using SharePoint Framework (SPFx) version 1.10. It offers insights into developing, deploying, and managing Outlook add-ins within the Microsoft 365 ecosystem.
  • SQL SELECT ORDER BY StatementJan 07, 2020. In this article, we will discuss SELECT ORDER by a statement
  • Basic Concepts About LINQ In C#Oct 15, 2019. In this article, you will learn some basic concepts about LINQ in C#.
  • Higher Order Component In ReactAug 08, 2019. This article unravels the concept of Higher-Order Components in React and their usage.
  • SharePoint Integration For Work Order - Part TwoJul 22, 2019. This is the second part of the SharePoint integration for Work Order entity.
  • SharePoint Integration For Work Order - Part OneJul 09, 2019. This article is about using out of the box SharePoint integration for Work Order entity from Field Service.
  • How to Sort Two-Dimensional Array in C# by Selected Column Index in Selected Column Sort OrderJul 08, 2019. In this article, we will learn about a program for sorting a two-dimensional array ( M x N ) by column X in selected sort order, then by column Y in selected sort order, and then by column Z in selected sort order … then by column N in selected sort order.
  • Dynamic Sorting (OrderBy) Based On User PreferenceJun 21, 2019. In this article, I am going to demonstrate how we can sort the data based on user preference.
  • How To Use Extensions For LINQ - C#May 20, 2019. In this tutorial, we will learn how to use extension methods with LINQ in C# to simplify the coding.
  • Features Of Entity Framework Core 2.1 - Better Column Ordering In Initial MigrationApr 11, 2019. This article discusses the new features added in Entity Framework Core 2.1.
  • LINQ For BeginnersApr 10, 2019. LINQ stands for Language Integrated Query. In this article, we will dive deep into the basics of LINQ.
  • Increase Performance Of LINQ By ParallelismApr 09, 2019. Parallelism solves many problems in the computing world if done in the right way; parallelism is not good if the task is small and needs synchronization of resources, such a scenario would hurt performance.
  • Working With Multiple Tables Using LINQ Join In MVCFeb 22, 2019. In this article, we will learn how we can join multiple tables using LINQ and display records in a View. We will learn everything in a step by step manner.
  • All About IEnumerable and IQueryableFeb 12, 2019. When we talk about LINQ, we consider two collections, IEnumerable and IQueryable. In this article, we will learn all about IEnumerable and IQueryable, except how they are evaluated. Possibly, I will cover that in the next article to strengthen our basic understanding.
  • Difference Between IQueryable, IEnumerable, And IList In LINQFeb 09, 2019. This article explains how to work with IQueryable and IEnumerable and IList in LINQ. Also, it tells when to use IQueryable and IEnumerable in real-time scenarios.
  • Create Year Quarter Month Drill Down With Proper Sort Order In Power BIOct 22, 2018. In this article, we will learn how we can apply Year Quarter Month Drill down with Proper Sort Order. Power BI OOTB Slicer is easy to use. But it is something, in which we are using our columns to prepare the drill down.
  • How To Use Join Operations With Database Using LINQAug 16, 2018. In this article. I will demonstrate how we can perform join operation with SQL database using Language-Integrated Query (LINQ).
  • LINQ Extension Methods - Partitioning Operator - Part FourAug 16, 2018. This article is continuation of Linq extension methods. In this article I am going to demostrate partitionaning operators like skip, skipWhile, take and TakeWhile.
  • How To Use Join Operation With Multiple SQL Database Tables Using LINQAug 14, 2018. In this article, I will demonstrate how we can perform join operation with multiple SQL database tables using Language-Integrated Query (LINQ).
  • LINQ Extension Methods - Element Operator And Set Operator - Part ThreeAug 14, 2018. In this article, we are going to explore another two operators like element operator and set operators. Element operators are used to returning the particular element from the collection and set operators like distinct, excepts, Intersect and union which are used to get the unique element or all element from a single collection or multiple collections based on specific condition or based on our requirement.
  • How To Use Data Filtering Operations With Database Using LINQAug 09, 2018. In this article. I will demonstrate how we can use Where and OfType operator of Language-Integrated Query (LINQ).
  • LINQ Extension Methods Quantifier And Aggregation Operator - Part TwoAug 08, 2018. This article is continuation of Linq extension methods. If you want to read first part please click here Part One. In this article I will demonstrate quantifier operator and aggregation operators.
  • How To Use Aggregation Operations With Database Using LINQAug 08, 2018. In this article. I will demonstrate how we can use Sum, Min, Max Count, Average, LongCount, Aggregate operator of Language-Integrated Query (LINQ). Sum, Min, Max Count, Average, LongCount, Aggregate operators are part of aggregation operation in Language-Integrated Query (LINQ).
  • How To Use Grouping Data Operations With Database Using LINQAug 07, 2018. In this article, I will demonstrate how we can use GroupBy and ToLookup operator of Language-Integrated Query (LINQ). GroupBy and ToLookup operators are part of grouping data in Language-Integrated Query (LINQ). Grouping refers to the operation of putting data into groups so that the elements in each group share a common attribute. GroupBy & ToLookup return a collection that has a key and an inner collection based on a key field value. The execution of GroupBy is deferred whereas that of ToLookup is immediate. A LINQ query syntax can be end with the GroupBy or Select clause.
  • How To Use Data Partitioning Operations With Database Using LINQAug 05, 2018. In this article, I will demonstrate how we can use skip, SkipWhile, take, TakeWhile operator of Language-Integrated Query (LINQ). Skip, SkipWhile, take, TakeWhile operators are part of partitioning data in Language-Integrated Query (LINQ).
  • LINQ Extension Methods - Part OneAug 05, 2018. This article explains linq extension methods like filtering, grouping and sorting and projection orators
  • How To Use Data Sorting Operations With Database Using LINQAug 05, 2018. In this article, I will demonstrate how we can use OrderBy, OrderByDescending, ThenBy, ThenByDescending and Reverse operator of Language-Integrated Query (LINQ). OrderBy, OrderByDescending, ThenBy, ThenByDescending and Reverse operators are part of sorting data in Language-Integrated Query (LINQ).
  • An Overview Of LINQ To SQLAug 03, 2018. LINQ to SQL is a mapping between the Relational Database Schema and Objects. The relational data can be manipulated using LINQ by its mapped objects. When an object is linked to relational data, it receives attributes of the relational data. The mapping is done by translating the relational database schemas into object definitions and this can be done automatically by using the LINQ to SQL Tools in Visual Studio which is called Object Relational Designer (O/R Designer).
  • How To Implement Paging Using Skip And Take Operators In LINQAug 03, 2018. In this article, I will demonstrate how we can use skip and take operator of Language-Integrated Query (LINQ) for implementation of paging in C# programming. Skip and take operators are part of partitioning data in Language-Integrated Query (LINQ).
  • Introduction To LINQ And LINQ SyntaxesJul 20, 2018. In this article, we will discuss on the introduction to LINQ And LINQ syntaxes.
  • Install add-ins In SharePoint Using Office 365 CLIJun 14, 2018. I describe how to move SharePoint add-ins to app catalog and install using Office 365 CLI
  • How To Register/ Unregister SharePoint Add-Ins Using PowerShellJun 04, 2018. Suppose you would like to have the remote components of a provider-hosted SharePoint Add-in to interact with SharePoint, what should you do? You should first register with the Azure ACS cloud-based service and the SharePoint App Management Service of the tenancy or farm. Let us now dive straight into how to register/unregister SharePoint add-ins.

About order-in-linq

NA

OUR TRAINING