|
| | | StrataFrame User
 
Group: StrataFrame Users
Last Login: 11/12/2008 2:33:56 AM
Posts: 152, Visits: 460 |
| | I've an extended property called ClientAccountName. When I fill the Business Object which based on table mt_pch_companies, An exception was thrown. What should I do ? Exception : Column 'ClientAccountName' does not belong to table mt_pch_companies. |
| |
| | | StrataFrame User
Group: StrataFrame Users
Last Login: 11/12/2008 2:33:56 AM
Posts: 152, Visits: 460 |
| | What about the columns belong to the table, I 've written an sql to select some of the fields but I'm getting an argument exception : Column 'code' does not belong to table mt_pch_companies. Because I couldn't select this column. What is the way of managing column and object properties with these conditions ? |
| |
| | | 
StrataFrame Developer
Group: StrataFrame Developers
Last Login: Yesterday @ 3:20:54 PM
Posts: 4,769, Visits: 4,731 |
| The only way that you would get an error is if:- The custom property is an actual field in the table that is expected when updating in which case you would want to add the field to the ExcludeOnUpdates property.
- You are evaluating the field (referencing the field) when you have not pulled back the field that is used by the custom field
- Calling the MyBo.Item property to retrieve the vaue from within that item which would cause a recursive error in which case you should be using MyBo.CurrentRow.Item("MyField")
|
| |
| | | StrataFrame User
Group: StrataFrame Users
Last Login: 11/12/2008 2:33:56 AM
Posts: 152, Visits: 460 |
| | I had problems with extended columns. At this time, The exception that I have got was related to binding. I have not bound the extended column (A) to the grid. But When navigating in the grid, The exception "Column A does not belong to table X". There must be an easy way to control and manage the extended properties and properties that are not used with current state of the object. This was the reason why they were not selected. Otherwise, All the properties and extended properties have to be selected in each query. It is not optimal when we have many relations (extended properties from other objects.) to do so. Note : Extended properties are used to binding purposes. |
| |
| | |
StrataFrame Developer
Group: StrataFrame Developers
Last Login: Yesterday @ 3:20:54 PM
Posts: 4,769, Visits: 4,731 |
| | Binding requires that you provide a type descriptor...I recommend doing a search on GetCustomBindablePropertyDescriptors....there should be a ton of posts on this. Bottom line is that if you attempt to bind to a column that does not have a descriptor, you will get an error. |
| |
| | | StrataFrame User
Group: StrataFrame Users
Last Login: 11/12/2008 2:33:56 AM
Posts: 152, Visits: 460 |
| | protected override FieldPropertyDescriptor[] GetCustomBindablePropertyDescriptors() { return new FieldPropertyDescriptor[] { new ReflectionPropertyDescriptor("ClientAccountName", typeof(Companies)), new ReflectionPropertyDescriptor("GroupName", typeof(Companies)) }; } I 've written the code necessary for the extended properties. The problem is that When we does not select any property (predefined or exteneded) with our query. Business object's table contains only selected columns. Business object is bound to a grid through BBS. Business object contains all the property definitions but table contains only selected ones. This is the central of the problem. After selecting a record on the grid, When we press a button, an exception is thrown. This exception is catched by the InvalidRowException event of the Devexpress Grid. Internally, there is an access to the properties of the business object that is not selected to be shown on the grid. We don't select them because there is no need to show. This is the my case in detail. |
| |
| | |
StrataFrame Developer
Group: StrataFrame Developers
Last Login: Yesterday @ 3:20:54 PM
Posts: 4,769, Visits: 4,731 |
| Well, I see your point, and this is actually by design. You are wanting to perform a query, and then the internal ADO.NET table to automatically have all of the columns for the table. This is not how the logic of a BO works. It expects those columns to be included within the query or to be defined. In our medical software, we actually have a shared method that ensures that columns and their default values exist in the case that we attempt to reference it, etc. It looks something like this: ''' <summary> ''' Ensures that the column specified exists within the table. ''' </summary> ''' <param name="table"></param> ''' <param name="columnName"></param> ''' <param name="columnType"></param> ''' <param name="defaultValue"></param> ''' <remarks></remarks> Public Shared Sub EnsureColumnExists(ByVal table As DataTable, ByVal columnName As String, ByVal columnType As System.Type, ByVal defaultValue As Object) '-- Establish Locals Dim col As DataColumn Dim columnFound As Boolean = False '-- Cycle through all of the columns so we can test on a case-insensitive basis
For Each col In table.Columns
'-- Check to see if the column name matches
columnFound = col.ColumnName.Equals(columnName, StringComparison.OrdinalIgnoreCase) '-- If the column was found, exit
If columnFound Then Exit For
Next '-- See if there is any reason to continue
If columnFound Then Exit Sub '-- If we make it to this point, then we have a hit
col = New DataColumn(columnName, columnType)
col.DefaultValue = defaultValue '-- Add the column to the table
table.Columns.Add(col)
End Sub |
| |
| | | StrataFrame User
Group: StrataFrame Users
Last Login: 11/12/2008 2:33:56 AM
Posts: 152, Visits: 460 |
| | |
| | | StrataFrame User
Group: StrataFrame Users
Last Login: 11/12/2008 2:33:56 AM
Posts: 152, Visits: 460 |
| | Where is the place of this method called in the code ? You said when referencing a column. Should you give me an explanation ? |
| |
|
|
|