If you ever need to retrieve data from EF using the name of a column, rather than the built in Intellisense, then the following vb.net code snippet may help.
GetType(TypeOfEntity).GetProperty(NameOfColumn).GetValue(ActualEntity, Nothing)
- TypeOfEntity is the name of the Entity from which you wish to retrieve data.
- NameOfColumn is obviously the Name of the Column from which you wish to retrieve data.
- ActualEntity is a reference to the Entity itself, from which the data is to be retrieved.
The above can help if you need to retrieve data based on a column name which is defined by another function. Such as in the following example;
You have a table called Users with columns called Screen1Edit and Screen2Edit.
You can then retrieve the values in Screen1Edit or Screen2Edit depending upon which you require, supplied in a variable called strScreenName;
GetType(Users).GetProperty(strScreenName).GetValue(Users, Nothing)
Obviously you must be careful to supply the exact name of the column into the Column Name!
Note: For c# replace GetType with TypeOf.
Leave A Comment
You must be logged in to post a comment.