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 Settings\All Users\Application Data\Sage\Platform\Configuration\Global\codesnippets.xml and add the location of the system.data.dll to the defaultreferences section: C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\System.Data.dll