Programming · ADC-03-16

C# Programming with SQL Server 2025

C# Programming with SQL Server 2025 is a course in building database applications with C# 14 on .NET 10 and SQL Server 2025, from T-SQL and stored procedures to data access with ADO.NET, Dapper and EF Core, Web APIs, Blazor screens and reports. It suits C# developers, IT teams that run business systems and anyone moving legacy .NET Framework code forward.

Updated 8 Oct 2026

From 9,810 THB / person 10,900 −10% excl. VAT 7% · group rates available

Corporate training quote Join the waiting list

PDFDownload the course outline

Duration18 hours · 3 days
FormatOnsite / live online
Next roundOn request
CertificateIncluded

Course overview

Many business systems still pair C# with SQL Server, but much of that code was written on .NET Framework with LINQ to SQL, DataSets, GridView and old-style web services that no longer exist in modern .NET. Meanwhile SQL Server 2025 brings new capabilities such as the JSON data type, regular expressions and vectors, so developers need to know both the database side and the code side in their current form to build systems that are fast, secure and easy to maintain.

This course teaches C# 14 on .NET 10 working with SQL Server 2025 from both sides. It starts with database design, T-SQL, stored procedures and transactions, and the new SQL Server 2025 features. Learners then access data from C# with ADO.NET, Dapper and EF Core 10 with LINQ, build a Web API to replace old web services, create data screens with Blazor in place of GridView and FormView, and produce paginated reports and Excel files. It closes with a workshop that builds a real business system from the database to the user interface. (3 days, 6 hours per day, 18 hours in total, Intermediate level.)

What you’ll gain

Install and use SQL Server 2025 Developer Edition alongside the .NET 10 SDK
Design databases and write T-SQL, views, stored procedures and transactions for applications
Use the SQL Server 2025 JSON data type, regular expression functions and vectors appropriately
Access the database from C# with ADO.NET and Dapper, safe from SQL injection
Use EF Core 10 and LINQ to create, read, update and delete data efficiently
Build Web APIs with ASP.NET Core 10 so other systems can use the data
Build data display and editing screens with Blazor QuickGrid and EditForm
Produce paginated reports and export data to Excel files

Who this course is for

C# developers who build applications that work with SQL Server databases
Developers who maintain .NET Framework systems and want to move to .NET 10
IT staff who develop internal business systems and reports
IT managers and tech leads who set the team's data access approach
Anyone who learned ADO.NET, LINQ to SQL or an older Entity Framework and wants to update

Prerequisites

Basic C#, such as classes, methods, lists and exception handling
Basic SQL, such as SELECT, JOIN, INSERT and UPDATE
Some experience with Visual Studio or VS Code
A laptop that can run the .NET 10 SDK and Docker Desktop or SQL Server 2025 Developer Edition, with permission to install software

Curriculum

Course Details

This course is the 2026 edition that replaces the previous Visual C# Programming and Microsoft SQL Server 2012 course. It has been rewritten from scratch for C# 14, .NET 10 (LTS) and SQL Server 2025. It runs for 3 days, 6 hours per day (18 hours in total, 09:00-16:00), as lectures with labs built on a single sample store database throughout. Intermediate level. LINQ to SQL, DataSets and GridView have been dropped in favour of

ADO.NET with Microsoft.Data.SqlClient, Dapper and EF Core 10. Web APIs are built with ASP.NET Core 10, screens with Blazor, and the SSRS topic has become paginated reports with Power BI Report Builder. The course focuses on building complete applications from the database to the user interface; for an in-depth look at EF Core, see the Data Access with EF Core, ADO.NET and LINQ course. Learners take home a lab guide, SQL scripts and source code for every lab.

Day 1 SQL Server 2025 and T-SQL for Developers

Section 1: Lab: Setting Up .NET 10 and SQL Server 2025

An overview of database application development on .NET 10 compared with the .NET Framework era
SQL Server 2025 editions and choosing Developer Edition for development
Run SQL Server 2025 with Docker or install it on Windows
Connect with SSMS or VS Code with the MSSQL extension
Lab: create the sample store database and a first C# project

Section 2: Database Design and Everyday T-SQL

Design tables with primary keys, foreign keys and constraints
Choose suitable data types, such as decimal for money and datetime2
JOIN, GROUP BY, subqueries and CTEs for reporting
Window functions for ranking and running totals
Lab: query monthly sales by product

Section 3: Views, Stored Procedures and Transactions

Views to hide query complexity
Write stored procedures with parameters and output values
Handle errors with TRY...CATCH and THROW
Transactions and the isolation levels developers should know
Lab: a stored procedure that saves an order and updates stock in one go

Section 4: Lab: New Capabilities in SQL Server 2025

The new JSON data type and querying JSON data
Regular expression functions such as REGEXP_LIKE for validating data patterns
The vector data type and VECTOR_DISTANCE for similarity search
Lab: store product attributes as JSON and validate product codes with regular expressions

Section 5: C# 14 for Data Work

Classes, records and nullable reference types
LINQ to Objects, lambdas and pattern matching
async and await for database and network work
Read settings from appsettings.json and keep passwords in user secrets
Lab: write data classes and a service for the sample app

Day 2 Accessing the Database from C#

Section 6: Lab: ADO.NET with Microsoft.Data.SqlClient

SqlConnection, SqlCommand and SqlDataReader with async
Parameterised queries to prevent SQL injection
Call stored procedures and read output parameters
Use transactions from C# code, and connection pooling
Lab: CRUD for product data with ADO.NET

Section 7: Dapper for Fast Queries

What Dapper is and how it differs from ADO.NET and EF Core
Query, Execute and mapping results to objects
Multi-mapping for data joined from several tables
Lab: a sales report with Dapper and a stored procedure

Section 8: Lab: Getting Started with EF Core 10

DbContext, entities and registration in dependency injection
Code first with migrations, and database first with scaffolding
One-to-many and many-to-many relationships
Map data to SQL Server 2025 JSON columns
Lab: model an ordering system with EF Core 10

Section 9: LINQ with EF Core and Performance

Create, read, update and delete data with async LINQ
Include, projection and paging
AsNoTracking, ExecuteUpdate and ExecuteDelete
Find and fix N+1 queries from EF Core logs
Lab: tune a slow query and measure before and after

Section 10: Structuring the Data Layer

Separate a service layer and pass data with DTOs
Choose ADO.NET, Dapper or EF Core to suit the task
Dependency injection and per-environment configuration
Lab: combine all three data access approaches in one well-organised project

Day 3 Web APIs, Data Screens and Reports

Section 11: Lab: Web APIs with ASP.NET Core 10

From old-style web services to REST APIs on ASP.NET Core
Minimal APIs, route groups and validation in .NET 10
Generate the built-in OpenAPI document with AddOpenApi
Return errors with ProblemDetails and test with .http files
Lab: an API for products and orders

Section 12: Lab: Data Screens with Blazor

Blazor Web Apps and render modes at a glance
Display tables with QuickGrid, including sorting and paging
Add and edit forms with EditForm and validation
Call services or Web APIs from components
Lab: a product management screen that replaces the old GridView and FormView

Section 13: Reports and Data Export

Where reporting is heading: SSRS and Power BI Report Server from SQL Server 2025
Design paginated reports with Power BI Report Builder
Pass parameters and use stored procedures as report data sources
Export data to Excel files from code with ClosedXML
Lab: a monthly sales report as both a paginated report and an Excel file

Section 14: Security and Deployment

Create a least-privilege application login in SQL Server
Store connection strings safely and encrypt connections
Health checks and logging for database-backed systems
Lab: run the app alongside SQL Server 2025 with Docker Compose

Section 15: Workshop: An Order Management System

Design the database and stored procedures from a real brief
Build the data layer, Web API and Blazor screens end to end
Add a sales report and Excel export
Use an AI assistant to help write SQL and code, and review the output
Present the work and sum up how to move legacy systems to .NET 10

Schedule & training options

For individuals — public rounds

No public rounds are open right now. Join the waiting list and we will contact you first when the next round opens, or ask us on LINE. Or call 02-570-8449 or 088-807-9770

Join the waiting list Ask about rounds

For organisations — in-house / private

Tailor the content to your team’s tools and projects
Your dates, at your office or live online
Quotation with tax ID for procurement

Corporate training quote

Instructors

Sanitwong KamonpakornInstructor

Frequently asked questions

How do ADO.NET, Dapper and Entity Framework Core differ?

ADO.NET is the lowest layer, where you write the SQL and read the results yourself, giving the finest control. Dapper is a micro-ORM: you still write SQL, but it maps results to objects for you, which suits fast reporting queries. EF Core 10 is a full ORM that lets you query with LINQ and handles relationships, change tracking and migrations. LINQ to SQL from the .NET Framework era is not available in modern .NET. In this course you use all three against the same database so you can choose the right one for each job.

How do you write CRUD code with ADO.NET that is safe from SQL injection?

Use the Microsoft.Data.SqlClient package, open a SqlConnection with a connection string kept outside the code, and always pass values through SqlCommand parameters rather than concatenating user input into SQL. Read results with an async SqlDataReader and wrap changes to several tables in a transaction. The application should also connect with a login that has only the permissions it needs.

What is LINQ, and how does it help?

LINQ (Language-Integrated Query) lets you write queries in C# syntax, both over in-memory lists and over a database through EF Core, which translates LINQ into SQL. The compiler checks types as you write, IntelliSense helps, and the code is easier to read than concatenated SQL strings. You should still look at the generated SQL and watch out for N+1 queries, and this course shows how to spot and fix them.

Who is the C# Programming with SQL Server 2025 course for, and what should I know beforehand?

It suits C# developers who build applications on SQL Server, developers maintaining .NET Framework systems who want to move to .NET 10, IT staff who build business systems and reports, and IT managers and tech leads. You should have basic C# and be able to write basic SQL such as SELECT, JOIN, INSERT and UPDATE.

What will I be able to do after the C# Programming with SQL Server 2025 course?

You will be able to design databases and write T-SQL and stored procedures on SQL Server 2025, use its JSON, regular expression and vector features, access data from C# with ADO.NET, Dapper and EF Core 10, build Web APIs with ASP.NET Core 10, create data screens with Blazor, and produce paginated reports or Excel files. Participants who complete the training receive a Certificate of Completion with its own number, which can be verified online.

Can the C# Programming with SQL Server 2025 course be run in-house for our team?

Yes. It can be run in-house for your team, with examples adapted to your work, such as a database structure similar to your real systems, or a focus on moving legacy systems from .NET Framework and older SQL Server versions to current releases. You can request a quotation from this page, or contact us on LINE @itgenius or by phone on 02-570-8449.

Articles are published in Thai.