LINQ Query Result - dynamically get field value from a field name variable

Question

LINQ newbie here

I am trying to get a value of a field - using a fieldName variable. If I do a watch on row[FieldName] I do get a value - but when I do it on the actual code it will not compile.

string fieldName = "awx_name"

List<awx_property> propertyQry = 
            (
                from property in crm.awx_propertyawx_properties
                where property.awx_propertyid == new Guid(id)
                select property
            ).ToList();

            foreach (awx_property row in propertyQry)
            {
//THIS DOES NOT WORK
fieldValue = row[fieldName];   
}

Thanks in advance. Alternatives would be welcome as well

MNIK · Accepted Answer · 2011-06-17 17:13:37Z

1

You keep us guessing what you are trying to do here... You need to specify the types of the objects, so it's easy for us to understand and help. Anyway, I think you are trying to get an object based on the ID. Since you are getting by Id, my guess would be the return value is a single object.

var propertyObj =( from property in crm.awx_propertyawx_properties
                      where property.awx_propertyid == new Guid(id)
                      select property
                    ).SingleOrDefault();
   if(propertyObj != null) {
     fieldValue = propertyObj.GetType().GetProperty(fieldName).GetValue(propertyObj, null);
   }

Of course, you need to add validation to make sure you don't get null or any other error while accessing the property value.

Hope it helps.

answered Jun 17, 2011 at 17:13

MNIK

1,6293 gold badges17 silver badges22 bronze badges

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

Comments

Ryan Bennett · Accepted Answer · 2011-06-17 16:28:45Z

0

What type is fieldValue? What does awx_property look like? This will only work is awx_property is a key/value collection. It its not, you could use reflection instead.

If it is a key/value collection you are probably missing a cast. (row[FieldName].ToString() or something) Also you are missing a semi-colon in the foreach block.

answered Jun 17, 2011 at 16:28

Ryan Bennett

3,42222 silver badges33 bronze badges

2 Comments

DevilCode Over a year ago

If I do row.awx_name it works fine. Maybe I should check out that reflection deal...

DevilCode Over a year ago

Microsoft.Xrm.Client.CrmEntity.this[string]' is inaccessible due to its protection level ==> this is the compile error I get

Collectives™ on Stack Overflow

LINQ Query Result - dynamically get field value from a field name variable

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related