This thread looks to be a little on the old side and therefore may no longer be relevant. Please see if there is a newer thread on the subject and ensure you're using the most recent build of any software if your question regards a particular product.
This thread has been locked and is no longer accepting new posts, if you have a question regarding this topic please email us at support@mindscape.co.nz
|
I created a model with 3 tables. the table is from lightspeed sample - sofiacarrental1 I added Cars, RentalOrders and a new table RentalReseve(I created this one) The are linked by CarID. This seemed to create a preReserve(This is my model name)Context. can I use this context to retrieve all of the records at once? (something similar to doing join for the three tables?) and use it as single source to bind to a single grid? Thank you very much, Jae |
|
|
|
|
Hi Jae, If your grid uses a master/detail type system that allows drilling in, then you could drill down through the relationships, yes. You may want to eager load the relationships if you're not working in a sophisticated ajax type environment where you could fetch when drilling in. We have a screencast about eager loading. I suspect this is what you're looking to achieve? If you mean more of a single big list that's editable, no, it won't automatically return one IList<object> type structure. You would need to query all three and just connect them in memory. Generally, LightSpeed will work with a given entity type in its returned results (note, that's just with the returned values - not querying. You can query through associated entities etc). If I've misunderstood you please let me know and if possible provide more details about what you are trying to achieve. Kind regards, John-Daniel Trask |
|
|
|
