Azure Database for MySQL bindings for Azure Functions (General Availability)
We’re thrilled to announce the general availability (GA) of Azure Database for MySQL Input and Output bindings for Azure Functions—a powerful way to build event-driven, serverless applications that seamlessly integrate with your MySQL databases. Key Capabilities With this GA release, your applications can use: Input bindings that allow your function to retrieve data from a MySQL database without writing any connection or query logic. Output bindings that allow your function to insert or update data in a MySQL table without writing explicit SQL commands. In addition you can use both the input and output bindings in the same function to read-modify-write data patterns. For example, retrieve a record, update a field, and write it back—all without managing connections or writing SQL. These bindings are fully supported for both in-process and isolated worker models, giving you flexibility in how you build and deploy your Azure Functions. How It Works Azure Functions bindings abstract away the boilerplate code required to connect to external services. With the MySQL Input and Output bindings, you can now declaratively connect your serverless functions to your Azure Database for MySQL database with minimal configuration. You can configure these bindings using attributes in C#, decorators in Python, or annotations in JavaScript/Java. The bindings use the MySql.Data.MySqlClient library under the hood and support Azure Database for MySQL Flexible Server. Getting Started To use the bindings, install the appropriate NuGet or npm package: # For isolated worker model (C#) dotnet add package Microsoft.Azure.Functions.Worker.Extensions.MySql # For in-process model (C#) dotnet add package Microsoft.Azure.WebJobs.Extensions.MySql Then, configure your function with a connection string and binding metadata. Full samples for all the supported programming frameworks are available in our github repository. Here is a sample C# in-process function example where you want to retrieve a user by ID, increment their login count, and save the updated record back to the MySQL database for lightweight data transformations, modifying status fields or updating counters and timestamps. public class User { public int Id { get; set; } public string Name { get; set; } public int LoginCount { get; set; } } public static class UpdateLoginCountFunction { [FunctionName("UpdateLoginCount")] public static async Task<IActionResult> Run( [HttpTrigger(AuthorizationLevel.Function, "post", Route = "user/{id}/login")] HttpRequest req, [MySql("SELECT * FROM users WHERE id = @id", CommandType = System.Data.CommandType.Text, Parameters = "@id={id}", ConnectionStringSetting = "MySqlConnectionString")] User user, [MySql("users", ConnectionStringSetting = "MySqlConnectionString")] IAsyncCollector<User> userCollector, ILogger log) { if (user == null) { return new NotFoundObjectResult("User not found."); } // Modify the user object user.LoginCount += 1; // Write the updated user back to the database await userCollector.AddAsync(user); return new OkObjectResult($"Login count updated to {user.LoginCount} for user {user. Name}."); } } Learn More Azure Functions MySQL Bindings Azure Functions Conclusion With input and output bindings for Azure Database for MySQL now generally available, building serverless apps on Azure with MySQL has never been simpler or more efficient. By eliminating the need for manual connection management and boilerplate code, these bindings empower you to focus on what matters most: building scalable, event-driven applications with clean, maintainable code. Whether you're building real-time dashboards, automating workflows, or syncing data across systems, these bindings unlock new levels of productivity and performance. We can’t wait to see what you’ll build with them. If you have any feedback or questions about the information provided above, please leave a comment below or email us at AskAzureDBforMySQL@service.microsoft.com. Thank you!
unable to create a project azure devops 2019 on premises
I have azure DevOps server on-premises, and I want to create a new project but I can't. even though I'm using the admin account. I can create a new collection, but I can't create new projects, here's the log when I check it ++ Executing - Operation: ProjectCreate, Group: ProjectCreate.TfsTeamBuild [09:35:38.947] +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ [09:35:38.947] Executing step: Create the Team Project [09:35:38.947] Executing step: 'Create the Team Project' Build.CreateTeamProject (7 of 12) [09:38:43.323] [Error] The file exists. [09:38:43.427] System.IO.IOException: The file exists. [09:38:43.427] at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath) [09:38:43.427] at System.IO.Path.InternalGetTempFileName(Boolean checkHost) [09:38:43.427] at Microsoft.TeamFoundation.Build.Server.ProcessTemplate.UpdateCachedProcessParameters(IVssRequestContext requestContext, VersionSpec versionSpec) [09:38:43.427] at Microsoft.TeamFoundation.Build.Server.TeamFoundationBuildService.AddProcessTemplates(IVssRequestContext requestContext, IList`1 processTemplates) [09:38:43.427] at Microsoft.TeamFoundation.Build.Server.TeamFoundationBuildService.CreateBuiltInProcessTemplates(IVssRequestContext requestContext, String teamProjectUri, Boolean isUpgrade) [09:38:43.427] at Microsoft.TeamFoundation.Build.Server.TeamFoundationBuildService.CreateTeamProject(IVssRequestContext requestContext, String projectUri, IList`1 permissions) [09:38:43.427] at Microsoft.TeamFoundation.Server.Servicing.TFCollection.BuildStepPerformer.CreateTeamProject(ServicingContext servicingContext) [09:38:43.427] at Microsoft.TeamFoundation.Framework.Server.TeamFoundationStepPerformerBase.PerformHostStep(String servicingOperation, ServicingOperationTarget target, IServicingStep servicingStep, String stepData, ServicingContext servicingContext) [09:38:43.427] at Microsoft.TeamFoundation.Framework.Server.TeamFoundationStepPerformerBase.PerformStep(String servicingOperation, ServicingOperationTarget target, String stepType, String stepData, ServicingContext servicingContext) [09:38:43.427] at Microsoft.TeamFoundation.Framework.Server.ServicingStepDriver.PerformServicingStep(ServicingStep step, ServicingContext servicingContext, ServicingStepGroup group, ServicingOperation servicingOperation, Int32 stepNumber, Int32 totalSteps) [09:38:43.427] Step failed: Create the Team Project. Execution time: 3 minutes and 4 seconds. [09:38:43.427] [StepDuration] 184.3850653 [09:38:43.427] [GroupDuration] 184.4857136 [09:38:43.777] [OperationDuration] 204.5521056 [09:38:43.787] Clearing dictionary, removing all items But there's no existing file the project name is unique. any kind of support it'll be appreciated thanks & regards
Visualizing meeting room availability using Microsoft365 and LoraWan BusyLight
Visualizing meeting room availability using Microsoft 365 and LoraWan Kuando BusyLight. Send downlink messages to The Things Network Lora backend via Azure Functions based on LogicApps actions. Read the full story at: https://sandervandevelde.wordpress.com/2023/10/19/visualizing-meeting-room-availability-with-outlook-and-lorawan-busylight/
How to connect Azure Function App to On-prem DNS Server?
I am creating a .NET application that validates domain from an on-prem DNS server. I would like to know how can I integrate my Azure function app to perform nslookup on the on-prem DNS server. Is there a way without using virtual networks or powershell script?Set-PnPUserProfileProperty with Application Permission in Azure Function
When using Set-PnPUserProfileProperty in Azure Function with Power Shell and the permissions has been defined using the Application Permission. Once connected to the admin site URL using client id, tenant and cert and try to update the User Profile Property, it throws the below error Access denied. You do not have permission to perform this action or access this resource. Attached the screenshot for the reference Below are the permissions given for the application in Azure API Permissions Hope someone already have a solution!
Connect-PnPOnline in Azure function : parameter 'Url' because it is null
Dear community, Connect-Pnponline command is not accpting in Azure function, Always gettings below error "Cannot bind argument to parameter 'Url' because it is null." * the same script is working in local system. I followed MS guide to resolve the issue but no luck. appriciate your help and ides to solve the issue. https://learn.microsoft.com/en-us/sharepoint/dev/declarative-customization/site-design-pnp-provisioning#upload-the-pnp-powershell-module-for-your-azure-function,Automatic Grading with Azure OpenAI Services ChatGPT Virtual Assistant
Don’t waste your time grading assignments by hand. Let AI do it for you! Learn how our AI virtual assistant can help students and teachers with their assignments in a fair, effective, and eco-friendly way. Plus, discover the secrets of choosing the best model, parameter, and prompt design for your tasks. ChatGPT 4 is not always the best option!
Trigger ADF pipeline using Storage event trigger over private network.
Project Technology: Azure function, ADF, Azure Synapse, ADLS Issue description: Customer has a strict regulatory compliance requirement, due to which they need to block all outbound (public endpoint) connections. Hence, most of our products were not able to provide the expected result as we have a dependency on public endpoints.No Metrics in Application Insights
I have a web app hosted in Azure. I created function apps and app service with application insights enabled on each resource. As you can see from the screenshot of my app service, there is a metric data: But when I checked its application insights, there are no data in the metrics: I also checked traces from the logs and there are data being logged. I would like to know why data is not reflected on the application insights. The instrumentation key are matched with the app settings of function app/app service. Hope you can help me on this issue. Thanks!
