{Quick Tip} Azure Function deployment error “ERROR_CERTIFICATE_VALIDATION_FAILED”

Today while deploying Azure Function into a new environment I got this error:

Web deployment task failed. (Connected to the remote computer (“https://mytestfunapp.azurewebsites.net/ “) using the specified process (“Web Management Service”), but could not verify the server’s certificate. If you trust the server, connect again and allow untrusted certificates.  Learn more at: http://go.microsoft.com/fwlink/?LinkId=221672#ERROR_CERTIFICATE_VALIDATION_FAILED.) [C:\Users\3176\source\repos\Solution\Integration_Functions.csproj]


This error is not limited to Azure or Azure Functions. It occurs if SSL certificate is invalid or not configured correctly. To allow untrusted certificates we will need to set <AllowUntrustedCertificate>True</AllowUntrustedCertificate> in *.pubxml

Datatable.Select Method with multiple conditions

Select method of DataTable is used to select rows from datatable (see this post). We can have multiple Boolean conditions in select method just like we do in SQL. It some situations it can save many round trips to database.

DataRow[] SelectedRow= MyDataTable.Select("Id = 5 Or RegistrationNo=72);