Edit Question - KnowledgeHub

Title Body

I have a custom entity in a relational database that I have mapped to the CLR via a domain model. So by using the following statement, I can pull in an entity from my database into memory via a LINQ query on the domain model, like so; var inspection = (from i in dbContext.New_testinspectionExtensionBases where i.New_testinspectionId == currentInspection select i).First(); There are properties/fields on this entity that I need access to, I need to be able to determine the property/field name as well as it's value. I want to loop through these items in memory, and write out their names and values to the console. I tried using this approach, but couldn't figure out how to correct the syntax (Nor am I sure that GetProperties is the correct method to use, GetFields wasn't returning anything for some reason so I assumed this was the way to go) but it doesn't really matter since all i need is read access to the value; var inspectionReportFields = inspection.GetType().GetProperties(); // I called this inspectionReportfields because the entity properties correspond to // form/report fields I'm generating from this data. foreach (var reportField in inspectionReportFields) { var value = reportField.GetValue(); Console.WriteLine(reportField.Name); Console.WriteLine(value); } Is there an easier way to get the property/field value when utilizing a domain model like EF or openaccess? If not, am I going about it the right way? And lastly, if so, how do I fix the syntax in the value variable declaration? Here are some sample fields/properties from the code generated by the domain model, for reference; private int? _new_systemGauges; public virtual int? New_systemGauges { get { return this._new_systemGauges; } set { this._new_systemGaug

Tags (comma-separated) Cancel