Multiple Tables Revisited


Author
Message
Larry Caylor
Larry Caylor
StrataFrame VIP (1.8K reputation)StrataFrame VIP (1.8K reputation)StrataFrame VIP (1.8K reputation)StrataFrame VIP (1.8K reputation)StrataFrame VIP (1.8K reputation)StrataFrame VIP (1.8K reputation)StrataFrame VIP (1.8K reputation)StrataFrame VIP (1.8K reputation)StrataFrame VIP (1.8K reputation)
Group: Awaiting Activation
Posts: 592, Visits: 3.7K

While I really like what I’ve learned about the framework to date I’m still having some problems understanding the best way to apply it. I think most of my issues surround object mapper and its one object to one table relationship.   For example I’m wondering what is the best way to address the following situation using StrataFrame. I have three tables, User, Role, and Role Assignment. RoleAssignment maintains a many to many relationship between User and Role and in addition to it’s primary key only contains the foreign keys to the other tables.

 

I want to display user and role assignments in a list view.  In another framework I would have created a read-only object that would contain user names, roles, along with the associated keys and any additional information I wished to get from the User and Role tables, and populated it using a stored procedure. However since object mapper only maps one object to one table this presents a problem. I suppose one solution would be to create a complex business object. I could also drop all the objects on the form and maintain the relationship between them on the form. My goal is to insulate the UI developer from the underlying data structure as much as possible. Any suggestions? While this example is for a read only object, I have the same questions when dealing with multiple editable objects on a form. 

 

Finally does MicroFour plan on offering any formal training classes or consulting services in the future?

 

-Larry

GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...




Threaded View

Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search