Wednesday, March 11, 2009

Difficulties

I've been having problems completing this next step. I think I've been trying to solve two difficult problems at once. The Dynamic loading of the property, and the joining of the two tables.

So I'm taking a step back. Let's solve the join first. How can I solve this problem with the code I already have?
Well I could just manually make the call to Tag in the User property. I would need to use the .Where() method to get what I want.
But, the .Where() method only looks at the objects table. I need to reference a joining table (tag_user to be exact.)

So, I need to be able to specify a joining table in the .Where() method, and then pull normally. I need to identify the table name, the matching columns, and then do the .Where() method normally.

Sounds good, I'll get on this in the morning.

No comments: