Solved

reflection of database data to an object

Posted on 2003-11-20
5
256 Views
Last Modified: 2010-04-16
I was wondering if anyone knew if there was a way to instantiate an object and then that object use reflection on itself. i.e.

I instantiate an object by calling it like this.

Employee e = new Employee("someID");

then in the process of creating itself employee calls some reflection method to instantiate it's own properties.

Anyone seen this happen?  I've got an idea of how it should be done but just having a hard time figuring it all out.

I am using this article as a basis:

http://www.c-sharpcorner.com/Code/2002/April/ReflectingDataXMLTL004.asp
0
Comment
Question by:jayrod
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 6

Accepted Solution

by:
purpleblob earned 500 total points
ID: 9788900
Yes this is be possible below is an example (if this is indeed what you want to do) obviously it seems a little odd using reflection in this manner as when you write the object you'll obviously know the properties etc. , so I assume you've got some clever reason for using reflection for such a process :-)

Anyway, this will work

public class Employee
{
   private int m_Value = 0;

   public int Val
   {
      get { return m_Value; }
      set { m_Value = value; }
   }
   public MyObject(string something)
   {
      Type t = this.GetType();
      PropertyInfo[] pinfo = t.GetProperties();
      t.InvokeMember(pinfo[0].Name, BindingFlags.SetProperty, null, this, new object[]{123});
   }
}

Now if you call this from somewhere else, i.e.

Exmployee obj = new Employee("someID");
int i = obj.Val;

This will assign i the value 123 which was set via reflection within the constructor.

Hope this helps
0
 
LVL 6

Expert Comment

by:purpleblob
ID: 9788922
Whoops, sorry as I was changing the code to reflect your Employee object I forgot to alter the constructor from MyObject to Employee.
0
 
LVL 3

Author Comment

by:jayrod
ID: 9789215
The clever reason is that the properties represent field names in a database. It seems that in order to do this before I would tell the object to get the row corresponding to the object from the database and then manually set each property.  Now this works fine.. but if I changed the database table at all I had to change the code.

I was hoping to find a way to do this dynamically. I asked about this topic a few months back(before I knew anything about reflection) and I eneded up using Hashtables and ArrayLists to represent my data. But this has become way too obscure.

thank you for this code. I'm going to test it out right now :)
0
 
LVL 3

Author Comment

by:jayrod
ID: 9789582
Outstanding!!!!!

Here is the final code. This is a method that will instantiate it's own properties (mind you the properties need to have a Set parameter) with a row from the database.

string sqlString = "select * from nrlfcuDepartments where departmentID = @departmentID";
r1 = SqlHelper.ExecuteReader(connection, CommandType.Text, sqlString, new SqlParameter("@departmentID", this._departmentID));

r1.Read();
if(r1.HasRows)
{

      Type t = this.GetType();
      PropertyInfo[] pinfo = t.GetProperties();

      for(int i=0;i<r1.FieldCount;i++)
      {
            try
            {
                  string name = r1.GetName(i);
                  t.InvokeMember(
                        r1.GetName(i),
                        BindingFlags.Default | BindingFlags.SetProperty,
                        null,
                        this,
                        new object [] { r1.GetValue(i) }
                        );
            }
            catch
            {//Means that a value was null or a fieldName has been changed                                    
            }
      }
}
0
 
LVL 6

Expert Comment

by:purpleblob
ID: 9789721
Ah, I suspected it might have something to do with initiating your object from a database record :-)

I did see something rather cool on codeproject which used Attributes to say which properties should be set from the database, I think it was this on http://www.codeproject.com/cs/database/dal1.asp I only had a glancing look but you might find it useful/interesting
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction Hi all and welcome to my first article on Experts Exchange. A while ago, someone asked me if i could do some tutorials on object oriented programming. I decided to do them on C#. Now you may ask me, why's that? Well, one of the re…
Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…

738 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question