Multiple Tables in an object


Author
Message
Robert Harvey
Robert Harvey
StrataFrame Beginner (19 reputation)StrataFrame Beginner (19 reputation)StrataFrame Beginner (19 reputation)StrataFrame Beginner (19 reputation)StrataFrame Beginner (19 reputation)StrataFrame Beginner (19 reputation)StrataFrame Beginner (19 reputation)StrataFrame Beginner (19 reputation)StrataFrame Beginner (19 reputation)
Group: Forum Members
Posts: 9, Visits: 28
Let's say I have a strongly-typed dataset that contains multiple tables.  And, let's call this dataset 'Orders'.  How can I create an object with Strata-frame?  All of the documentation points to one table per object.  Not that the attachment is a 'real-life' example.  But, I don't want to upload what I use at our company for public consumption.
Attachments
XSDSchema1.zip (190 views, 1,013 bytes)
Replies
Charles R Hankey
Charles R Hankey
StrataFrame VIP (1.3K reputation)StrataFrame VIP (1.3K reputation)StrataFrame VIP (1.3K reputation)StrataFrame VIP (1.3K reputation)StrataFrame VIP (1.3K reputation)StrataFrame VIP (1.3K reputation)StrataFrame VIP (1.3K reputation)StrataFrame VIP (1.3K reputation)StrataFrame VIP (1.3K reputation)
Group: Forum Members
Posts: 524, Visits: 30K
Smile uh, no I have the SF sample database installed.

My point was the data schema Robert send was for two tables that aren't part of the sample data

And I was wondering if before creating the sample you had somehow magically imported from the schema into a DB so you could map with the BO mapper.

I think I was having a bad expressing myself day BigGrin

( but it did get me Googling and it turns out there is indeed a way to create XSD Schemas from SQL 2005 with t_sql and then the there a way of creating data structures in SQL from schemas, but the format Robert used wasn't the one, so I guess that wasn't the intention )

Just trying to catch up on the huge gaps in my basic knowledge of VS/VB tricks w00t

StrataFrame Team
S
StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)
Group: StrataFrame Developers
Posts: 3K, Visits: 2.5K
Ah, I gotcha... the XSD that Robert posted is not part of the StrataFrameSample database... it was something else that he was working on (or maybe he modified his sample database, I dunno).  So, it's starting to make sense why you thought that the XSD he posted was part of the SF sample. 

I'm glad you found a few tools to convert the XSDs and so forth.  But just remember, the only 2 sources of structures for the BOMapper are the DDT and the database itself on the server.

Charles R Hankey
Charles R Hankey
StrataFrame VIP (1.3K reputation)StrataFrame VIP (1.3K reputation)StrataFrame VIP (1.3K reputation)StrataFrame VIP (1.3K reputation)StrataFrame VIP (1.3K reputation)StrataFrame VIP (1.3K reputation)StrataFrame VIP (1.3K reputation)StrataFrame VIP (1.3K reputation)StrataFrame VIP (1.3K reputation)
Group: Forum Members
Posts: 524, Visits: 30K
Thanks Ben - I knew it wasn't part of the Strataframe Sample Data but it was referenced in the zip you posted so I thought you might have used his XSD to add the tables to the sample data in some way everyone but me knew about "Smile
GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...




Threaded View
Threaded View
Robert Harvey - 20 Years Ago
StrataFrame Team - 20 Years Ago
Daniel Essin - 20 Years Ago
Robert Harvey - 20 Years Ago
                 But, you can post in C#. Either way works for me.
Robert Harvey - 20 Years Ago
StrataFrame Team - 20 Years Ago
StrataFrame Team - 20 Years Ago
Michael Cobb - 18 Years Ago
StrataFrame Team - 18 Years Ago
Charles R Hankey - 18 Years Ago
StrataFrame Team - 18 Years Ago
Charles R Hankey - 18 Years Ago
StrataFrame Team - 18 Years Ago
Charles R Hankey - 18 Years Ago
Michael Cobb - 18 Years Ago
Charles R Hankey - 18 Years Ago
StrataFrame Team - 18 Years Ago
Michael Cobb - 18 Years Ago
Michael Cobb - 18 Years Ago
choyt - 18 Years Ago
StrataFrame Team - 18 Years Ago
choyt - 18 Years Ago

Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search