Pat, your clarity, exactness, compactness, and delivery are greatly appreciated. Many explanations shot too high or too low, but you've perfectly threaded the knell. Cheers and thanks.
This is one of the best tutorials I've ever seen. I've been trying to find a clear explanation of this for a long time, and this is hands down the best I've ever seen. Clear explanation of every line, file, and concept. Excellent job.
@@prashantmjalskar8198 you got open your SQL Server . Then in properties you can find. Just make sure, If you're using Windows Authentication put this "Integrated Security=SSPI -For no user and password Encrypt=false - for no authentication" in your connection string. I hope this can help you!
The best I've come across on the topic. Easy, direct, clear, rich and devoid of unnecessary noise or showoff. The delivery is elegant. I feel more confident after watching this. Thanks a lot, Pat, for sharing this.
I never even leave comments, but your way of breaking down every step and explaining in a concise way requires me to at least say thank you for such great content! Thanks man!
If anybody is wondering, Package Manager Console is NOT available for Visual Studio on Mac. Took me only an hour and a half to find that 👍 Great tutorial! Thanks for making this :)
Tutorial was going so well until 13:20 (thank you!) but when you copied the SQL connection string there was no explanation as to where it came from or how to build it ourselves. Any chance of some clarification in a pinned comment please? **UPDATE** thanks to Bảo Trần Quốc for this: "Server=localhost\\SQLEXPRESS;Database=master;Trusted_Connection=True;"
Awesome tutorial! Sometimes you find someone that breaks things down in a way that's easy to just grasp and run with. Took some digging to find this though so hopefully it gets to the top of the ranks eventually.
Hey, thanks for this. 13:50 can I ask whether it's safe to use an existing database with existing content when doing the migration? I want to make an API with my existing data, rather than create a new database. Is this possible?
if you are all wondering regarding on connection strings at 13:10 if you are using Visual Studio, go to 'View' click 'Properties Window' then on the side you will see a tab.. then on 'General' category you will see Connection String
Thanks, great video. If you are getting this error while trying POST "---> Microsoft.Data.SqlClient.SqlException (0x80131904): Cannot insert explicit value for identity column in table 'Issues' when IDENTITY_INSERT is set to OFF." Don't give an id to that data.
@Djonathon Oliveira Create a database on something like MS Azure, then under Connection strings, it should be generated for you. I think the guy in the video has a local database, which is why the source says his computer ID.
I don't understand why we need to put the id in the header and also the body. What is the purpose ? Could we not put either in the header or the body ? Thanks.
13:17 - "...and then draw the rest of the owl!" 🤨 It would be nice to know where you got the SqlServer string from. Am I supposed to already have some sort of Sql Server instance running on my machine? Where did you download it from? How did you install and run it? I would greatly appreciate any help here.
What a great tutorial, It really helped me a lot! but, is it possible to connect this to a frontend like angular, if so, I would Appreciate knowing the procedure behind it. Thanks.
i'm geting an error when Update-Database, A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SNI_PN11, error: 25 - Connection string is not valid). how to solve that?
Thank you! Could you explain "var issueToDelete = await _content.Issues.FindAsync(id);"? Why do you use async-method, if your main code is waiting for it to get the value for var issueToDelete ? It will still run in sync, won't it?
I fixed it, I change the SqlStringConnection in file appsetting.json, and my conn string is: "Server=localhost\\SQLEXPRESS;Database=master;Trusted_Connection=True;" , if anyone meet this bug then guy can use it as a template ... thanks !!!
Thanks for this great tutorial. I have a question that can we use WebAPI with a UI project? When I made a research on the Internet, I have seen that WebAPI is compatible for phones, tablets, and pcs. Also, I have watched many tutorials and most of them shows how to run WebAPI from the URL part. I mean, about entering the id and getting the data. But I think it is not practical for an end user to use the URL for every request, right? Is there any technology combined with web api or is it just a kind of research topic? How can we use it for a GUI Web project? Thanks in advance!
An exception of type 'System.Text.Json.JsonException' occurred in System.Private.CoreLib.dll but was not handled in user code The JSON value could not be converted to System.Collections.Generic.IEnumerable`1[test_api.User]. Can someone help please
Help, error update-database => A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - La cadena de certificación fue emitida por una entidad en la que no se confía.)
![I.N "HALLUCINATION" | [Stray Kids : SKZ-PLAYER]](http://i.ytimg.com/vi/n5B5q1Hwt_U/mqdefault.jpg)
Pat, your clarity, exactness, compactness, and delivery are greatly appreciated. Many explanations shot too high or too low, but you've perfectly threaded the knell. Cheers and thanks.
This is one of the best tutorials I've ever seen. I've been trying to find a clear explanation of this for a long time, and this is hands down the best I've ever seen. Clear explanation of every line, file, and concept. Excellent job.
can you tell me how do we get this connection string? 13:21
@@prashantmjalskar8198 you got open your SQL Server . Then in properties you can find. Just make sure, If you're using Windows Authentication put this "Integrated Security=SSPI -For no user and password
Encrypt=false - for no authentication" in your connection string. I hope this can help you!
The best I've come across on the topic. Easy, direct, clear, rich and devoid of unnecessary noise or showoff. The delivery is elegant. I feel more confident after watching this. Thanks a lot, Pat, for sharing this.
I never even leave comments, but your way of breaking down every step and explaining in a concise way requires me to at least say thank you for such great content! Thanks man!
If anybody is wondering, Package Manager Console is NOT available for Visual Studio on Mac. Took me only an hour and a half to find that 👍
Great tutorial! Thanks for making this :)
Thanks for the heads up
Thanks man, mind to tell us how you complete the steps without Package Manager Console?
Can you tell us how you complete the steps without Package Manager Console? Im running in same issue. Thanks
The simplicity of this tutorial showed me you have a lot of experience working with this technology and frameworks. ❤
The BEST API Tutorial I have ever seen. Thanks Pat, your explanation is pretty straight forward and simple to understand. 👍
Truly a simplified explanation. I smiled almost throughout the study process.
Tutorial was going so well until 13:20 (thank you!) but when you copied the SQL connection string there was no explanation as to where it came from or how to build it ourselves. Any chance of some clarification in a pinned comment please?
**UPDATE** thanks to Bảo Trần Quốc for this: "Server=localhost\\SQLEXPRESS;Database=master;Trusted_Connection=True;"
thanksss saved me there
this worked for me, thank you :)
"Server=DESKTOP-ST292FS\\MSSQLSERVER01;Database=IssueDB;Trusted_Connection=True;TrustServerCertificate=True"
I am getting a network error when i update the database..
Finally I made my first working version of RestFul API.
Thanks to You... Amazing explanation... Subscribing to the channel right now!
Fantastic tutorial, thanks! I was able to get my first C# API up and running easily with this information.
Awesome tutorial! Sometimes you find someone that breaks things down in a way that's easy to just grasp and run with. Took some digging to find this though so hopefully it gets to the top of the ranks eventually.
You are amazing. Absolutely enjoyed watching your tutorial and it was very informative. You've got yourself a new subscriber
I love the way this guy creates tutorial. It's somehow really easy to follow along.
Your Teaching is Clear. You just earned a new subscriber
I have stumbled upon a gold mine! Thank you so much Pat!
this is awesome, really appreciate it mate, plz keep uploading
This is very useful and precise explanation.
No time wastage, complete and to-the-point. Thank you for your efforts.
Even though this video has a lot of "issues", is still a good one!👌
thank you for explaining everything !! will come back to this
This tutorial is awesome. very clear and informative. I got whatever I needed in your 33 minutes of your tutorial.
Charming TechWithPat always love his tutorials. Appreciate!
Very Good Tutorial for Web Api .NET 6.0
Thank you.
Must say that you are great at explaining this in detail while keeping it simple! Great work and thanks
Parabens...Brasil na área.....até agora o MELHOR VÍDEO disponível com todos os processos do ZERO ao HERO. GRATIDÃO!!!
Thanks my friend, your video helped me. I only wish your project to consume the API was a MVC Core web app! Nevertheless, thank you! 👍
Very nice tutorial. Informative. Very clearly explained
Hey, thanks for this. 13:50 can I ask whether it's safe to use an existing database with existing content when doing the migration? I want to make an API with my existing data, rather than create a new database. Is this possible?
Nice explaining Pat. Thanks . Appreciate it.
Well done man. You're a great teacher. Keep up the good work.
Good one
I think I love you. Was lost but not I'm found. Thank you!
at 13:20 what should I add as text? I'm not sure I followed this step
if you are all wondering regarding on connection strings at 13:10 if you are using Visual Studio, go to 'View' click 'Properties Window' then on the side you will see a tab.. then on 'General' category you will see Connection String
@@timothybasalo4038 it doesnt show anyrhing can u give me some more info
Thank's for this amazing tutorial
very clear explanations, thank you
This is a great tutorial. Thank you. Just a thought why one would create a api THEN add an app IN the backend?
Thanks, great video.
If you are getting this error while trying POST
"---> Microsoft.Data.SqlClient.SqlException (0x80131904): Cannot insert explicit value for identity column in table 'Issues' when IDENTITY_INSERT is set to OFF."
Don't give an id to that data.
Good Video, Thanks !!
Where can I find my SQLServer path like you did at 13:21 ?
Have you find it? I also have same problem.
@Djonathon Oliveira Create a database on something like MS Azure, then under Connection strings, it should be generated for you. I think the guy in the video has a local database, which is why the source says his computer ID.
how are we suppossed to get the same connection string and where did u get it from?
this is a great tutorial. Thank u
Thanks for the tutorial..
Nice to see more videos like that
Good stuff 🎉
how do you get the connection string?
use this bro
Server=localhost\\SQLEXPRESS;Database=master;Trusted_Connection=True;
@@Tcgmaster808 but, we need to install SQL Express. that was not explained, I think
Did you make another video where you showed how you set up the database too?
I don't understand why we need to put the id in the header and also the body. What is the purpose ? Could we not put either in the header or the body ? Thanks.
13:17 - "...and then draw the rest of the owl!" 🤨 It would be nice to know where you got the SqlServer string from. Am I supposed to already have some sort of Sql Server instance running on my machine? Where did you download it from? How did you install and run it? I would greatly appreciate any help here.
awesome 🙂 thank you
good tuto for beginning
Perfect tutorial. Thanks a lot :-)
25:20 Can I ask why you don't use _context.Issues.Update(issue); ? Are they the same or any difference between the two?
What a great tutorial, It really helped me a lot!
but, is it possible to connect this to a frontend like angular, if so, I would Appreciate knowing the procedure behind it.
Thanks.
thanks Noel, I have a video about Web Api and Angular coming soon
@@TechWithPat Thank you, I'm looking forward to it.
You are amazing !!!
i'm geting an error when Update-Database, A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SNI_PN11, error: 25 - Connection string is not valid). how to solve that?
Awesome!
Thank you, learnt new things.
Does dotnet 6 follow the same process of repository pattern like dotnet 5?
Hi, Thank you very much for the tutorial!
I have one question which is how do i find my sql server's id for a macbook air user?
Hi Pat, wonderful tutorial! Do you have videos on consuming web APIs that has authentication, both basic and JWT? Thanks
ruclips.net/video/LZJvdFDCKxM/видео.html
can u help me...i am unable to create connection string
Wonderful! Thank you Pat!
Hlo sir can u help...how to create connection string
Well done, Thank you Pat
Man you awesome. Can you make a tutorial about sending requests from React and have C# on the backend as well ?
Have you found any tutorials?
@@DoramaMoments228 Nope
Subscribed.
thanks a lot.
But how did you got that database connectionString ??? there is no ef modal wizard to get that string from then how to get it !????
Great job! Thanks 😊
Great tutorial!
thank you bro you're the best
Thank you, great tuto really helpful.
thank you for your tutorial
Really well done!
Is there a link for that that db?
Thank you ❤
13:25 Do we use the same connection?
Super cocol video ! thx. What about if I Want an extra url like "api/Issue/EXAMPLE/id". How can I make that ?
Man you are a saver! This tutorial is so clean and easy to understand!sub
Thanks man..
Thank you! Could you explain "var issueToDelete = await _content.Issues.FindAsync(id);"? Why do you use async-method, if your main code is waiting for it to get the value for var issueToDelete ? It will still run in sync, won't it?
You have to think from the perstective of the caller of the delete method, the advantage of using async is that the main thread is not blocked.
18:23 "click on it", why swagger freezes when trying to open a request?
So this perfect example of building an api in c# can this be a point of reference always
How to add authentication to prevent requests from unknown sources?
Many thanks
unable to create migration saying Add is not correct cmdlin word why sir n
are you on udemy ?
Everything was clear until you added a connection string without any explanation for beginners on how to get it.
Doing this is very discouraging for beginners and should not be so if it is a "for beginners" tutorial
I think that we need to install SQL Express. that was not explained, I think. He just blew past it
@@westter3672 one would expect someone learning about web apis to have some sort of experience, especially with things as basic as connection strings
thanks for the video, any chance for a guide for mac m1 users ?
No, because Mac just sucks so badly!!! Ask Apple to provide you with their own version of Visual Studio ! :) :)
in 15:17, i had ran the command, but when i checked the database, i don't see the database created...
I fixed it, I change the SqlStringConnection in file appsetting.json, and my conn string is: "Server=localhost\\SQLEXPRESS;Database=master;Trusted_Connection=True;" , if anyone meet this bug then guy can use it as a template ... thanks !!!
can anyone tell me how do we get this connection string? 13:21
that is where I am, too
Where is the copy 9f that database???
This makes JavaScript look like nursery
Thank you
Thanks for this great tutorial. I have a question that can we use WebAPI with a UI project? When I made a research on the Internet, I have seen that WebAPI is compatible for phones, tablets, and pcs. Also, I have watched many tutorials and most of them shows how to run WebAPI from the URL part. I mean, about entering the id and getting the data. But I think it is not practical for an end user to use the URL for every request, right? Is there any technology combined with web api or is it just a kind of research topic? How can we use it for a GUI Web project? Thanks in advance!
Any GUI app can use an http client and call a web api. In the future, I will try to make video showcasting Web api and other frameworks.
Would be great to consume it with angular
@@TechWithPat Thank you so much! I am waiting for your new informative video :)
An exception of type 'System.Text.Json.JsonException' occurred in System.Private.CoreLib.dll but was not handled in user code
The JSON value could not be converted to System.Collections.Generic.IEnumerable`1[test_api.User].
Can someone help please
Help, error update-database => A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - La cadena de certificación fue emitida por una entidad en la que no se confía.)
did you find solution?
Thx!
Please I have an important question, I'm blocked. HOW DO I GET MY CONNECTION STRING??
why the startup.cs file is not created
In his video, I believe Startup.cs (where the configurations are made) is combined into Program.cs
Because .NET 6 is not using one anymore.
That is new on net 6
Rider doesn't provide a NuGet Package Management Console anymore :(
Wakanda forever