Identify Computed Columns

[Garry]

I have a need to identify computed columns, but I haven't been able to figure out how. Below is what I have so far and I have set the Kind property on the column to Calculated, but I can't find that property anywhere on the column at runtime. It doesn't appear to even be in the MetaDataProperties collection. How can I find these columns?

Thanks!

//determine if this scope already exists on the server and if not go ahead and provision
                        foreach (MetaTable table in scope.OpenAccessMetaData.Tables)
                        {
                            Collection<string> syncColumns = new Collection<string>();
                            foreach (MetaColumn column in table.Columns)
                            {
                                if (column.Name != "DisguisedSSN")
                                {
                                    syncColumns.Add(column.Name);
                                }
                            }
                            //add the approrpiate tables to this scope
                            scope.ScopeDescription.Tables.Add(SqlSyncDescriptionBuilder.GetDescriptionForTable(table.Name, syncColumns, (System.Data.SqlClient.SqlConnection)remoteProvider.Connection));
                        }

[Damyan Bogoev]

Hi Garry Clark,

I suggest you to set the Kind property to "PersistentReadOnly" so that this column is being only read by the server which calculates it("Calculated" is bit different option where one should specify his own SQL for calculating the value but, that is not implemented yet). After you do that you should go for the MetaColumn.DataAccessKind property which returns a value from the DataAccessKind enumeration. 

foreach (MetaTable table in scope.OpenAccessMetaData.Tables)
{
    ...
    foreach (MetaColumn column in table.Columns)
    {
        ...
        if (column.DataAccessKind == DataAcccessKind.ReadOnly)
        {
            //do something
        }
        ...
    }
    ...
}

Hope that helps. If any other questions arise please contact us back.

Sincerely yours,
Damyan Bogoev
the Telerik team

[Erik]

Hi Damyan,

Do you mean that computed/calculated fields in the database are not automatically mapped as DataAcccessKind.ReadOnly
? So, every time I do an 'update from database' I have to set this parameters...?

Erik

[Damyan Bogoev]

Hello Erik,

Yes, the calculated columns are not mapped automatically to read only properties and you should do that explicitly.
I am sorry for the inconvenience caused.

Kind regards,
Damyan Bogoev
the Telerik team

[Ian]

Hi,
I'm just getting up to speed on the Telerik ORM.  Is the automatic flagging of database calculated columns (in my case I use SQL Server) going to be improved upon in future?  Just curious.
Thanks,
Ian

[Ady]

Hello Vernon,

Yes, this is very much on the list of features we would like to have and we would be implementing this. I cannot give you an exact timeframe at the moment , but it will definitely be done.

Kind regards,
Ady
the Telerik team