Resources   No resource found

• Mastering LINQ in C#Jun 25, 2025. Language Integrated Query (LINQ) is a game-changer in C#. It brings SQL-like data querying capabilities directly into your C# code, making data manipulation more intuitive, type-safe, and readable.
• Understanding Select vs SelectMany in LINQJun 19, 2025. In this article, we are going to learn about the importance of LINQ features of select and SelectMany and the difference between them.
• FirstOrDefault vs. SingleOrDefault in LINQ: Key Differences and Use CasesJun 16, 2025. In this article, we'll dive into the key differences between FirstOrDefault and SingleOrDefault, examining their behaviours, ideal use cases, and guidance on when to use each one. By the end, you'll gain a better understanding of how to utilize these methods to optimize data queries in your C# applications.
• PLINQ vs LINQ: Use Cases, and Performance Insights in C#May 25, 2025. Discover the key differences between LINQ and PLINQ in C#, including their syntax, execution models, performance benchmarks, use cases, and when to choose parallelism for processing large datasets efficiently.
• Combining and Merging Datasets with PT-SLMs for BusinessMay 16, 2025. Private Tailored Small Language Models (PT-SLMs) help businesses unify complex datasets by understanding context and semantics, reducing manual work, improving data accuracy, and enabling smarter analytics and decision-making.
• How to Convert a DataTable to a List of Objects in C#Apr 27, 2025. Learn how to convert a DataTable to a List<T> in C#. Explore manual, reflection-based, and LINQ methods for better performance, type safety, and cleaner code. Improve maintainability in modern C# applications.
• Splitting Of Datasets in Machine LearningApr 23, 2025. Splitting datasets is vital in machine learning to test model accuracy on unseen data. Common methods include train-test split, k-fold cross-validation, stratified k-fold, and time series split.
• Order of Execution in LINQ QueriesApr 22, 2025. This article explains the difference between deferred and immediate execution, outlines the execution order, and shares best practices to write efficient and optimized LINQ queries for real-world applications.
• LINQ in C# Tutorial for Beginners: 101 C# LINQ OperationsApr 17, 2025. Learn LINQ in C# with 101 essential operations for beginners. Simple examples of filtering, sorting, and joining data to make your code better and faster. Perfect for new C# developers.
• .NET 8 - System.Linq.Dynamic.Core – using SQL LIKEApr 11, 2025. System.Linq.Dynamic.Core library does not support SQL LIKE, and I added support for it. Added SQL LIKE support to the System.Linq.Dynamic.Core in .NET 8 using a custom patch. Enables dynamic SQL pattern matching in EF8 projects where built-in LIKE functionality was missing.
• New LINQ Features in .NET 9Mar 29, 2025. Discover the latest LINQ features in .NET 9 that enhance query performance, simplify data manipulation, and introduce new methods for better efficiency.
• Exploring PLINQ (Parallel LINQ) for Parallel ProcessingMar 29, 2025. PLINQ (Parallel LINQ) is a powerful feature in .NET that enables parallel processing of queries to improve performance on multi-core processors.
• Understanding Expressions in C#: Dynamic Code and Query GenerationMar 19, 2025. Expressions in C# allow dynamic query generation, runtime compilation, and code transformation using Expression Trees. They are widely used in LINQ, ORM frameworks like Entity Framework, and reflection to optimize performance and enable flexible, data-driven logic.
• Learn C#: Refactor CodeMar 18, 2025. Refactoring in C# enhances code readability, maintainability, and performance by eliminating redundancy, utilizing LINQ, extracting methods, applying null-coalescing operators, and implementing async/await patterns.
• Select vs SelectMany in C# LINQMar 17, 2025. In C# LINQ, Select transforms each element of a collection individually, maintaining the original structure, while SelectMany flattens nested collections into a single sequence, combining all sub-elements.
• Working with Dataset Data in ASP.NET GridViewMar 08, 2025. This article covers data binding, displaying records, sorting, paging, and editing in GridView. Understand how to fetch data from a database, manipulate it using DataTables, and present it efficiently using ASP.NET GridView for a seamless user experience.
• Various Methods to Count Occurrences of Each Number in Array or ListFeb 17, 2025. In this article, I'll show you different ways to count how often a number appears in C#. We'll look at methods like LINQ, Dictionary, GroupBy, and Parallel.ForEach, and see which ones work best for small and large datasets.
• Learn Quantifier Operations in LINQ Jan 21, 2025. Quantifier operations in LINQ simplify logical evaluations of collections using methods like `Any`, `All`, and `Contains`. They enhance readability, reduce boilerplate, and support efficient data validation and filtering.
• New LINQ Methods in .NET 9: Index, CountBy, and AggregateByDec 11, 2024. In this article, I will showcase the new methods: Index, CountBy, and AggregateBy. These powerful additions in .NET 9 bring significant enhancements to LINQ, aimed at improving your coding experience and simplifying data manipulation tasks.
• C# Foundation - Implicitly Typed VariablesNov 28, 2024. Implicitly typed variables in C#, declared using the var keyword, let the compiler infer the data type from the initialization expression. This improves code readability and reduces verbosity, especially with complex types.
• .NET 9 CountBy: A New LINQ PowerhouseNov 20, 2024. .NET 9 introduces the CountBy method, a powerful addition to LINQ that enhances querying capabilities. This feature allows developers to count elements based on specified conditions efficiently.
• Understanding IEnumerable In C#Nov 14, 2024. IEnumerable in C# is an interface that defines a standard way to iterate over a collection of objects. The IEnumerable interface in C# provides a standard, efficient way to iterate over collections using foreach, enabling cleaner, more readable code, and LINQ integration.
• Creating a CQRS Architecture in .NET Core 8Nov 04, 2024. This guide outlines a practical implementation of the CQRS (Command Query Responsibility Segregation) architecture using C# and MediatR, emphasizing the separation of read and write operations for better scalability and maintainability.
• How Select and SelectMany Works in C#Oct 26, 2024. Learn key differences, practical use cases, and examples that demonstrate how these methods simplify data manipulation, making it easier to work with nested and complex data structures in C#.
• Getting Started with Databrick DatasetOct 19, 2024. This article dives into how to use databricks preloaded datasets. Databricks Datasets provide ready-to-use, real-world data built into the Databricks platform, enabling users to easily access, analyze, and refine machine learning, big data, and data science projects seamlessly.
• How Func Delegates Work in LINQSep 27, 2024. In this article, we explore how Func delegates operate within LINQ (Language Integrated Query) in C#. Func delegates enable concise and powerful data manipulation by allowing developers to pass methods as parameters.
• Solid Introduction to Expression Trees in C#Sep 26, 2024. This article provides a comprehensive introduction to Expression Trees in C#. You'll learn about their structure, how they represent code as data, and their applications in LINQ queries.
• Exploring the Performance Boosts in .NET 9Sep 20, 2024. .NET 9 introduces key performance improvements, including Native AOT for faster startup times and reduced memory usage, optimized garbage collection, enhanced threading for multicore systems, and HTTP/3 support for improved network performance.
• POCO to Dictionary Conversion Techniques in C#Sep 16, 2024. This article explores five methods for converting a C# POCO to a dictionary using reflection, LINQ, JSON libraries, and ExpandoObject, comparing their performance through Benchmark.NET to find the best approach.
• Dynamic LINQ with Gridify in .NETAug 30, 2024. Learn how to leverage Gridify to simplify complex filtering, sorting, and pagination tasks. Perfect for developers seeking to optimize and extend their use of LINQ in C# applications.
• Crafting Efficient and Maintainable C# CodeAug 28, 2024. This guide explores essential C# best practices for robust, maintainable code. It covers using meaningful variable names, following naming conventions, handling null values, and using var judiciously.
• Implementing Pagination for Large Datasets in Java Web ApplicationsAug 22, 2024. This guide demonstrates how to implement pagination in a Java web application using JSP and Servlets. It covers setting up a data source, handling pagination logic in a servlet, and displaying data with pagination controls in a JSP page.
• How to Show Direct Binary Image Using Handler in ASP.NET WebFormsAug 09, 2024. Learn how to display images stored as binary data in a database using an HTTP handler in ASP.NET WebForms. This guide covers creating a database table, a stored procedure for image retrieval, and implementing an HTTP handler to serve images dynamically. It also includes integrating the handler into a web form.
• Learn About .NET 9 LINQ EnhancementsAug 05, 2024. In .NET 9, two new LINQ methods enhance code simplicity and readability: .CountBy and .AggregateBy. .CountBy counts elements by key, simplifying grouping and counting tasks. .AggregateBy streamlines aggregation operations, reducing complexity.
• LINQ Best PracticesAug 01, 2024. Discover essential LINQ best practices for writing efficient, readable, and maintainable code in C#. Learn tips on query and method syntax, performance optimization, and effective use of lambda expressions and extension methods to enhance your .NET applications and streamline data querying.
• Understanding of LINQJul 28, 2024. LINQ (Language Integrated Query) is a powerful feature in .NET that allows developers to write SQL-like queries directly in C# or VB.NET. It supports querying collections, XML, databases, and more, using a syntax that integrates seamlessly with the language.
• LINQ to ADO.NET: Enhancing Data Access with Modern QueryingJul 23, 2024. In the evolving world of .NET, querying databases has traditionally been done using ADO.NET, which provides a robust set of classes for data access. However, the introduction of Language Integrated Query (LINQ) has revolutionized the way developers interact with data.
• Optimizing LINQ Performance with Compiled Queries in .NETJul 22, 2024. Compiled queries in LINQ (Language Integrated Query) are a powerful feature that can significantly improve the performance of your data access code, especially when dealing with repetitive queries.
• Using DataAdapters and DataSets in .NETJul 22, 2024. In .NET, working with databases often involves handling disconnected data scenarios where data is fetched, manipulated, and then updated back to the database. Two essential components for managing such scenarios are DataAdapter and DataSet.
• Practical approach to EF Core with Scalar functionsJul 21, 2024. Learn how to implement and migrate scalar SQL functions in an ASP.NET Core application using Entity Framework Core. This guide covers creating a scalar function to calculate total unit prices, integrating it into EF Core, and calling it within LINQ queries to streamline database interactions.
• Programming in Practice - LINQ to SQL - ExplainedJul 18, 2024. Discover the power of LINQ to SQL in this comprehensive guide. Learn how to seamlessly integrate LINQ queries with SQL databases using the .NET framework. From setting up your environment to executing complex queries, this tutorial covers it all.
• Differences Between IEnumerable and IQueryable in C#Jul 17, 2024. Explore the nuances between IEnumerable and IQueryable in C#. Understand how these interfaces differ in data retrieval and manipulation, with a focus on performance implications and suitable use cases.
• Discard Variable in C# .NETJul 17, 2024. The discard variable (_), introduced in C# 7.0, allows developers to ignore values intentionally. It enhances code clarity by signaling unused data in tuples, pattern matching, out parameters, and LINQ queries, promoting cleaner, more efficient, and maintainable programming in .NET applications.
• Using Find Instead of FirstOrDefault with Collections in C# .NETJul 15, 2024. When working with collections in C# .NET, FirstOrDefault and Find serve similar purposes of retrieving elements based on conditions. FirstOrDefault is versatile for any IEnumerable<T>, while Find is optimized for List<T>, offering potentially better performance in list operations.
• Understanding LINQ While Writing Your OwnJul 03, 2024. LINQ (Language-Integrated Query) in .NET offers a unified, declarative way to query diverse data sources like objects, databases, XML, and more. It simplifies data manipulation with methods like Where, Select, and GroupBy, supporting both query and method syntax.
• Mastering LINQ: TakeWhile and SkipWhile in C# .NETJul 01, 2024. Explore LINQ's TakeWhile and SkipWhile methods in C#, which enhance data querying by conditionally including or excluding elements based on predicates. Learn how to use these powerful methods to process collections effectively, with detailed examples demonstrating their functionality and practical applications.
• Optimizing LINQ Queries in C# and .NET Core Web APIsJun 21, 2024. LINQ in C# optimizes data querying with readable syntax, but inefficient use can impact .NET Core Web API performance. Strategies like early filtering and selective projections enhance efficiency. Deferred execution via IQueryable delays query execution, optimizing database interactions.
• Lazy Loading (4): EntityFrameworkJun 21, 2024. This article will discuss lazy loading in Entity Framework. This article series explores Lazy Loading, focusing on its application in various technologies like LINQ, HTML, JavaScript, Entity Framework, and Angular, providing insights and performance considerations.
• LINQ vs PLINQ Method Syntax for Efficient C# .NET Data ProcessingJun 17, 2024. LINQ (Language Integrated Query) and PLINQ (Parallel LINQ) are .NET frameworks for querying data. LINQ offers a declarative syntax for querying various data sources with single-threaded execution, while PLINQ extends LINQ by enabling parallel execution.
• Relations between Dataset in DBMSJun 12, 2024. A relationship in DBMS links two or more data sets. This article explores types of relationships: one-to-one, one-to-many, and many-to-many, and their implementations in databases.
• C# Comparison Fundamentals: Best Practices and TipsJun 11, 2024. Comparison operations are a fundamental aspect of programming in C#. Whether you're comparing primitive types, strings, or objects, or handling null values, understanding the nuances of comparison can enhance both the performance and readability of your code.
• Understanding Single, SingleOrDefault, First, and FirstOrDefault in LINQ .NET C#Jun 07, 2024. LINQ (Language Integrated Query) provides powerful querying capabilities in C# to manipulate data collections. Among its arsenal of operators, Single, SingleOrDefault, First, and FirstOrDefault are frequently used to retrieve elements from sequences.
• Working with RDDs, DataFrames, and Datasets in Apache SparkMay 31, 2024. Apache Spark's core components: RDDs, DataFrames, and Datasets. Learn how to efficiently process and analyze large-scale data using Spark's robust distributed computing capabilities.
• LINQ Query Syntax vs Method Syntax in Entity FrameworkMay 29, 2024. Choosing between LINQ Query Syntax and Method Syntax in Entity Framework depends on various factors. Query Syntax often resembles SQL, making it more intuitive for those with SQL background, while Method Syntax offers more flexibility with lambda expressions and method chaining.
• Lazy Loading (2): HTMLMay 29, 2024. This series explores Lazy Loading within the LINQ category, focusing on dynamically loading images in HTML to enhance page load times, featuring code examples and demos for practical application.
• Multiple OrderBy Operations in Entity FrameworkMay 27, 2024. Entity Framework (EF) is a powerful ORM (Object-Relational Mapper) in .NET that allows developers to work with databases using .NET objects. In EF, this can be achieved using OrderBy, ThenBy, OrderByDescending, and ThenByDescending methods in LINQ queries.
• Data Pagination with Extension Methods in C#May 20, 2024. Pagination is a common technique used to manage and display data in chunks. This article discusses implementing pagination in C# using extension methods, which allow adding new functionality to existing types without modifying their source code, making data handling clean and reusable.
• Programming in Practice - Structural DataMay 19, 2024. In object-oriented programming, the basic way to create structural data is to define custom types and interconnect them using references. Let's analyze this case using sample code in the context of intentionally programmed relationships between items.
• Train and Validate Datasets in Machine LearningMay 13, 2024. In machine learning, where algorithms are trained to learn patterns from data and make predictions or decisions, the role of datasets cannot be overstated. In this article, we explore the significance of train and validate datasets.
• Unlocking Performance: Exploring PLINQ in .NET C#May 08, 2024. In today's computing landscape, where multi-core processors are ubiquitous, optimizing the performance of your applications often involves leveraging parallelism. One powerful tool in the .NET developer's arsenal for achieving parallelism is PLINQ - Parallel Language-Integrated Query.
• Programming in Practice - LINQ Expression May 06, 2024. An impression can be made that: data is data, and it doesn't matter where it comes from provided it is reliable. The LINQ technology is presented to fetch the necessary data from any available source. After reading the full story forget about ChatGPT and MSDN in the context of LINQ to make your life easier.
• Database Connectivity in Visual Studio May 03, 2024. Visual Studio facilitates robust database connectivity through technologies like ADO.NET and Entity Framework. Developers can seamlessly integrate with SQL Server, MySQL, Oracle, and more using connection strings and data source management tools.
• Single, SingleOrDefault, First, and FirstOrDefault in Linq .NET C#Apr 30, 2024. LINQ's element operators like Single, SingleOrDefault, First, FirstOrDefault, Last, and LastOrDefault provide specific functionalities for retrieving elements from collections in C#. Here's how to use them effectively.
• Entity Framework Core: Features, Real-time Implementation, Best PracticesApr 29, 2024. Entity Framework Core (EF Core) stands as a powerful toolset for .NET developers, streamlining the interaction between applications and databases through object-relational mapping (ORM). Whether adopting a database-first or code-first approach, EF Core simplifies data access and manipulation.
• Explain Lambda Functions in .NET C#Apr 26, 2024. In the realm of .NET programming, lambda functions represent a powerful and concise way to define anonymous methods or functions. In this article, we'll explore the fundamentals of lambda functions in .NET, understand their syntax and usage, and uncover their practical applications in real-world scenarios.
• C# Programming: Language Fundamentals, OOP, Async, LINQApr 25, 2024. This guide provides a thorough exploration of the C# language, covering essential topics such as language fundamentals, object-oriented programming concepts, asynchronous programming, and Language Integrated Query (LINQ).
• LINQ in C#: Knowing When to Use First() vs FirstOrDefault()Apr 24, 2024. LINQ, a cornerstone of C#, empowers developers to query data across various sources efficiently. This guide delves into the nuanced differences between First() and FirstOrDefault(), aiding in crafting resilient and optimized code.
• Exploring Data Integration Solutions with Azure Data FactoryApr 21, 2024. Azure Data Factory, a cloud-based data integration service. This article will cover the basics of Azure Data Factory and its components and understand what is data movement and transformation. It also explains the monitoring and management aspects of Azure Data Factory.
• New LINQ Methods in .NET 9 PreviewApr 14, 2024. While the release of .NET 9 is planned for November 2024, the preview version is already available. One of the new .NET 9 features is the new LINQ methods: CountBy, AggregateBy, and Index. In this article, I present how to use these methods.
• Functional programming in C# - IntroductionApr 02, 2024. Lets learn the concept of functional programming, its usage and why functional programming is important
• What is Language Integrated Query in C#?Mar 29, 2024. Know about LINQ (Language Integrated Query) in C# and their benefits. In this article, we have explained LINQ with an example.
• Exploring .NET 6's MinBy() and MaxBy() Extension MethodsMar 22, 2024. In this article, I will demonstrate the exciting new additions to LINQ extension methods introduced in.NET 6: MinBy() and MaxBy(). Let's explore how these powerful methods simplify code, providing efficient solutions for selecting extreme values within a generic sequence.
• 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.
• 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.
• 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.
• Difference Between Collect and ClearCollect in PowerAppsMar 01, 2024. In PowerApps, the Collect and ClearCollect functions play pivotal roles in managing data within your applications. Collect appends data to an existing dataset, while ClearCollect replaces the entire contents, refreshing the dataset. Master their nuances for effective data management.
• 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.
• Understanding Collection Types in C#Jan 09, 2024. Delving into collection types like IEnumerable and IQueryable in C# unveils their impact on data querying efficiency. While IEnumerable offers simplicity for in-memory operations, it might load unnecessary data. IQueryable optimizes query execution by fetching only required data, which is beneficial, especially with extensive datasets or remote sources.
• 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.
• 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.
• Overcoming Limitations of Power BI REST API for Automated Data Extraction from DatasetSep 27, 2023. Overcoming Limitations of Power BI REST API for Automated Data Extraction from Dataset
• Power BI Service Dataset Refresh History UpdatesSep 13, 2023. The PowerBI Service's dataset refresh history page has undergone significant improvements. Previously, it provided basic details such as trigger type, start and end times, status, and failure messages. Now, the enhancements offer more diagnostic and resolution capabilities.
• Transforming Streaming Data into Insights with Power BISep 12, 2023. Power BI empowers real-time dashboard creation, integrating streaming data sources like Azure Event Hubs, Kafka, and PubNub. Optimize data ingestion, design, and interactivity for effective real-time insights.
• 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
• Implementing Binary Search in PythonAug 18, 2023. Binary search, a potent algorithm, efficiently locates items in a sorted collection. Unlike linear search, it drastically minimizes comparisons, making it ideal for large datasets. Explore the binary search principles and Python implementation. Learn how binary search divides the search range and translates this into Python code.
• 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.
• Getting Started With Hugging FaceJul 16, 2023. This article is about the concept of Hugging Face, its models, datasets, and spaces that are provided by Hugging Face and also learn about pre-trained model
• 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
• LINQ MethodsJun 16, 2023. Linq Methods
• Difference between IQueryable, IEnumerable, IList and ListJun 12, 2023. when to use what IQueryable, IEnumerable, IList and List
• Apache Spark: RDD vs. DataFrame vs. DatasetsMay 17, 2023. This articel will give you an insight about the differences between RDD,Dataframe and Dataset
• 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.
• 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.