Table name as a parameter

[bin]

Hi sir,

i am using the ObjectScope of  telerik open access.

How can i select data by sending the table name as parameter using linq query ?

thanks

[Serge]

Hi bin,

 Unfortunately at the moment it is impossible to retrieve information based on the table name. However it should be possible to retrieve the persistent type name based on the table name using the metadata model that is available trough the scope. 

You can do so using code like: 

var model = scope.Database.MetaData;
string tableName = "table-name";

var persistentType = model.PersistentTypes
    .FirstOrDefault(x => x.Table != null && string.Equals(x.Table.Name, tableName));
string typeName = persistentType.FullName;

However this might only help you if you are using OQL to retrieve data. 

I hope this is helpful. 

All the best,
Serge
the Telerik team

[XXXX]

This is of interest to me as I want to query a table that is not part of the DomainModel.

Using IObjectScope.GetSqlQuery will be database depentant and I would like to solve this without having diffrent queries depending what the backend type is.

Has anyone a workaround ?

[Alexander]

Hello Bjössi,

I am afraid that the only way to retrieve information from a table which is not part of the model is to create a stored procedure in the database which returns the needed data. Then you can add this stored procedure to your model and execute it as a method of the OpenAccessContext instance. This method would return an object array which you can easily traverse to get the data.

Regards,
Alexander
the Telerik team