How to resolve "System.ArgumentNullException: Value cannot be null. Parameter Name: providerInvariantName" problem while using Database Activity
While executing workflow which is going to update some value into the database, it throws an warning Error: “System.ArgumentNullException: Value cannot be null. Parameter Name: providerInvariantName”.
- Database connect activity is getting the ProviderName property as null or empty. For resolving this, initialize ProviderName property as "System.Data.SqlClient" or mention it in connectionString
- If you are trying to insert or update a column value with a null value which is declared as NOT NULL in Database, either allow column to accept NULL or send a not null value (an empty string) to resolve it.
- Database connect" activity is getting the ProviderName property as null or empty
- the attempt to insert or update a column value with a null value which is declared as NOT NULL in Database