DotNet Core 6 Web API CRUD Using Entity Framework Core 6 Code First Approach

In this tutorial a DotNET core 6 Web API CRUD operation using Entity Framework Core 6 Code First Approach is shown. .NET 6 Web API development is supported by Visual studio 2022. I am using C# programming language to create the Web API. I am also invoking this API using swagger and also via postman. Local MS SQL server express is used to store and retrieve the data.

Do you want to learn how to use and interact with the ChatGPT AI language model, one of the most powerful and versatile natural language processing tools in the world? If yes, then you should check out this amazing course that will teach you everything from the basics to the advanced features of ChatGPT. Click on this link to get started and enjoy a special discount from me:

Download the source code for this project from below location:

Web API tutorial using in memory entity framework database

You can download Visual studio 2022 from the link below:

----Contents of this Video-----

0:00 Intro
0:27 Create a ASP.NET core 6 Web API project
0:43 Create Model class
3:36 Add EF core nuget packages
4:27 Add controller and datacontext
7:23 Add migration classes and update database
11:21 Run the project and invoke swagger
14:58 Invoke Web API via Postman

[ozgunisitancaglar]

I'm watching from Turkey, the video was very helpful

[sarangabhoi]

Nice video ...i tried it today after seeing your video ..its working fine for me ..Thank you so much for providing us useful content for dotnet developers..

[analieflorezsanchez]

Sé que quizá no entiendas mi idioma pero... TE AMO. Me ayudó mucho este tutorial para poder empezar, intenté hacer todo manualmente pero es gracias gracias gracias!

[shivaainfo]

Good Video. it's working fine for me.

[daniel]

Few months ago when i was trying this it was working perfectly. I'm trying right now to create api just like this but the dependency is not working. What's going on?

[madandhmadandh]

How the Data folder as created plzz tell briefly

[VinuP]

Thank you
How do I contact you for some career assistance?

[Ramesh_Kumar_]

pls put a video using bearer token validation

[sudharsana]

PM> Add-Migration "2022-06-16_18_02"
Build started...
Build succeeded.

Entity Framework Core 6.0.6 initialized 'IntroApplicationContext' using provider with options: None
To undo this action, use Remove-Migration.
PM> update-database
Build started...
Build succeeded.

Entity Framework Core 6.0.6 initialized 'IntroApplicationContext' using provider with options: None
System.ArgumentException: Keyword not supported: 'providername'.
at parsetable, String connectionString, Boolean buildChain, Dictionary`2 synonyms, Boolean firstKey)
at connectionString, Dictionary`2 synonyms)
at connectionString)
at connectionString, DbConnectionOptions previous)
at key, DbConnectionPoolGroupOptions poolOptions, DbConnectionOptions& userConnectionOptions)
at key)
at value)
at connectionString)
at
at
at errorsExpected)
at giveUp)
at c, TState s)
at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerExecutionStrategy.Execute[TState, TResult](TState state, Func`3 operation, Func`3 verifySucceeded)
at Microsoft.EntityFrameworkCore.ExecutionStrategyExtensions.Execute[TState, TResult](IExecutionStrategy strategy, TState state, Func`2 operation, Func`2 verifySucceeded)
at retryOnNotExists)
at
at
at targetMigration)
at targetMigration, String connectionString, String contextType)
at targetMigration, String connectionString, String contextType)
at
at action)
Keyword not supported: 'providername'.
PM> pls give the solution
i am a new to .net core

"IntroApplicationContext": ID=sa;Password=;"