Run .exe executable file in Azure Function

by

Is it possible to create Azure Function for abcd.exe and run it in Azure Cloud Functions?

Yes, we can upload .exe file and run it in Azure Function app. I create a TimerTrigger Function app, and run a .exe that insert record into database in this Function app, which works fine on my side.

function.json

{
  "bindings": [
    {
      "name": "myTimer",
      "type": "timerTrigger",
      "direction": "in",
      "schedule": "0 */1 * * * *"
    }
  ],
  "disabled": false
}

run.csx

using System;

public static void Run(TimerInfo myTimer, TraceWriter log)
{
    System.Diagnostics.Process process = new System.Diagnostics.Process();
    process.StartInfo.FileName = @"D:\home\site\wwwroot\TimerTriggerCSharp1\testfunc.exe";
    process.StartInfo.Arguments = "";
    process.StartInfo.UseShellExecute = false;
    process.StartInfo.RedirectStandardOutput = true;
    process.StartInfo.RedirectStandardError = true;
    process.Start();
    string output = process.StandardOutput.ReadToEnd();
    string err = process.StandardError.ReadToEnd();
    process.WaitForExit();

    log.Info($"C# Timer trigger function executed at: {DateTime.Now}");
}

Upload .exe file to Function app folder

enter image description here

Main code in my .exe program

SqlConnection cn = new SqlConnection("Server=tcp:{dbserver}.database.windows.net,1433;Initial Catalog={dbname};Persist Security Info=False;User ID={user_id};Password={pwd};MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;");
cn.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = cn;

cmd.CommandText = "insert into [dbo].[debug]([Name]) values('test')";

cmd.ExecuteNonQuery();
cn.Close();

Query the database, I can find the test record is inserted from my .exe file.
enter image description here

More Related Contents:

  1. How can I use NuGet packages in my Azure Functions?
  2. Missing ProviderName when debugging AzureFunction as well as deploying azure function
  3. Azure Function with AD auth results in 401 Unauthorized when using Bearer tokens
  4. Azure Blob Storage | AcquireLeaseAsync, synchronously wait until lock is released
  5. What is the simplest way to run a timer-triggered Azure Function locally once?
  6. Azure Functions – using appsettings.json
  7. Error while executing test, if using CreateResponse extention method to return Azure Function HttpResonseMessage
  8. Azure Functions Database Connection String
  9. Azure Bot C# : Webchat Open url in same Tab of Browser, Its opening in new tab
  10. Authorize By Group in Azure Active Directory B2C
  11. How to validate Azure AD security token?
  12. Microsoft Azure: How to create sub directory in a blob container
  13. Dependency injection using Azure WebJobs SDK?
  14. Error making Azure Management Library API call when authenticating with azure active directory
  15. Get Powershell command’s output when invoked through code
  16. Recommend a C# Task Scheduling Library [closed]
  17. Set Content-type of media files stored on Blob
  18. Copying one Azure blob to another blob in Azure Storage Client 2.0
  19. The lock supplied is invalid. Either the lock expired, or the message has already been removed from the queue
  20. Azure Function, EF Core, Can’t load ComponentModel.Annotations 4.2.0.0
  21. Azure Functions binding redirect
  22. How to serialize and deserialize a PFX certificate in Azure Key Vault?
  23. ASP.NET Core 1.1 runs fine locally but when publishing to Azure says “An error occurred while starting the application.”
  24. How to inject or use IConfiguration in Azure Function V3 with Dependency Injection when configuring a service
  25. No job functions found. Try making your job classes and methods public
  26. Accessing uploaded certificates in azure web sites
  27. Single or Multiple Entities Per Collection in DocumentDB
  28. Is it possible to scale Azure app services programmatically
  29. generate a Zip file from azure blob storage files
  30. Publish error: Found multiple publish output files with the same relative path

Leave a Comment