TTADotNetCore

Day-1

What is C#? C# C# .NET

C# Language .NET

Console App Windows Forms ASP.NET Core Web API ASP.NET Core Web MVC Blazor Web Assembly Blazor Web Server

.NET framework (1, 2, 3, 3.5, 4, 4.5, 4.6, 4.7, 4.8) windows .NET Core (1, 2, 2.2, 3, 3.1) vs2019, vs2022 - windows, linux, macos .NET (5 - vs2019, 6 - vs2022, 7, 8 - windows, linux, macos

vscode visual studio 2022

windows

UI + Business Logic + Data Access => Database

Day-2

ADO.NET connet to sql -C# -> Database

1. ADO.Net
2. Dapper (ORM) - Object Relational Mapper
3. EFCore -> Entity Framework (ORM)

---

C# -> SQL query -- using Nuget to install sqlclient -- Ctrl + . -- Fn + F9 ( Breakpoint ) , F10 ( Step down) -- select @@SERVERNAME ( to know servername ) -- use @ to support multi-line

Day-3

-- DotNetCore CRUD

Day-4

-- Dapper CRUD -- EFCore CRUD

Day-5

• databse first dotnet tool install --global dotnet-ef --version7
• • Create Class libray project ( dll )
• install entitiiyframework tools & design
• dotnet ef dbcontext scaffold "Server=THETTHETAUN8E36\TTASQLEXPRESS;Database=TTADotNetCoreDB;User Id=sa;Password=sa@123;TrustServerCertificate=True;" Microsoft.EntityFrameworkCore.SqlServer -o Models -c AppDbContext -f

Day-6

• WebApi

Day-7 ( 4.11.2024 )

• Asp.Net Core Web API
• MinimalApi

MiniKpayAPI

• User
• Deposit
• Withdraw
• History

Charts

• https://apexcharts.com/docs/installation/
• https://www.chartjs.org/docs/latest/getting-started/installation.html

AI

-https://chat.deepseek.com/