- This is Helpful For Learning How to Do Crud Operation In .net Core Web Api
- Give A Like To This Repo If you Found Something Helpful
- ✨RNG✨
- .net 6.0 or newest
- Clone The Repository And Then Open This .sln Project File
- Then Create A Database And Tables Using This Script
USE [master]
GO
/****** Object: Database [YourDatabaseName] Script Date: 2/4/2023 6:21:03 PM ******/
CREATE DATABASE [YourDatabaseName]
ALTER DATABASE [YourDatabaseName] SET QUERY_STORE = OFF
GO
USE [YourDatabaseName]
GO
/****** Object: Table [dbo].[Student] Script Date: 2/4/2023 6:21:04 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Student](
[Id] [int] IDENTITY(1,1) NOT NULL,
[Name] [varchar](50) NOT NULL,
[Class] [varchar](50) NOT NULL,
[RollNo] [int] NOT NULL,
[Address] [varchar](100) NOT NULL,
[IsDeleted] [bit] NOT NULL,
CONSTRAINT [PK_Student] PRIMARY KEY CLUSTERED
(
[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
ALTER TABLE [dbo].[Student] ADD CONSTRAINT [DF_Student_IsDeleted] DEFAULT ((0)) FOR [IsDeleted]
USE [master]
GO
ALTER DATABASE [YourDatabaseName] SET READ_WRITE
GO- Replace Server Name DbName UserName Password In AppSettings.Json File
{
"Logging": {
"LogLevel": {
"Default": "Information",
"Microsoft.AspNetCore": "Warning"
}
},
"ConnectionStrings": {
"Value": "Server=localhost;Database=YouDatabaseName; User ID=sa;Password=admin;"
},
"AllowedHosts": "*"
}- And Then Just Save And Run This Using Swagger You Can Easily Navigate To HttpRequests😁
- I would Like To collaborate With Other Developers💛
- Mail : Rajkumar00999.rk@gmail.com
- Follow Us On Instagram
MIT