.NET

Awaiting Tasks and Methods

Wait for things to finish, the async way

C# uses Task and async/await to run code asynchronously (in the background). 🏃‍♂️ Awaiting a Task 1 2 3 4 5 async Task RunAsync() { await Task.Delay(1000); // Wait 1 second Console.WriteL...

Posted by Rodrigo Castro on December 23, 2024

Introduction to Entity Framework

Easier database access with EF Core

Entity Framework Core (EF Core) is a modern ORM for C#. It lets you use C# classes to interact with your database: no raw SQL needed for most tasks! 🚀 Why Use EF Core? Write less data access c...

Posted by Rodrigo Castro on December 22, 2024

Introduction to Async Programming

Make your programs faster and more responsive

Async programming lets your program do more than one thing at once: great for web requests, file I/O, and keeping apps fast. 🚦 Why Use Async? Don’t block the program while waiting for slow thi...

Posted by Rodrigo Castro on December 22, 2024

Executing SQL Commands: SELECT, INSERT, UPDATE, DELETE

CRUD operations with ADO.NET

ADO.NET lets you run any SQL against your database. Here’s how to do basic CRUD (Create, Read, Update, Delete). 🔍 SELECT (Read Data) 1 2 3 4 5 6 7 string sql = "SELECT Id, Name FROM Users"; using...

Posted by Rodrigo Castro on December 21, 2024

Connecting to SQL Server and Oracle

ADO.NET connections for major databases

ADO.NET supports many relational databases, including SQL Server and Oracle. 🗄️ SQL Server Connection Namespace: System.Data.SqlClient NuGet: Usually built-in 1 2 3 4 5 6 string connString...

Posted by Rodrigo Castro on December 20, 2024

LINQ with Objects

Query your own custom classes

You can use LINQ on any collection, including lists of your own classes. 🏫 Example: Students 1 2 3 4 5 6 7 8 9 10 11 class Student { public string Name; public int Age; } var students = n...

Posted by Rodrigo Castro on December 19, 2024

Aggregation and Grouping with LINQ

Summarize and organize your data

LINQ can do more than filter and sort: it can summarize and group your data. ➕ Aggregation: Sum, Count, Average, Min, Max 1 2 3 4 5 6 int[] numbers = { 1, 2, 3, 4, 5 }; int sum = numbers.Sum(); ...

Posted by Rodrigo Castro on December 18, 2024

Filtering, Ordering, and Projecting with LINQ

Get what you want from your data

LINQ makes it easy to select, sort, and shape your data. 🔎 Filtering with Where 1 var even = numbers.Where(n => n % 2 == 0); 🗂️ Ordering with OrderBy / OrderByDescending 1 2 var sorted = na...

Posted by Rodrigo Castro on December 17, 2024

Introduction to LINQ

Query data easily in C#

LINQ (Language Integrated Query) lets you work with data (like arrays and lists) using simple, readable queries. 📝 Why Use LINQ? Write less code to filter, sort, and search data. Works with ...

Posted by Rodrigo Castro on December 16, 2024

Working with Databases Using ADO.NET

Connect your C# app to SQL Server

ADO.NET is the standard way to connect your C# applications to relational databases like SQL Server. 🔌 Connecting to SQL Server You’ll need a connection string (ask your DBA or use SQL Server Exp...

Posted by Rodrigo Castro on December 15, 2024