Resources  
  • User Defined Objects in JavaScriptMar 29, 2024. JavaScript provides a number of pre-defined objects like Array, String, Image, Date etc. which are very useful in web development.
  • Temporary Tables vs Common Table Expressions in SQL ServerMar 29, 2024. In this article, we will learn what is Differences Between Temporary Tables and Common Table Expressions in SQL Server. Temporary tables and Common Table Expressions (CTEs) are SQL Server tools for data manipulation.
  • Organizing AWS Lambda dependencies with layersMar 27, 2024. Optimize AWS Lambda deployments by organizing dependencies with layers. Simplify management, enhance performance, and streamline updates for serverless applications, ensuring efficient resource utilization in your cloud architecture.
  • Learn Service Locator Pattern in C#Mar 26, 2024. This beginner’s tutorial explores the Service Locator Pattern in C#. Despite its decline in favor of Dependency Injection, it remains relevant for legacy systems. The tutorial covers its implementation, the Dependency Inversion Principle (DIP), static and dynamic versions, and pros/cons.
  • C# HTTP Methods: Safe vs. Unsafe, GET vs. POST in .NET CoreMar 26, 2024. Dive into advanced topics like dependency injection, service configuration, and implementing retry policies and circuit breakers. Elevate your API integration game with this comprehensive guide to leveraging HttpClient effectively.
  • Background Services in .NET CoreMar 22, 2024. In this article, we will learn Background Services in .NET Core allow developers to execute asynchronous tasks in the background, ensuring the smooth operation of applications.
  • How to Learn About Amazon S3Mar 22, 2024. Amazon S3, an AWS service, provides secure, scalable object storage with high durability and availability. Key features include lifecycle policies, versioning, and security measures. Practical applications range from data backup to content delivery.
  • Introduction to 3D Object Control in Power AppsMar 21, 2024. Introduction to 3D Object Control in Power Apps explores integrating 3D objects into user interfaces. Learn how to manipulate objects, design interactions, and enhance user experiences using Power Apps' visual programming capabilities for augmented and virtual reality applications.
  • Configuring Git in Azure Data Studio for SQL & Synapse PoolsMar 21, 2024. In this article, we'll delve into the process of configuring Git to manage database objects within a Synapse Dedicated Pool environment (or Azure SQL Database) using Azure Data Studio.
  • Change Data Capture - CDC with SQL serverMar 21, 2024. Learn how CDC facilitates seamless data integration, enables efficient data replication, and ensures accurate data synchronization, providing businesses with timely insights and streamlined operations.
  • Singleton Design Pattern In FlutterMar 20, 2024. Learn how and when to use Singletons, implement them effectively, and explore their advantages and limitations. This article also includes a sample implementation using the shared_preferences package to manage user preferences.
  • Decorator Pattern in C# - 3 versionsMar 20, 2024. In this article, we will explore the versatile Decorator Pattern in C#, presented in 3 different versions. Enhance your understanding of object-oriented design with this powerful pattern, offering flexible ways to add functionality to objects dynamically.
  • .NET internals: Learning Object-Oriented .NET ILMar 19, 2024. .NET IL, or Intermediate Language, serves as a bridge between high-level programming languages and machine code. This article delves into object-oriented .NET IL concepts with detailed explanations and code examples.
  • What is Alternative of Multiple Inhertitance in C#?Mar 18, 2024. This approach allows for achieving some level of multiple inheritance-like behavior while avoiding the complexities associated with traditional multiple inheritance.
  • TINYINT Data Type in SQL and Its C# EquivalentMar 16, 2024. Understanding data types is crucial for effective data manipulation and storage. In this article, we will learn about TINYINT in SQL efficient storage for small integers. In C#, use byte or sbyte for representation. Optimization is crucial.
  • Sort Array Directive in Vue.jsMar 13, 2024. Custom directives in Vue.js empower developers to extend HTML elements' functionality, enabling direct manipulation of the Document Object Model (DOM) within Vue applications. This example demonstrates creating a directive to sort an array based on a specific property.
  • How to Fetch Daily, Weekly, Monthly, and Yearly based Data in SQLMar 12, 2024. In SQL, fetching data based on specific time intervals like day, week, month, and year is essential for meaningful analysis.
  • Abstract Factory Design Pattern In FlutterMar 12, 2024. Learn about the Abstract Factory design pattern in Flutter for creating platform-specific widgets. This pattern centralizes the creation of related objects, making it easier to manage and work with multiple factory methods.
  • Basics of Azure Databricks: Data Analytics in the CloudMar 11, 2024. Azure Databricks stands at the forefront of cloud-based data analytics platforms, revolutionizing the way organizations manage, process, and derive insights from massive datasets. Azure Databricks, exploring its components, features, and capabilities to empower data-driven decision-making in the digital age.
  • JavaScript WeakMap in ES8 and TypeScriptMar 11, 2024. WeakMap object stands out as a specialized entity, closely related to the Map object but with a unique twist. In this article, we'll unravel the syntax, characteristics, and methods of the JavaScript WeakMap, shedding light on its applications. How to harness its capabilities in ES8 and TypeScript.
  • Benefits of Temporary Tables over Table Variables in SQL ServerMar 10, 2024. The article explores the advantages of utilizing temporary tables over table variables in SQL Server. It discusses how temporary tables offer better performance, scalability, and flexibility for handling large datasets and complex data manipulation tasks.
  • A Guide To Crafting Immutable Objects With C# 10's Init-Only PropertiesMar 06, 2024. Discover how C# 10's init-only properties empower developers to craft immutable objects with precision, enhancing code readability and maintainability. In this article, Ziggy Rafiq demonstrates how you can use this powerful feature to create robust and predictable software.
  • Factory Method Design Pattern In FlutterMar 06, 2024. Factory Method design pattern! Learn how to create objects dynamically, improve code flexibility, and build platform-specific UIs (like buttons) with ease. Explore a practical payment gateway example and overcome common challenges.
  • Renaming the Column in SQL ServerMar 06, 2024. Renaming columns in SQL Server is a fundamental task in database management. This comprehensive guide provides step-by-step instructions, syntax examples, and best practices to effectively rename columns, ensuring data integrity and maintaining database structures.
  • Understanding FORMATMESSAGE() Function in SQL ServerMar 06, 2024. In this article, we will discuss how to use FORMATMESSAGE() function in SQL Server, its advantages and usages with example.
  • Securing Remote Access to SQL ServerMar 05, 2024. Securing remote access to SQL Server is paramount for data protection and compliance. Explore methods like VPNs, firewalls, encryption, and multi-factor authentication for enhanced security and protection against cyber threats.
  • Mastering Object Creation in C#Mar 04, 2024. Learn to create objects in C# step-by-step. Define classes, instantiate objects, access members, use constructors, and explore static constructors—master object creation for robust C# applications.
  • A simplified approach to serializing and deserializing objects in C# 10Mar 04, 2024. This comprehensive guide teaches how to streamline data interchange processes efficiently using C# 10 Records. Authored by Ziggy Rafiq.
  • SQL Tuning - Effective Strategies with Practical ExamplesMar 03, 2024. SQL Tuning — Effective Strategies with Practical Examples
  • Introduction to Design Patterns in FlutterMar 02, 2024. Explore the importance of design patterns in software development. Learn about different types of patterns, their benefits, and how they can improve code efficiency, readability, and maintainability. Ideal for developers seeking to enhance their coding practices.
  • Product Management Application using .NET Core and React JS with CRUD OperationsMar 02, 2024. In this article, learn to create a product management web API with CRUD operations using .NET Core 6 and React JS. Utilize SQL Server for the backend and Axios for API consumption.
  • How to Open, Read or View MS SQL Error Log FileFeb 29, 2024. Explore methods to open, read, or view SQL Server Error Log File. Get the best solution to open or view the SQL Server Log File of MS SQL Server in easy steps.
  • SQL Server Data Types for Performance, Memory EfficiencyFeb 28, 2024. "Embark on a journey to unlock SQL Server's full potential through savvy data type selection. Enhance performance and streamline operations with optimal choices.
  • Quick SQL Refresher Feb 28, 2024. The Quick SQL Refresher provides a concise cheat sheet for SQL, covering essential concepts, keys, commands (DDL, DML, DQL, DCL, TCL), constraints, clauses, T-SQL fundamentals, joins, functions, exception handling, indexes, views, stored procedures, transaction control, triggers, and cursors.
  • 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.
  • Tips to Launch Your SQL MissionFeb 20, 2024. This article consists of roadmap to embark on an exhilarating journey to master SQL which is the universal language of data management and analysis. In this comprehensive guide, we'll delve deep into actionable strategies and invaluable tips to help you kickstart your SQL learning journey and unleash the transformative power of data manipulation and insight extraction.
  • A Comprehensive Guide to Best Practices and Common Scenarios Using Dependency Injection in .NET 8 with C#10Feb 20, 2024. This comprehensive resource covers everything you need to know to leverage Dependency Injection effectively in .NET 8 with C# 10. Ziggy Rafiq explains how to use Dependency Injection in the best possible way. For developers looking to optimize their .NET projects, this guide provides invaluable insight from understanding core concepts to implementing advanced techniques.
  • ASP.NET Core with Hosted Service & Lifecycle EventsFeb 20, 2024. ASP.NET Core with Hosted Service & Lifecycle Events explores the integration of background tasks in ASP.NET Core applications. Learn how to implement long-running processes efficiently, manage service lifetimes, and leverage lifecycle events for graceful initialization and shutdown.
  • Securing Your .NET Projects: Simple Strategies and Real ExamplesFeb 18, 2024. In today's digital world, keeping our software safe from cyber threats is super important. For developers working with .NET projects, it's not just a good idea but really necessary to make sure our apps are strong against potential attacks. Luckily, there are lots of tools and tricks within the .NET world to help us do this.
  • Fortifying your .NET ProjectFeb 16, 2024. This article explores essential strategies to enhance the security of .NET projects, addressing common threats like SQL injection and XSS. It covers input validation, parameterized queries, authentication, secure communication, XSS prevention, and dependency management for robust application security.
  • Optimize HttpClient Usage in .NET CoreFeb 15, 2024. Dive into advanced topics like dependency injection, service configuration, and implementing retry policies and circuit breakers. Elevate your API integration game with this comprehensive guide to leveraging HttpClient effectively.
  • Learn about Reflection in C#Feb 13, 2024. Reflection is a powerful feature in C# that enables you to inspect and interact with types, assemblies, and objects at runtime. It provides a way to dynamically discover and use information about types, invoke methods, and access fields and properties.
  • Difference Between UNION and UNION All (SQL Server)?Feb 12, 2024. UNION merges and filters out duplicates from various SELECT queries, whereas UNION ALL combines them without eliminating duplicates, providing quicker results but retaining all rows, including duplicates.
  • Analysis of T-SQL and PL/SQLFeb 12, 2024. This article delves into the distinctions between Transact-SQL (T-SQL) and PL/SQL, examining their origins, syntax, functionality, and optimization strategies. Explore their unique features for efficient database application development.
  • Explain Keyed Services in .NET 8Feb 12, 2024. This article explores the concept of keyed services in .NET 8, a new feature enhancing dependency injection capabilities. It explains the benefits of using keyed services, along with detailed steps on their implementation through a real-world data storage example.
  • Polymorphism Concept in Object-Oriented ProgrammingFeb 12, 2024. What do you mean by polymorphism? Polymorphism is explained with C# examples, Polymorphism, a concept extending beyond programming, is illustrated in everyday scenarios. Electrical outlets serve as an analogy, supporting diverse devices—an example of polymorphism manifesting in real life.
  • New Modifications and Improvements to the Azure Stream Analytics No-Code Editor Feb 11, 2024. Explore real-time analytics with Azure Stream Analytics, a Microsoft Azure service for processing and analyzing streaming data. Learn about input sources, SQL-like query language, output destinations, and recent user experience enhancements for streamlined stream processing logic.
  • The Amazing Adventure of MongoDB QueriesFeb 09, 2024. This content provides an engaging analogy of MongoDB queries as an adventurous quest through a treasure-filled city. It introduces concepts like planning the query as preparing a treasure map, execution as detective work, utilizing the Aggregation Framework for complex queries.
  • What is Memento Pattern in C#?Feb 09, 2024. In this article, we will learn aboutThe Memento Pattern in C# enables capturing and restoring an object's state. It's crucial for implementing undo/redo functionalities and managing state changes efficiently in object-oriented systems, enhancing code maintainability and flexibility.
  • How to Find Blocked Deadlocks in SQL?Feb 09, 2024. The SQL query utilizes dynamic management views (DMVs) like sys.dm_exec_requests, sys.dm_exec_sessions, sys.dm_exec_connections, and sys.dm_exec_sql_text to monitor and manage active sessions, connections, and SQL statements on a SQL Server instance.
  • Difference Between Raw SQL and Dapper Feb 08, 2024. Explore the trade-offs between using raw SQL queries and leveraging Dapper, a micro-ORM for database access in C# development. Delve into performance, code maintainability, and efficiency to make informed decisions in your data retrieval strategies.
  • Automated Deployment of SQL Server Database through Azure DevopsFeb 06, 2024. Explore an automated deployment solution for SQL Server databases using Azure DevOps. This guide details the setup of a self-hosted agent, granting necessary server access, and configuring a release pipeline for deployment.
  • Understanding the Factory Pattern in .NET CoreFeb 06, 2024. Explore the power of the Factory Pattern in software design, a creational pattern enhancing flexibility. Delve into a real-world example using .NET Core for a car manufacturing system.
  • Override Basic Object of PythonFeb 06, 2024. This article introduces the concept of overriding methods in Python, focusing on the str and repr methods of the base object class. It explains how developers can customize the output when printing objects by overriding these methods.
  • Mastering T-SQL Rank FunctionsFeb 06, 2024. SQL window functions like ROW_NUMBER, RANK, DENSE_RANK, and NTILE are vital for advanced data analysis. They organize, order, and rank data within result sets. ROW_NUMBER assigns unique sequential numbers, RANK assigns unique ranks allowing ties
  • 🖥️ How to Create an Web App in Microsoft Azure?Feb 05, 2024. In this article, we will see how to create a web app in Microsoft Azure in step by step. Azure Web App, a fully managed PaaS from Microsoft Azure, simplifies web app deployment. Learn how to create and deploy via FTP, enhancing efficiency in web development and hosting.
  • Understanding "obj" and "bin" Directories in ASP.NET Core Web APIFeb 05, 2024. These directories are needed because the C# compiler and linker require intermediate files to be generated during the build process to produce the final output file. The "obj" directory contains these intermediate files, which are needed to link and optimize the final executable or library file.
  • Data Vault Design in Azure SQL - Read PII with Customer KeysFeb 05, 2024. Data Vault design in Azure SQL - Utilizing Customer keys to read PII information in databases. Ensuring data security in the cloud era is crucial, especially with the rise in data attacks. Protecting Personally Identifiable Information (PII) is paramount during cloud migration.
  • SQL Joins for Efficient Database QueriesFeb 05, 2024. Explore SQL joins, including inner, natural, left outer, right outer, full outer, and cross joins. Learn their usage, syntax, and differences to master relational database querying for effective data retrieval.
  • Optimize SQL Database PerformanceFeb 01, 2024. "Unlocking Database Efficiency: A Guide to Performance Optimization in SQL" is a concise and insightful resource that provides practical guidance on enhancing the efficiency of SQL databases. for optimize SQL database performance, ensuring faster queries, reduced resource consumption, and improved overall database responsiveness.
  • Optimize ASP.NET Core MVC Data Transfer with Custom MiddlewareFeb 01, 2024. In ASP.NET Core, middleware components are used to handle requests and responses as they flow through the application's pipeline. These middleware components can be chained together to process requests and responses in a specific order. Transferring data between middleware components can be achieved using various techniques.
  • JavaScript Destructuring: Arrays, Functions, and ObjectsJan 31, 2024. Destructuring is a powerful feature in JavaScript that allows you to extract values from arrays, objects, and function parameters easily.
  • What Are Primary Constructors in C# 12?Jan 31, 2024. C# 12 has a number of new features, one of which is Primary Constructors, which offer a simplified and more concise method of constructing objects in C#.
  • SQL Server Migration Strategy into Azure SQL PaaS DatabaseJan 30, 2024. This article outlines a strategic approach to migrating SQL database workloads from on-premises to Azure cloud services. It covers the high-level migration roadmap, choosing the right migration path, and tools.
  • Implement CRUD Operations in .NET Core 8 with Dockerized MSSQL ServerJan 25, 2024. In this article, I'm going to implement the basic CRUD Operations using .Net Core Web API & the Dockerized MSSQL Server. This article guides you through implementing CRUD operations in ASP.NET Core Web API using .NET Core 8 and saving data in a Dockerized MS SQL Server. Follow the steps for setup and coding.
  • Run MS SQL Server on Docker 📦Jan 24, 2024. In this article, I'm going to show how to install Docker on Windows 11 and run the MS SQL server on it.
  • Lazy Loading In ASP.NET Core 7 Web APIJan 22, 2024. ASP.NET Core 7 Web API. Lazy loading is a technique where related data is only loaded from the database when it is explicitly requested. In Entity Framework Core, lazy loading can be achieved by marking navigation properties as virtual.
  • Working with SQL Lite Database in Asp.NET Core Web API Jan 21, 2024. SQLite is a self-contained, serverless, and zero-configuration relational database management system (RDBMS). It is a lightweight, open-source, and embedded database engine that does not require a separate server process and operates directly on the client's device
  • 🖥️ A Guide to Web Attack Incident HandlingJan 17, 2024. In this article, we will explore various types of web attacks, including Denial of Service (DoS) and Distributed Denial of Service (DDoS), SQL Injection, Cross-Site Scripting (XSS), Command Injection, Local File Inclusion (LFI).
  • JavaScript Map Object in ES7 and TypeScriptJan 16, 2024. The JavaScript Map object is a versatile tool for mapping keys to values, offering efficient operations for searching, updating, and deleting elements based on specified keys. In this article, we will explore the capabilities of the Map object in ES7 (ECMAScript 2016) and delve into its application in TypeScript.
  • Set Object in ES7 and TypeScriptJan 16, 2024. The JavaScript Set object is a versatile tool for managing collections with unique values, accommodating various data types, including both primitive values and object references. In this article, we'll dive into the capabilities of the Set object in ES7 (ECMAScript 2016) and explore its usage in TypeScript.
  • WeakSet Object in ES7 and TypeScriptJan 16, 2024. The WeakSet object emerges as a unique entity designed specifically for storing weakly held objects. Unlike its counterpart, Set, WeakSet exclusively deals with objects, offering distinct advantages. This article delves into the intricacies of the JavaScript WeakSet object.
  • OPENJSON in SQL ServerJan 15, 2024. SQL Server's OPENJSON function is a powerful tool for working with JSON data in relational database systems. It allows users to parse and transform JSON-formatted strings into tabular data, making it easier to integrate JSON data with traditional relational data. In this article, we'll explore the functionality, syntax, and use cases of OPENJSON in SQL Server
  • Building a Secure PHP MySQL Signup/Login Website with Email VerificationJan 15, 2024. Creating a secure signup/login system is essential for any web application that involves user authentication. In this article, I'll guide you through building a PHP MySQL login/signup website with email verification. I'll focus on security best practices, including password encryption using PHP's built-in functions.
  • Partitioning in PostgreSQL: What, Why, and HowJan 11, 2024. PostgreSQL partitioning enhances database management by dividing large tables into smaller, manageable partitions. Learn the benefits and types (range, list, hash, composite) for efficient data organization and querying.
  • Identifying the Root Cause of SQL Server ProblemsJan 10, 2024. Finding issues in SQL Server involves troubleshooting and identifying the root cause of problems. Troubleshooting SQL Server issues involves comprehensive steps. Check error logs, use SQL Server Management Studio for queries and execution plans, employ Profiler Traces, analyze Dynamic Management Views, monitor disk space, and review application code for optimization.
  • Union and Union AllJan 10, 2024. This article will tell you the use of union and union all and difference between them and some key points that are important to follow in union and union all syntax.
  • Deep Dive into Classes and ObjectsJan 10, 2024. Welcome, fellow programmers! Here, we will dive into the world of classes and objects. Classes and objects are fundamental in programming. This post unravels the essence of classes, abstract data types, and the concept of objects.
  • Interface Segregation PrincipleJan 10, 2024. The Interface Segregation Principle advocates breaking down a large interface into smaller, client-specific interfaces. This ensures that no class is compelled to depend on methods it doesn't use, promoting cleaner design.
  • SQL Functions and Examples.Jan 10, 2024. This article provides you with many built-in SQL functions including aggregate functions, date functions, string functions, control flow functions, window functions, and math functions.
  • JWT Authentication Using Refresh Token Series - 1 [Login Feature] In .NET Core 6.0-ADO.NET-SQLJan 10, 2024. In this series of articles, we'll focus on a hands-on, practical implementation of JWT authentication with refresh tokens in .NET Core 6.0 using ADO.NET and SQL, emphasizing real-world scenarios and code examples for a deeper understanding of the underlying concepts.
  • Deleting Duplicate Records Using CTEJan 09, 2024. In this article we will understand how to delete duplicate rows and records from table using Common Table Expression (CTE) in SQL Server.
  • Understanding the One-Way Nature of HASHBYTES in SQLJan 05, 2024. This article delves into the cryptographic world of hashing algorithms, emphasizing the irreversible nature of these functions. Learn why HASHBYTES, a widely-used function for creating hash values in SQL Server, isn't designed for decryption but serves as a vital tool for data integrity, password security, and more.
  • What is WebSQL?Jan 04, 2024. Explore the fundamentals of WebSQL, a deprecated but once widely used client-side storage solution for web applications. Learn its basics, from setting up a database to CRUD operations with SQL.
  • What is Protractor in Angular?Jan 04, 2024. Protractor, designed for Angular applications, is an E2E testing framework built on WebDriverJS. With Angular-specific features, automatic waiting, and cross-browser support, it streamlines end-to-end testing for Angular developers.
  • Create a Powerful RESTful API for SQL Server CRUD OperationsJan 04, 2024. Discover the world of building simple and effective APIs that talk to SQL Server databases. Learn how to safely handle data, improve performance, and get hands-on with coding examples for each CRUD operation (Create, Read, Update, Delete).
  • Dependency Inversion Principle VS Dependency Injection in C#Jan 04, 2024. Dependency Inversion Principle (DIP) and Dependency Injection (DI) are pivotal in crafting resilient software. Learn their implementations in C# for modular, adaptable, and maintainable code structures.
  • Safely Changing the Instance Name of SQL ServerJan 04, 2024. Changing the instance name of a SQL Server involves several steps and should be done with caution. Secure process for changing the instance name of SQL Server. This guide ensures a smooth transition, covering essential steps and precautions to safeguard your SQL Server configuration.
  • What is Primary Constructors in C# 12?Jan 03, 2024. Ditch the boilerplate and embrace elegant object creation with C# 12's primary constructors. This feature takes the hassle out of initialization, simplifies member assignment, and clarifies your code. Dive into its syntax, power, and practical application for smoother development.
  • Connecting Postgres Database to Mobile App with Flutter and DartJan 03, 2024. Postgres Database to connect with your mobile app using Flutter and Dart
  • Truncate All Table Data in MSSQLJan 02, 2024. In this article we will learn about how to truncate all tables in a SQL Server database using dynamic SQL. Exercise caution, as this operation deletes all data without the possibility of rollback. Learn essential precautions.
  • Microservices Development with 3-Tier Architecture and Circuit Breaker Design Pattern Using Microsoft ASP.NET Core Web APIDec 30, 2023. The Circuit Breaker pattern, analogous to its electrical counterpart, monitors for failures and helps prevent cascading failures in distributed systems. It acts as a barrier between a potentially failing service or resource and the rest of the system.When a service is working as expected, the Circuit Breaker allows requests to pass through. However, if the service encounters an issue or starts to fail, the Circuit Breaker "opens" and prevents further requests from being sent to the failing service for a defined period. This helps to preserve system resources and prevent overload or degradation.
  • Object Creation in C# with the Factory PatternDec 29, 2023. The power of software design with the Factory Pattern in C#. This comprehensive guide explores its role, benefits, and step-by-step implementation, empowering developers to craft modular and scalable code effortlessly.
  • Table(s): Temp Table, Table Variable and CTE (Common Table Expression)Dec 26, 2023. This article will discuss SQL Table like items, including temp table, table variable, CTE, Table-valued Parameters.
  • How To Create a WCF ServiceDec 26, 2023. How can I create a WCF service that manages employee details while interacting with an SQL database, including the necessary SQL table script for employee information storage?
  • API Development Using Dapper and Microsoft Asp.NET Core Web API Dec 24, 2023. ASP.NET Core is a powerful framework for building web applications, and "Dapper" is a popular micro ORM (Object-Relational Mapping) that works well with ASP.NET Core for database operations. Dapper provides a simple way to interact with databases using raw SQL queries while mapping the results to objects.
  • Creating Dynamic PIVOT Query in SQL ServerDec 23, 2023. In this article, we are going to learn how to create dynamic PIVOT Query in SQL Server with some examples.
  • Building a Custom Object Mapper in ASP.NET Core Using C#Dec 21, 2023. Unlock the power of data transformation in ASP.NET Core with a custom object mapper. Delve into the steps—defining mapping configurations, implementing logic, and seamless integration—ensuring tailored, efficient, and maintainable data conversion in your applications. Happy coding!
  • Query to Find and Drop User-Defined Stored ProcedureDec 20, 2023. In this article, we will learn about dangerous SQL scripts that iterate through user-defined stored procedures, views, functions, and user-defined types, dropping them one by one. Caution: Do not run in production environments; it poses serious risks.
  • Schemas in PostgreSQLDec 20, 2023. Understanding Schemas in PostgreSQL. Explore the power of PostgreSQL's schemas—logical groupings of database objects. Learn how to create, manage, and leverage schemas for effective data organization, security, and improved database design.

About SQL-Object-Dependencies

NA

OUR TRAINING