Skip to main content
Answer

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.

  • May 17, 2024
  • 3 replies
  • 98 views

Forum|alt.badge.img

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.

Best answer by hyadav08

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

3 replies

Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • May 17, 2024

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


Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • May 17, 2024

@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


Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • Answer
  • May 24, 2024

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