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!
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 😅
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!
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.
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?
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.
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 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 ?
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.
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.
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.
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 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.
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.
@@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.
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
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.
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
Fantastic... Underrated content... To the point, clear and covers everything beautifully
The best tutorial regarding Az Functions.
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!
I can't find other words to say thank you. You special!
Wow, thank you!
This is one of the best tutorials I have found on API Azure Functions, great work.
Glad it was helpful!
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!
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.
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.
You are divine! This is so helpful. Thank you.
thank you guru! subscribed you and learned something from you today. you are the best!
This tutorial is really helpfull for those who started carrier as azure developer like me . Thanks a ton....
Great video! thanks! it was very understandable and with a nice pace.
Glad you liked it!
Thank you sir very beautifully explained....
Very nice and easy explanation. Thanks..
Excellent video.
Amazing work!
Thank you! Cheers!
Good explanation..thanks
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 for awesome sharing
Thanks for watching
Nice Work
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?
Hey! Do you have a video that cover the auth topic for the functions? Thanks, Great video!
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.
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 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 ?
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!
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.
If you please create some more topics on azure service bus integration with azure function would be very helpful
Nice video, can i use minimal api in azuee function?
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.
Very good video. Also make a video on service fabric. Deploy the app there as well.
Will try. Thank you for the visit.
Thank you
You're welcome
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.
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 video is the nicer that i found. But still confuse for me. AWS look like more simple.
Thanks. Did you use Azure SQL?
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 ?
Great content... than you. But it's hard to pay attention with the background music 😕
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.
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.
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.
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.
Can i call the stored procedures of SQL Server of Azure via serverless functions?
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
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 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)
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.
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.
The very importat part is omitted, I mean migration.
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!
Handsome man
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
Excellent video.
Glad you liked it!