Skip to main content
Solved

Acumatica is using mysql or sql how to identify in c# code. Or In Acumatica how to get the provider name in C# code to identify the SQL or MySql.

  • 17 May 2024
  • 3 replies
  • 55 views

Acumatica is using mysql or sql how to identify in c# code. Or In Acumatica how to get the provider name in C# code to identify the SQL or MySql.

3 replies

Userlevel 7
Badge +19

@hyadav08 You can check the Web.Config file Connection string.

@hyadav08 You can check the Web.Config file Connection string.

@Naveen Boga 
this is the way to find out
string ProviderName = ConfigurationManager.ConnectionStrings["ProjectX"].ProviderName;

But it can;t solve my purpose. to specific find out database is SQL or MySql

I have find solution and solution is -
PXDatabase.Provider this will give the information that database is used in SQL or MySQL

Reply