This video is fantastic! Pure gold! It finally answers all the (head scratching) pieces that are needed to put together a full serverless api. I also very much appreciate how your videos have no fluff, and are meat-and-potatoes and pedal-to-the-metal all the way, which is great for someone like me who has very limited time and can learn fast. Cheers!
Really good video. A good follow-up might be explaining the objects you created beforehand, especially the "sql" secret since the app won't run without that part working. I'm not asking for an in-depth code-first migrations video, but a database first explanation so new people can get this app up and running. Excellent work!
Straight to the point Delivering the actual good stuff without anything irrelevant So much value and knowledge shared directly 😂 I can't thank you enough
I know that you mentioned doing migrations with EF Core could be difficult. But I wanted to let folks know that scaffolding with EF Core works very easily with Azure Functions. I feel like database first is more typical in production environments so I wanted to point that out.
Randomly saw this today, to check my understanding, covered everything in a short video. I generally don't comment, but great work 😀. Now will see more videos here 😅
20:11 would it be possible to create two separate method for the get and the post by only changing the attribute and use "get" for the first one and "post" for the second one? This way, each method do only one thing.
Great video, so much to learn here. I just have one doubt, in connection string you did specify vault key only, not db credentials then how it is connected to SQL Server, is the data comes from Azure or SQL ?
I really like this video. But its a bit hard to follow. Is it possible you could help a bit with the DB setup. I am unsure about some configurations. I know how to do a code first approach, and then migrate, but what about firewall settings and KeyVault setting in the SQL server, and SQL database ?
Thank you for the great tutorial. I don't know why many tutorial is only showing the unsecure way. Why can we do one that show actual authenticated request?
Thank you for your video on this in-process model. If possible can do a video on isolated-model how DI is to be and how to inject or register project reference library in azure functions. I am getting a lot of DI issues similar like this. Exception: System.InvalidOperationException: Unable to resolve service for type 'System.IRequestContext' while attempting to activate 'MyFunctionApp.AntiVirus.FileScanService'. I used IRequestContext in FileScanService and this issue is coming in my azure function when i inject my my IFileScanService. Kindly help me here on how to fix this
Great video! I have a question - how to use azure key vault when we specify something in the input binding like service bus queue trigger where queue name and connection string is supposed to be taken from azure key vault. Any help on this would be really appreciated.
Excellent video, thank you! I would like to see how you setup the database, and manage it outside of the Azure Functions. Also, you're using Visual Studio here, and not Rider. Is this functionality not supported in Rider?
There was nothing to fancy with the database. I had another ASP.NET Core Minimal API proiect where I have registered the DbContext. I have run a migration and then updated the database. Rider also supports these functionalities. I have done all the documentation part of the video on Rider. However, the UI for creating Azure Functions and other small details are different. But, as there were some UI differences and most people from the audience will use Visual Studio, I thought of also using it to keep everythin as clear as possible.
Can you also give some arguments for your recommendation. I had some real challenges with isolated workers in real production applications. First of, custom bindings are nod directly supported. Even though possible, it's a real pain. We needed Custom trigger definitions for Azure Service Bus triggers using NServiceBus message handlers. Also, I have experienced some targeting problems when using certain libraries or SDKs, when we needed to create dedicated assemblies for certain classes that were targeting two different dotnet runtimes. I don't recall the exact specifics, but this workaround was suggested in some GH issues by MS folks. Another bad experience I had with isolated workers is that they ran out of memory at a certain point and it took us a lot of troubles to actually find the root cause for why the function simply stopped working. Due to these reasons I admit I have a slight preference for in-process workers.
I keep getting an error when running the application locally and I submit a post request with the name and price. It says Executed “ProductsGetAllCreate” failed. Exception while executing function. Format of the initialization string does not conform to the specification starting at index 0.
Great video! Showing how to do local testing is exactly what I was looking for! I would like to use Dapper instead of Entity Framework. Is that possible?
That's what I also thought initially. But if you insall EF7 in the exact same setup you will get errors on build that suggest target mismatches because of some other librarbies that both .NET 6 and EF7 relies. Als I have found that this is a common issue and SO is full of issues like this. The answer was pretty much always to use EF 6. If you have more insights into this and cand share how exactly we can make it work running .NET 6 anf EF7, please share it. I'd appreciate it a lot.
Please how to fix that ; System.Private.CoreLib: Exception while executing function: ProductsGetAllCreate. Microsoft.Data.SqlClient: Format of the initialization string does not conform to specification starting at index 0.
Hi, any chance you might have done the video for running migrations in azure sql db? Thanks for this video, it's exactly what I have been looking for. I'm pro Code First Approach and this video is a good start.
I haven't done a video on this specific topic. What is the challenge that you have? Running migrations in azure sql (or just updating the database, to be more precise) works exactly the same. You just need to provide the connection string to your Azure SQL database and then run update-database from package manager console. P.S: Thanks for joining the membership program.
@@Codewrinkles Thanks for the fast response. I'm getting this error: Azure.Identity.CredentialUnavailableException: 'DefaultAzureCredential failed to retrieve a token from the included credentials.
That's actually a very good question. What I want to point out is that if you need to build an API for an application I wouldn't recommend using Azure Functions for that. It's simply not scalable and the intent of serveless computing is not to replac eyour APIs. I would therefore use Azure Functions for background processing, for simple and standalone web hooks and other cross cutting concerns, to offload your API.
Hello. I am a beginner trying to learn more about Azure functions. Can i follow this tutorial and make use of Azure functions for free, as long as its only a small personal hobby project ? I think its kind of hard to see through the Azure payment model. I just want to avoid getting a big bill after following the tutorial ?
How is this getting related to the database table product? I don't see anywhere where this connects to it... I only see the DBContext but nowhere do you specify a table name of sorts
Something's odd. This video is not that old.Just a few months back. Nothing was released in the meantime. I just checked and I can still find these packages.
@@Codewrinkles I figured out what I did wrong. I am currently trying to debug and getting the error message "Microsoft.Azure.WebJobs.Script: Error configuring services in an external startup class. Azure.Security.KeyVault.Secrets: A secret with (name/id) sql was not found in this key vault." I think this is referencing the Startup code but I don't know how to fix it.
@@Codewrinkles Can you please create in-depth video on tweaks related to designTimeFactory as you said in this video. It'll much appreciated as my current project using it and I'm having difficulty understanding it. Thank you in advance!
@@bloopers2967 I am really considering it, but i can't promise a timeline for this. I'll need to define a story around it, but it's definitely on my ToDo list.
This video is fantastic! Pure gold! It finally answers all the (head scratching) pieces that are needed to put together a full serverless api. I also very much appreciate how your videos have no fluff, and are meat-and-potatoes and pedal-to-the-metal all the way, which is great for someone like me who has very limited time and can learn fast. Cheers!
Really appreciate your feedback. I'm glad you enjoyed it.
precisely described what i also felt
Really good video. A good follow-up might be explaining the objects you created beforehand, especially the "sql" secret since the app won't run without that part working. I'm not asking for an in-depth code-first migrations video, but a database first explanation so new people can get this app up and running. Excellent work!
Honsetly this has been the best, most practical training I have ever seen in Azure functions. Respect!!!
Straight to the point
Delivering the actual good stuff without anything irrelevant
So much value and knowledge shared directly
😂 I can't thank you enough
I know that you mentioned doing migrations with EF Core could be difficult. But I wanted to let folks know that scaffolding with EF Core works very easily with Azure Functions. I feel like database first is more typical in production environments so I wanted to point that out.
The best tutorial regarding Az Functions.
Fantastic... Underrated content... To the point, clear and covers everything beautifully
I can't find other words to say thank you. You special!
Wow, thank you!
Randomly saw this today, to check my understanding, covered everything in a short video. I generally don't comment, but great work 😀. Now will see more videos here 😅
Glad you enjoyed it!
Loving these C# and Azure videos. Looking forward to learning more from you.
I'm glad to hear. There will be one Azure video each Sunday or Monday till at least the end of the year.
This is one of the best tutorials I have found on API Azure Functions, great work.
Glad it was helpful!
20:11 would it be possible to create two separate method for the get and the post by only changing the attribute and use "get" for the first one and "post" for the second one? This way, each method do only one thing.
This tutorial is really helpfull for those who started carrier as azure developer like me . Thanks a ton....
Thank you. I really enjoyed your vide.
I think sql setup is missing in this video. How do you setup the azure sql for Functions?
You are divine! This is so helpful. Thank you.
Hey! Do you have a video that cover the auth topic for the functions? Thanks, Great video!
Great video! thanks! it was very understandable and with a nice pace.
Glad you liked it!
Great video, so much to learn here. I just have one doubt, in connection string you did specify vault key only, not db credentials then how it is connected to SQL Server, is the data comes from Azure or SQL ?
I really like this video. But its a bit hard to follow. Is it possible you could help a bit with the DB setup. I am unsure about some configurations. I know how to do a code first approach, and then migrate, but what about firewall settings and KeyVault setting in the SQL server, and SQL database ?
Very nice and easy explanation. Thanks..
thank you guru! subscribed you and learned something from you today. you are the best!
Thank you sir very beautifully explained....
Nice video, can i use minimal api in azuee function?
Great video! Thanks a lot!
Thanks for awesome sharing
Thanks for watching
Thank you for the great tutorial. I don't know why many tutorial is only showing the unsecure way. Why can we do one that show actual authenticated request?
Great vid thanks
but i want consume those api links on my project to get data and post it into my database how can do it ?
Thank you for your video on this in-process model. If possible can do a video on isolated-model how DI is to be and how to inject or register project reference library in azure functions. I am getting a lot of DI issues similar like this.
Exception: System.InvalidOperationException: Unable to resolve service for type 'System.IRequestContext' while attempting to activate 'MyFunctionApp.AntiVirus.FileScanService'.
I used IRequestContext in FileScanService and this issue is coming in my azure function when i inject my my IFileScanService.
Kindly help me here on how to fix this
You have to register your service in the setup class so that you can activate the class that needs it (constructor)
Great video! I have a question - how to use azure key vault when we specify something in the input binding like service bus queue trigger where queue name and connection string is supposed to be taken from azure key vault. Any help on this would be really appreciated.
Excellent video, thank you! I would like to see how you setup the database, and manage it outside of the Azure Functions.
Also, you're using Visual Studio here, and not Rider. Is this functionality not supported in Rider?
There was nothing to fancy with the database. I had another ASP.NET Core Minimal API proiect where I have registered the DbContext. I have run a migration and then updated the database.
Rider also supports these functionalities. I have done all the documentation part of the video on Rider. However, the UI for creating Azure Functions and other small details are different. But, as there were some UI differences and most people from the audience will use Visual Studio, I thought of also using it to keep everythin as clear as possible.
Can i call the stored procedures of SQL Server of Azure via serverless functions?
Amazing work!
Thank you! Cheers!
thank you about the video , i would recommand to use the other fasion witch is azure function in an isolated worker process
Can you also give some arguments for your recommendation. I had some real challenges with isolated workers in real production applications.
First of, custom bindings are nod directly supported. Even though possible, it's a real pain. We needed Custom trigger definitions for Azure Service Bus triggers using NServiceBus message handlers.
Also, I have experienced some targeting problems when using certain libraries or SDKs, when we needed to create dedicated assemblies for certain classes that were targeting two different dotnet runtimes. I don't recall the exact specifics, but this workaround was suggested in some GH issues by MS folks.
Another bad experience I had with isolated workers is that they ran out of memory at a certain point and it took us a lot of troubles to actually find the root cause for why the function simply stopped working.
Due to these reasons I admit I have a slight preference for in-process workers.
Thank you for the video and awesome channel. One recommendation: the background music is a bit distracting. Your voice is fine by itself :)
Thanks for the tip!
Excellent video.
Glad you liked it!
I keep getting an error when running the application locally and I submit a post request with the name and price. It says Executed “ProductsGetAllCreate” failed. Exception while executing function. Format of the initialization string does not conform to the specification starting at index 0.
Great video! Showing how to do local testing is exactly what I was looking for! I would like to use Dapper instead of Entity Framework. Is that possible?
Thanks. Did you use Azure SQL?
Great video, but EFCore 7 targets .NET6 so there is no reason to choose version 6 when installing the nugget package.
That's what I also thought initially. But if you insall EF7 in the exact same setup you will get errors on build that suggest target mismatches because of some other librarbies that both .NET 6 and EF7 relies. Als I have found that this is a common issue and SO is full of issues like this. The answer was pretty much always to use EF 6. If you have more insights into this and cand share how exactly we can make it work running .NET 6 anf EF7, please share it. I'd appreciate it a lot.
If you please create some more topics on azure service bus integration with azure function would be very helpful
Please how to fix that ; System.Private.CoreLib: Exception while executing function: ProductsGetAllCreate. Microsoft.Data.SqlClient: Format of the initialization string does not conform to specification starting at index 0.
Will you please do a video on Unit testing on serverless rest Api Azure functions
I'm not sure unit testing functions themselves would be useful. I'd integration test them.
Very good video. Also make a video on service fabric. Deploy the app there as well.
Will try. Thank you for the visit.
Good explanation..thanks
Hi, any chance you might have done the video for running migrations in azure sql db? Thanks for this video, it's exactly what I have been looking for. I'm pro Code First Approach and this video is a good start.
I haven't done a video on this specific topic. What is the challenge that you have? Running migrations in azure sql (or just updating the database, to be more precise) works exactly the same. You just need to provide the connection string to your Azure SQL database and then run update-database from package manager console.
P.S: Thanks for joining the membership program.
@@Codewrinkles Thanks for the fast response. I'm getting this error:
Azure.Identity.CredentialUnavailableException: 'DefaultAzureCredential failed to retrieve a token from the included credentials.
This video is the nicer that i found. But still confuse for me. AWS look like more simple.
awesome video as usual - three thumbs up - Could you highlight some pros and cons in terms of speed, cost etc. of using AF vs WebAPI? Thx
That's actually a very good question. What I want to point out is that if you need to build an API for an application I wouldn't recommend using Azure Functions for that. It's simply not scalable and the intent of serveless computing is not to replac eyour APIs. I would therefore use Azure Functions for background processing, for simple and standalone web hooks and other cross cutting concerns, to offload your API.
Hello. I am a beginner trying to learn more about Azure functions. Can i follow this tutorial and make use of Azure functions for free, as long as its only a small personal hobby project ? I think its kind of hard to see through the Azure payment model. I just want to avoid getting a big bill after following the tutorial ?
You won't get a big bill, but unfortunately there is also no free tier to chose from :(
How to call Ef core operations in azure timer function ? Any help would be appreciated.
You have dependency injection in Azure Functions, so you do it similarly.
Hi , Can you please share source code of this sample
How is this getting related to the database table product? I don't see anywhere where this connects to it... I only see the DBContext but nowhere do you specify a table name of sorts
Nice Work
Is this still current with NuGet installs? I can’t find Azure Identity, Azure Security, Azure Functions Extensions or Microsoft EntityFramework Core
Something's odd. This video is not that old.Just a few months back. Nothing was released in the meantime. I just checked and I can still find these packages.
@@Codewrinkles I figured out what I did wrong. I am currently trying to debug and getting the error message
"Microsoft.Azure.WebJobs.Script: Error configuring services in an external startup class. Azure.Security.KeyVault.Secrets: A secret with (name/id) sql was not found in this key vault." I think this is referencing the Startup code but I don't know how to fix it.
I figured out what I did wrong again. Great video and thanks for responding!!! Subscribed on both my YT accounts!
Very good video
Thanks for the visit
@@Codewrinkles Can you please create in-depth video on tweaks related to designTimeFactory as you said in this video. It'll much appreciated as my current project using it and I'm having difficulty understanding it. Thank you in advance!
I'm waiting for this video sir
@@bloopers2967 I am really considering it, but i can't promise a timeline for this. I'll need to define a story around it, but it's definitely on my ToDo list.
@@Codewrinkles thank you, take your time mate
Great content... than you. But it's hard to pay attention with the background music 😕
It is really great tutorial. Do you share source code some where?
Ambassador members get the source code after each video. So, to gain access to the source code, you need do become a member. Link in the description.
Thank you
You're welcome
The very importat part is omitted, I mean migration.
la crême de la crême, thank you
Glad you enjoyed it. Also take a look to the newest video about workflow orchestration with Azure Durable Functions. MIght be interesting as well.
Given your heavy accent and rapid speech, I find this video rather challenging to follow, making it less useful for me.
Wow, that's some very constructive feedback. Thanks
Handsome man
Excellent video.