Dynamic Select

[Frank Schürer]

Hi,

i am currently trying to implement a dynamic select through linq by passing a specific setting name.
My intention is to get a value of a dynamic specified column name.

A first try is this here...

sSettingname = "XMLLayout"

Dim objScope As IObjectScope = ObjectScopeProviderMC.GetNewObjectScope()

Dim sUsername As String = System.Environment.UserName

 

Dim Settings = (From Sets In objScope.Extent(Of EnvSettings)() _

           Where Sets.User = sUsername.ToLower _

           Select ("new(" & sSettingname & " AS MyValue)"))

But my question is how can i access MyValue?

[Damyan Bogoev]

Hello Frank Schürer,

You could use reflection to access the property’s value:

For Each item As var In Settings
    Dim t As Type = item.GetType()
    Dim name As Object = t.GetProperty("MyValue").GetValue(item, Nothing)

    Console.WriteLine(name)
Next

Hope that helps.

All the best,
Damyan Bogoev
the Telerik team