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!
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;"
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 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
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.
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.
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?
@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'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?
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.
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?
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 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!
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!
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
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..
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!
The simplicity of this tutorial showed me you have a lot of experience working with this technology and frameworks. ❤
Truly a simplified explanation. I smiled almost throughout the study process.
The BEST API Tutorial I have ever seen. Thanks Pat, your explanation is pretty straight forward and simple to understand. 👍
Fantastic tutorial, thanks! I was able to get my first C# API up and running easily with this information.
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
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
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.
I love the way this guy creates tutorial. It's somehow really easy to follow along.
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
Finally I made my first working version of RestFul API.
Thanks to You... Amazing explanation... Subscribing to the channel right now!
This is very useful and precise explanation.
No time wastage, complete and to-the-point. Thank you for your efforts.
I have stumbled upon a gold mine! Thank you so much Pat!
Must say that you are great at explaining this in detail while keeping it simple! Great work and thanks
this is awesome, really appreciate it mate, plz keep uploading
Even though this video has a lot of "issues", is still a good one!👌
Your Teaching is Clear. You just earned a new subscriber
This tutorial is awesome. very clear and informative. I got whatever I needed in your 33 minutes of your tutorial.
thank you for explaining everything !! will come back to this
Charming TechWithPat always love his tutorials. Appreciate!
Good Video, Thanks !!
Parabens...Brasil na área.....até agora o MELHOR VÍDEO disponível com todos os processos do ZERO ao HERO. GRATIDÃO!!!
Very Good Tutorial for Web Api .NET 6.0
Thank you.
Good one
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! 👍
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?
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.
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?
Nice explaining Pat. Thanks . Appreciate it.
I think I love you. Was lost but not I'm found. Thank you!
Well done man. You're a great teacher. Keep up the good work.
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
Very nice tutorial. Informative. Very clearly explained
very clear explanations, thank you
Thank's for this amazing tutorial
Wakanda forever
This makes JavaScript look like nursery
Nice to see more videos like that
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.
Thanks for this great tutorial
this is a great tutorial. Thank u
Thanks for the tutorial..
Well done, Thank you Pat
Wonderful! Thank you Pat!
Hlo sir can u help...how to create connection string
Thank you, learnt new things.
Perfect tutorial. Thanks a lot :-)
Really well done!
Great job! Thanks 😊
good tuto for beginning
Great tutorial!
how are we suppossed to get the same connection string and where did u get it from?
Thank you, great tuto really helpful.
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.
Good stuff 🎉
thank you bro you're the best
Subscribed.
awesome 🙂 thank you
Awesome!
thank you for your tutorial
This is a great tutorial. Thank you. Just a thought why one would create a api THEN add an app IN the backend?
You are amazing !!!
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
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.
Did you make another video where you showed how you set up the database too?
Does dotnet 6 follow the same process of repository pattern like dotnet 5?
Thank you ❤
But how did you got that database connectionString ??? there is no ef modal wizard to get that string from then how to get it !????
Many thanks
Thanks man..
thanks a lot.
Super cocol video ! thx. What about if I Want an extra url like "api/Issue/EXAMPLE/id". How can I make that ?
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?
Please I have an important question, I'm blocked. HOW DO I GET MY CONNECTION STRING??
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?
@@wotrezka331 Nope
So this perfect example of building an api in c# can this be a point of reference always
can anyone tell me how do we get this connection string? 13:21
that is where I am, too
Thank you
13:25 Do we use the same connection?
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.
25:20 Can I ask why you don't use _context.Issues.Update(issue); ? Are they the same or any difference between the two?
Thx!
18:23 "click on it", why swagger freezes when trying to open a request?
unable to create migration saying Add is not correct cmdlin word why sir n
How to add authentication to prevent requests from unknown sources?
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
Is there a link for that that db?
Where is the copy 9f that database???
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?
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 !!!
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 ! :) :)
Rider doesn't provide a NuGet Package Management Console anymore :(
are you on udemy ?
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 :)
You showed us how to GET something in a client, but you never showed us how to POST DELETE or PUT something, how?