17 article(s)

• Azure for .NET Developers — Part 3: Azure SQL, EF Core, and the Firewall Gotchas

  Provision serverless Azure SQL with auto-pause, wire up EF Core with retry-on-failure, survive the firewall rules, and go password-less with Entra authentication.

  @llaxmikant · Aug 11, 2026
• Modern .NET Backend Roadmap — Part 3: Dapper for Fast Reads

  Add a Dapper read path beside EF Core: read models behind a port, parameterized SQL, mapping gotchas we actually hit, and when each tool wins.

  @llaxmikant · Jun 5, 2026
• Getting Started with ASP.NET Core Web API and Entity Framework

  Build your first ASP.NET Core Web API on .NET 10 with Entity Framework Core — scaffold models from SQL Server, add an async controller, and test with the built-in OpenAPI document and Scalar.

  @llaxmikant · May 28, 2026
• How to Pivot Data in SQL Server

  To pivot data in SQL Server, use the PIVOT operator to turn distinct row values into columns while aggregating a measure. You supply an aggregate (like…

  @llaxmikant · Mar 6, 2026
• Bulk Upload into SQL Server using SqlBulkCopy and C#

  Load 100,000 rows in under a second with SqlBulkCopy: column mappings, batch sizes, transactions, staging tables, and the constraint fine print — measured for real.

  @llaxmikant · Feb 28, 2026
• OUTER APPLY and CROSS APPLY in SQL Server with Examples

  Per-row table expressions: top-N-per-group queries, passing row values into table-valued functions, APPLY (VALUES) for named expressions, and when plain JOIN is all you need.

  @llaxmikant · Feb 7, 2026
• Read appsettings.json in a .NET Class Library with Dependency Injection

  The options pattern done right: the host owns configuration sources, the library declares typed settings, and DI carries one to the other — with validation at startup.

  @llaxmikant · Jan 28, 2026
• Entity Framework Core Database-First Tutorial

  Database-first in EF Core means you point a tool at an existing SQL Server database and it generates the entity classes and DbContext for you, instead of you…

  @llaxmikant · Jan 15, 2026
• SQL Server Common Table Expressions with Examples

  CTEs from basics to recursion — readable query pipelines, the top-N-per-group idiom with window functions, chained CTEs, writable CTEs for dedup, and walking hierarchies of any depth.

  @llaxmikant · Jan 3, 2026
• SQL Server Stored Procedure vs User-Defined Function

  The core difference is this: a stored procedure is a routine you execute to do work — it can modify data, run transactions, handle errors, and return one or…

  @llaxmikant · Dec 15, 2025
• User-Defined Functions in SQL Server

  A user-defined function (UDF) in SQL Server is a reusable routine that takes parameters, runs T-SQL, and returns either a single value or a table. SQL Server…

  @llaxmikant · Nov 26, 2025
• SQL Server Temporary Table vs Table Variable

  Statistics, indexing, scope, and rollback behavior compared with runnable examples — why table variables wreck big-join plans and where they genuinely win.

  @llaxmikant · Oct 23, 2025
• Exception Handling using TRY/CATCH in SQL Server

  Exception handling in SQL Server is done with a TRY...CATCH block: you wrap risky statements in BEGIN TRY ... END TRY, and when any of them raises a runtime…

  @llaxmikant · Sep 22, 2025
• Access SQL Server from a .NET Console Application

  Connect to SQL Server from a .NET 10 console app with Microsoft.Data.SqlClient: connections, parameterized commands, data readers, transactions, and where Dapper and EF Core fit.

  @llaxmikant · Sep 21, 2025
• Generate Sequence Numbers in SQL Server Queries

  ROW_NUMBER, RANK, DENSE_RANK, and NTILE side by side, PARTITION BY for per-group numbering, and persistent numbering with IDENTITY and SEQUENCE — all with verified outputs.

  @llaxmikant · Aug 20, 2025
• SQL Server Constraints with Examples

  All six constraint types on one table — PRIMARY KEY, UNIQUE, CHECK, DEFAULT, FOREIGN KEY, NOT NULL — each violated on purpose so you see the real errors, plus naming and FK-index guidance.

  @llaxmikant · Jul 22, 2025
• Types of SQL Server Joins with Examples

  A join in SQL Server combines rows from two or more tables based on a related column. The type of join decides which rows survive: an INNER JOIN keeps only…

  @llaxmikant · Jun 20, 2025