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