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

[SAgiKPJH]

• https://www.youtube.com/watch?v=T-e554Zt3n4&t=71s
• BoostMyTool

[SAgiKPJH]

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')

• 
• 5min
• Nuget Package
  • System.Data.SqlClient
  • 7min
• ASP.NET Core Basic Web UI
  • 
• Create Client/Index.cshtml.cs (razor Page)
  • Data Souce 얻기
    • 
    • 
  • add appsettings.json
  • add index.cshtml.cs
  • 28min
  • add index.cshtml
  • add empty table
  • 
  • 33min
• Add Table
  • 
  • 43min
• all CRUD
  • 94min

[SAgiKPJH]