StrataFrame Forum » StrataFrame Application Framework - V1 » Business Objects and Data Access (How do I?) » Exception with Extended Properties

Exception with Extended Properties

Ertan Deniz — Sat, 24 May 2008 03:18:47 GMT

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.

RE: Exception with Extended Properties

Ertan Deniz — Sat, 24 May 2008 03:18:47 GMT

I had thought that I had to write for every property of a class to ensure specified column exist in CurrentDataTable.

But It was only for extended properties. So, It is not hard to write.

RE: Exception with Extended Properties

Trent L. Taylor — Fri, 23 May 2008 09:34:12 GMT

No, not really. What do you mean? I already gave you my comment on the previous post. :)

RE: Exception with Extended Properties

Ertan Deniz — Fri, 23 May 2008 07:26:36 GMT

Any comment ?

RE: Exception with Extended Properties

Trent L. Taylor — Wed, 21 May 2008 09:16:56 GMT

[quote]Any comment ? I 'm trying to find easy way ? (Shared) Central point to write the code. (EnsureColumnsExist) [/quote]

I generally do this immediately after calling a Fill ... or even in some cases an Add since those columns would not exist on the Add. This really is up to you and depends on if this is an isolated element of a single maintenance form or will happen for the entire BO no matter where it is used.

If it is the latter, then you may want to override the FillDataTable method on your BO. Then call this method after you call the MyBase.FillDataTable(...) method.

RE: Exception with Extended Properties

Ertan Deniz — Wed, 21 May 2008 09:02:56 GMT

Any comment ? I 'm trying to find easy way ? (Shared) Central point to write the code. (EnsureColumnsExist)

RE: Exception with Extended Properties

Ertan Deniz — Tue, 20 May 2008 00:59:09 GMT

Where is the place of this method called in the code ? You said when referencing a column.

Should you give me an explanation ?

RE: Exception with Extended Properties

Ertan Deniz — Mon, 19 May 2008 09:00:12 GMT

Thanks.

RE: Exception with Extended Properties

Trent L. Taylor — Mon, 19 May 2008 08:36:00 GMT

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:

[codesnippet]    ''' <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[/codesnippet]

RE: Exception with Extended Properties

Ertan Deniz — Sat, 17 May 2008 01:14:14 GMT

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.

RE: Exception with Extended Properties

Trent L. Taylor — Fri, 16 May 2008 10:41:16 GMT

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.

RE: Exception with Extended Properties

Ertan Deniz — Fri, 16 May 2008 08:16:05 GMT

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.

RE: Exception with Extended Properties

Trent L. Taylor — Sat, 29 Mar 2008 08:20:37 GMT

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")

RE: Exception with Extended Properties

Ertan Deniz — Sat, 29 Mar 2008 00:52:55 GMT

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 ?