Access an object's property using a string. VB.NET

Question

I am used to JavaScript where you can access an object's property using a string like so:

myObject[propertyNameString]

How can I do this for my query of an entity database doing something similar to this:

Dim query = From q In db[tableName]
            Where q[columnName] = myValue
            Select z

This is not supported in c# and vb.net. What is the use case here? — Chetan
– Chetan, Commented Jun 15, 2017 at 15:11
If you know the name of the property, why not just myObject.propertyName ? — Ňɏssa Pøngjǣrdenlarp
– Ňɏssa Pøngjǣrdenlarp, Commented Jun 15, 2017 at 15:15
@ChetanRanpariya is right. You can kinda sorta do this, but the code will not look similar and be difficult to manage. check this out — Jimmy Smith
– Jimmy Smith, Commented Jun 15, 2017 at 15:16
@Plutonix Because I am using this query inside a for each loop that uses a list of table names with an inner for each loop with a list of column names. I was hoping that I could write these queries dynamically this way. — h01001000
– h01001000, Commented Jun 15, 2017 at 15:16
Here's another example where they do this but again, not really similar syntactically — Jimmy Smith
– Jimmy Smith, Commented Jun 15, 2017 at 15:20

h01001000 · Accepted Answer · 2017-06-15 18:47:24Z

1

Here is how I actually went about solving this:

Dim tableName As String = "myTable" 'Set "myTable" dynamically in for loop
Dim tableObjectType As Type = Type.GetType(tableName)
Dim result = dbContext.Set(tableObjectType).Find("myPrimaryKey") 'Also set dynamically

answered Jun 15, 2017 at 18:47

h01001000

2818 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Access an object's property using a string. VB.NET

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related