Question: I have a one row, standalone table that holds default values, and there is a custom entity that I would like to populate with these values when I click a button. My goal is to create a business rule that will return default values from a standalone table, and then will populate values at the entity level. I was thinking that to get the default values I should run SQL because I have used SQL in custom smartparts in the past. I used this code in the business rule:
System.Data.OleDb.OleDbConnection oConn = (System.Data.OleDb.OleDbConnection)data.GetConnection();
But I get the error: The type or namespace ‘Data’ does not exist in the namespace ‘System’
I added System.Data and get the same error. How can I run SQL in the business rule, and is there a better way to return the values from this standalone table to a business rule on my custom entity?
Answer: To correct your issue you may need to edit this file:
C:Documents and SettingsAll UsersApplication DataSagePlatformConfigurationGlobalcodesnippets.xml and add the location of the system.data.dll to the defaultreferences section: C:WINDOWSMicrosoft.NETFrameworkv2.0.50727System.Data.dll