SAgiKPJH commented 1 day ago

Project Create

ASP.Net Core Web App

SQL Server

SSMS로 Microsoft SQL Server 구성

SQL Table을 만들고 example 데이터를 넣습니다.


CREATE TABLE clients (
id INT NOT NULL PRIMARY KEY IDENTITY,
name VARCHAR (100) NOT NULL,
email VARCHAR (150) NOT NULL UNIQUE,
phone VARCHAR (150) NULL,
address VARCHAR(20) NULL,
created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP
);

INSERT INTO clients (name, email, phone, address) VALUES ('Bill Gates', 'bill.gates@microsoft.com', '+123456789', 'New York, USA'), ('Elon Musk', 'elon.musk@sapcex.com', '+123456789', 'Floria, USA'), ('Will Smith', 'will.smith@gmail.com', '+123456789', 'California, USA')


  - ![image](https://github.com/user-attachments/assets/8c398990-5561-409d-a2f0-947a276f9f97)
  - 5min
- Nuget Package
  - System.Data.SqlClient
  - 7min
- ASP.NET Core Basic Web UI
  - ![image](https://github.com/user-attachments/assets/8dfcb097-00ef-424a-9c21-e828b4d656e2)
- Create Client/Index.cshtml.cs (razor Page)
  - Data Souce 얻기
    - ![image](https://github.com/user-attachments/assets/d79817b2-c4f9-45f4-a3a5-e7c08778c340)
    - ![image](https://github.com/user-attachments/assets/df577d7f-8acb-4bf9-bf72-bd20a0234138)
  - add appsettings.json
  - add index.cshtml.cs
  - 28min
  - add index.cshtml
  - add empty table
  - ![image](https://github.com/user-attachments/assets/5e3787a7-c165-4ae4-9510-6439e176135a)
  - 33min
- Add Table
  - ![image](https://github.com/user-attachments/assets/4f2d41cf-e519-413a-806d-47d5ac679985)
  - 43min
- all CRUD
  - 94min

SAgiKPJH commented 1 day ago

SagiK-Repository / Learn_CSharp_Web

ASP.NET Core Web Application with SQL Server and CRUD - BoostMyTool #5

Project Create