Resources   No resource found

• .Net 9 Web API Minimal API with Entity FrameworkJun 29, 2025. Here we will discuss how to create an Entity framework in .Net Minimal Web API with an Authorized JWT (JSON- Wen Token) token in Swagger web view.
• 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 the .NET EcosystemJun 24, 2025. Explore the .NET ecosystem — from C#, ASP.NET Core, and Entity Framework to ML.NET and .NET MAUI — with clear explanations and real-world examples.
• Entity Framework Change TrackingJun 20, 2025. This article explains Entity Framework Core Change Tracking, covering how EF tracks entity states, manages updates, and boosts performance using no-tracking queries for efficient, read-only data access.
• 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.
• Handle Entity Framework TransactionsJun 15, 2025. Learn how to manage transactions in Entity Framework to ensure data integrity. This article covers built-in handling, explicit transactions, rollbacks, commits, and managing multiple DbContexts for consistent operations.
• Named Entity Recognition (NER) with spaCy and TransformersJun 06, 2025. Learn how to use Named Entity Recognition (NER) with spaCy and transformer models like BERT to extract people, places, and organizations from text with high accuracy.
• Liquid Objects in Power Pages Portal – Explained with ExamplesJun 02, 2025. Learn how to use Liquid Objects in Power Pages Portal with clear examples. This guide helps you customize dynamic content, enhance user experience, and master Power Platform Liquid syntax.
• EJB QUERY LANGUAGE (EJB QL)May 30, 2025. EJB QL is a query language used to query enterprise beans and their relationships, supporting string and arithmetic functions, with syntax defined using Backus-Naur Form (BNF) for structured query creation.
• What is UEBA (User and Entity Behavior Analytics) in SIEMMay 28, 2025. UEBA (User and Entity Behavior Analytics) enhances SIEM by using AI to detect unusual behavior from users or devices, helping identify insider threats, anomalies, and advanced cyberattacks in real-time.
• 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.
• Working with Entities in Power Platform Copilot StudioMay 23, 2025. Learn how to use entities in Microsoft Copilot Studio to build smarter, AI-powered chatbots. Understand prebuilt and custom entities, improve conversation flows, and enhance user interaction and personalization.
• Advanced C# Database Tricks into a Practical SolutionMay 02, 2025. This project demonstrates an advanced C# database architecture combining EF Core, Dapper, and ADO.NET to achieve optimal performance, flexibility, and maintainability—complete with clean architecture, logging, and benchmarks.
• Advanced C# Database Tricks for Power UsersMay 01, 2025. Explore advanced C# database techniques using ADO.NET, Entity Framework Core, and Dapper.
• 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.
• 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.
• Entity Framework Core - Deep Performance Optimization GuideApr 16, 2025. Optimize your Entity Framework Core apps with proven performance tips: use AsNoTracking, prevent N+1 issues, project only needed fields, leverage caching, compiled queries, and bulk operations for faster, memory-efficient data access.
• Clean Code with Onion ArchitectureApr 11, 2025. Onion Architecture structures code into layers—Domain, Application, Infrastructure, and UI—ensuring separation of concerns, maintainability, and testability by isolating business logic from external dependencies.
• .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.
• Simple Best Practices for Code Quality and Performance in .NETApr 07, 2025. Let's break down some best practices for writing good and fast code in .NET, using simple examples and including important principles that anyone can understand.
• Adding Objects to a Local Database in MAUI .NET 9 [GamesCatalog] - Part 10Apr 02, 2025. Learn how to store game reviews in a local SQLite database using MAUI .NET 9. This guide covers setting up repositories, handling images, adding games, and implementing dependency injection for seamless functionality.
• Mastering Eager Loading in ASP.NET Core Web APIMar 31, 2025. Eager Loading in ASP.NET Core Web API is a technique using Entity Framework Core to load related data (like child entities) alongside the main entity in a single query. It helps improve performance by reducing database round-trip use.Include() and .ThenInclude(). Ideal for situations where related data is always needed.
• 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.
• Lazy Loading in ASP.NET Core Web APIMar 26, 2025. Learn how to implement Lazy Loading in ASP.NET Core Web API using Entity Framework Core. This complete guide covers configuration, models, DTOs, controllers, and best practices with a working example.
• 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.
• Explicit Loading in ASP.NET Core Web APIMar 18, 2025. Explicit Loading in ASP.NET Core Web API is a technique used to manually retrieve related data from the database when needed, using LoadAsync() on navigation properties. Unlike eager loading (Include()) or lazy loading, explicit loading provides better control over database queries, improving performance and efficiency. It is useful when related data is conditionally required.
• 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.
• Keyset Pagination in Entity Framework Core for Efficient Data RetrievalMar 10, 2025. In this article, I will provide a comprehensive overview of Keyset Pagination in Entity Framework Core, highlighting its benefits, implementation strategies, and a performance comparison with traditional pagination methods
• Entity Framework Core 9: Ultimate Performance Tuning & Best PracticeFeb 21, 2025. Entity Framework is a versatile and powerful ORM, but its performance depends on how it’s used. By following these best practices and leveraging the new features in .NET 9, you can build high-performance applications that scale efficiently.
• Entity Framework 9 - GroupBy Throwing ExceptionFeb 19, 2025. Entity Framework 9 (EF9) has a bug where using GroupBy with sorting may throw the exception: "The given key 'EmptyProjectionMember' was not present in the dictionary." Workarounds exist but aren't always practical.
• 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.
• Mitigate OWASP A02 2021-Cryptographic Failures Web Security TipsFeb 04, 2025. ADO.NET offers low-level access to databases using SQL commands, while EF is an Object-Relational Mapping (ORM) tool that simplifies database operations by mapping objects to database tables, offering higher-level abstractions.
• Be Careful Using Distinct and OrderBy in EF Core QueriesFeb 03, 2025. Combining Distinct() and OrderBy() in EF Core queries can lead to performance issues. This article explains why and offers solutions for efficient data retrieval.
• ADO.NET vs Entity Framework: Understanding the DifferencesFeb 03, 2025. This article compares ADO.NET and Entity Framework (EF), two popular data access technologies in .NET. It explores their differences in performance, data manipulation, and development approaches like code-first vs database-first, helping developers choose the right tool for their application needs.
• 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.
• Entity Framework (5-1), With .Net Core MVC, Database-First --- Scaffold-DbContextJan 18, 2025. This article is to discuss the reverse engineering command Scaffold-DbContext by AI.
• Understanding Connected Disconnected Scenarios in EF Core MVCJan 06, 2025. This article explains the connected and disconnected scenarios in Entity Framework Core for ASP.NET Core MVC applications. It covers how EF Core handles data in these scenarios, including change tracking, entity states, and managing database contexts.
• Optimize Relationships Migrations Performance in ASP.NET Core MVCJan 06, 2025. This article covers Entity Framework Core, query optimization, caching strategies, lazy and eager loading, and best practices to enhance your MVC application's efficiency.
• 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.
• Modern Featured Entity Framework With SQLite DB Example Dec 11, 2024. Learn to build a .NET Core application using C# async/await and SQLite with Entity Framework. Implement CRUD operations, handle asynchronous tasks, and explore efficient database interaction using Visual Studio 2022.
• CRUD Operations with ASP.NET Core API and EF CoreNov 29, 2024. This article provides step-by-step instructions for building a RESTful API, integrating EF Core for database management, and performing essential data operations seamlessly.
• 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#.
• Overview of Minimal APIOct 01, 2024. Minimal API in ASP.NET Core provides a streamlined approach to building HTTP APIs with minimal configuration. Introduced in .NET 6, it allows for lightweight API development without controllers, making it ideal for small projects. This article covers key features, and differences from traditional APIs, HTTP verbs, and routing techniques.
• 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.
• Understanding Key Concepts in Domain-Driven DesignSep 23, 2024. In this article, we will explore how these concepts drive effective software modeling, ensuring alignment between the business domain and your codebase.
• 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.
• Entity Framework Core Code-First Approach with Seed DataSep 09, 2024. It will be beneficial to beginners who are struggling with Entity Framework Core and Creating Code-First Approach. The EF-Core Code-First approach involves creating domain classes first and then generating the database using migrations.
• Entity Framework (3-0), Entity Data Model (EDM)Sep 07, 2024. This article is to describe Entity Data Model for EF
• Entity Framework (3), with .Net MVC, Model-FirstSep 01, 2024. This article will discuss Entity Framework with .Net MVC, Model-First approach
• Entity Framework (3-1), with .Net Console Model-First Aug 31, 2024. This article is to discuss Entity Framework with .Net Console Model-First .
• 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.
• Implementation Ajax Calls in ASP.NET Core MVC Aug 27, 2024. Learn how to build a dynamic fleet management system using AJAX in ASP.NET MVC with SQLite as the database provider. This tutorial guides you through creating, managing, and displaying vehicle data in a responsive web application, enhancing user experience with real-time updates.
• Entity Framework (13), with .Net Core Code-First SummaryAug 13, 2024. This is a summary article to discuss .Net Core Entity Framework Code First Approach.
• Entity Framework (11-1), with .Net Core Razor Pages Code-First (2)Aug 10, 2024. This is a discussion for Entity Framework Razor, the second part.
• Implementing Pagination and Filtering in ASP.NET Core 8.0 API Aug 06, 2024. Learn how to efficiently implement pagination and filtering in your ASP.NET Core 8.0 API using Entity Framework Core. Enhance performance, scalability, and user experience with server-side data handling techniques.
• 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.
• Entity Framework (12), with New .Net Core MVC Code-FirstJul 28, 2024. This article discuss the new .Net Core MVC entity framework, code first module.
• Database First Approach in .NET CoreJul 25, 2024. Discover the Database First Approach in .NET Core with our comprehensive guide. Learn how to efficiently integrate databases into your application using Entity Framework Core, design robust data models, and manage CRUD operations.
• 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.
• Entity Framework (11), with .Net Core Razor Pages Code-FirstJul 22, 2024. This article is discussing Entity Framework with .Net Core Razor Pages Code-First.
• 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.
• 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.
• jQuery DataTable Plugin to Customize Tables in Power Pages PortalJul 19, 2024. How to integrate the jQuery DataTable Plugin into custom tables within the Power Pages Portal. The DataTable Plugin enhances tables by providing features such as pagination, column filtering, efficient search capabilities, and customizable styling.
• 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.
• Soft Deletes with EF CoreJul 16, 2024. Learn how to implement soft deletes using EF Core in your ASP.NET Core applications. This guide covers the soft deletion pattern, ensuring data integrity while keeping historical records.
• 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.
• Working with Entity Framework CoreJul 15, 2024. Entity Framework Core (EF Core) is a powerful Object-Relational Mapping (ORM) framework provided by Microsoft for .NET applications. It simplifies data access and persistence by allowing developers to work with databases using .NET objects, thus abstracting away the complexity of database interactions.
• The Unit of Work Pattern in C# for Modern ApplicationsJul 11, 2024. Explore the Unit of Work pattern in C#, essential for modern application development. Discover how it facilitates efficient database operations, manages transactions with Entity Framework, and enhances the scalability and maintainability of your data access layer.
• Retrieving Entity Record IDs in CRM Plugin D365 CEJul 08, 2024. Unlock the methods to efficiently retrieve entity record IDs in Dynamics 365 Customer Engagement (D365 CE) CRM plugins. This guide explores step-by-step processes, best practices, and tips for developers to enhance their CRM customizations.
• 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.
• Generic Repository with EF Core in .NET Core 8Jul 03, 2024. Observe the Entity Framework Core Generic Repository! The subject that will make some people uncomfortable. They are unwilling to discuss it at all. Others, on the other hand, adore it and become giddy at the mere mention of the generic repository pattern.
• 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.
• Entity Framework Performance Improvements with Code ExamplesJun 23, 2024. Learn how to optimize Entity Framework performance with practical code examples. This guide covers essential techniques to enhance database efficiency, improve query performance, and eliminate bottlenecks.
• 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.
• How To Connect Database in ASP.NET MVC using C# with ADO.NETJun 17, 2024. Learn how to integrate SQL Server with your MVC application, configure connection strings, and perform CRUD operations. Ideal for developers seeking to enhance their data access techniques in ASP.NET.
• Understanding CRUD Operation in BlazorJun 13, 2024. Explore Blazor Server and WebAssembly models, integrate Entity Framework Core for data management, utilize Razor Components for UI design, and understand data binding in Blazor for seamless interaction.
• Preventing XSS Attacks in ASP.NET Core MVCJun 12, 2024. Build a secure ASP.NET Core MVC blog app with Entity Framework Core. Follow steps to create models, controllers, views, and implement client-side validation and sanitization to thwart XSS attacks. Access the GitHub project for code reference and ensure your application is protected against common vulnerabilities.
• 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.
• Interface In TypeScript / Complex Types In TypeScriptJun 09, 2024. In TypeScript, using interfaces helps define complex types, providing clarity and preventing runtime issues. Unlike JavaScript's var/let, interfaces explicitly outline object properties. This approach mirrors server-side coding practices, like in C#, ensuring adherence to coding standards and enhancing type safety.
• 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.
• Mastering ASP.NET Core Identity in ASP.NET Core MVCJun 06, 2024. ASP.NET Core Identity is a comprehensive membership system for adding login functionality to your ASP.NET Core applications. It provides a robust framework for managing users, passwords, roles, claims, tokens, email confirmation, and more.
• Understanding Durable Functions in Azure: A Comprehensive GuideJun 02, 2024. Explore the comprehensive guide to understanding Durable Functions in Azure. This guide delves into the concepts of serverless computing, function orchestration, and workflow automation using Azure Durable Functions.
• 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.