Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
BOOK: Stephens' Visual Basic Programming 24-Hour Trainer
This is the forum to discuss the Wrox book Stephens' Visual Basic Programming 24-Hour Trainer by Rod Stephens; ISBN: 978-0-470-94335-9
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Stephens' Visual Basic Programming 24-Hour Trainer section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old May 12th, 2014, 01:45 PM
Authorized User
Points: 82, Level: 1
Points: 82, Level: 1 Points: 82, Level: 1 Points: 82, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Apr 2014
Posts: 19
Thanks: 4
Thanked 0 Times in 0 Posts
Default Data model not having all the tables

Hi, what could be the reason behind the data model not showing some of the tables. I add three tables and it is not showing one of them. If I add only that table, it shows it!!

Thanks
 
Old May 12th, 2014, 03:06 PM
Rod Stephens's Avatar
Wrox Author
Points: 3,166, Level: 23
Points: 3,166, Level: 23 Points: 3,166, Level: 23 Points: 3,166, Level: 23
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jan 2006
Location: , , .
Posts: 647
Thanks: 2
Thanked 96 Times in 95 Posts
Default

I don't think I've seen that happen before.

How are you building the model? For example, did you make a database connection and then double-click the .xsd file to open the designer for it?

What are the tables' names? (I'm wondering if a table has a name that the designer doesn't like for some reason. Maybe a keyword?)

I think you should be able to drag the missing table from the Database Explorer into the designer. Then you can add relationships to it.

Sorry I don't have a better answer. I don't know what's going wrong here.
__________________
Rod

Rod Stephens, Microsoft MVP

Essential Algorithms: A Practical Approach to Computer Algorithms

(Please post reviews at Amazon or wherever you shop!)
 
Old May 12th, 2014, 06:36 PM
Authorized User
Points: 82, Level: 1
Points: 82, Level: 1 Points: 82, Level: 1 Points: 82, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Apr 2014
Posts: 19
Thanks: 4
Thanked 0 Times in 0 Posts
Default

It is weird because I don't get any error messages. I use the ADO.net Entity Data Model to add my tables. I emailed you the snapshots of how the tables look in both sql sever and vb.

Thanks in advance.
 
Old May 12th, 2014, 06:56 PM
Rod Stephens's Avatar
Wrox Author
Points: 3,166, Level: 23
Points: 3,166, Level: 23 Points: 3,166, Level: 23 Points: 3,166, Level: 23
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jan 2006
Location: , , .
Posts: 647
Thanks: 2
Thanked 96 Times in 95 Posts
Default

Yes, that's weird. I don't know why it is doing that. (I'm attaching your images so others who read this thread can see them.)

It looks like VB is "clever" enough to represent Milestones --> MilestoneUpdateRelationships --> MilestoneStatusUpdateHistory as a single many-to-many relationship. It's hard to imagine how (or why).

You might try right-clicking on that relationship and selecting Edit Relation just to see what it thinks it's doing. And you can try dragging the missing table into the model to see what happens.

Otherwise I'm at a loss.
Attached Thumbnails
Click image for larger version

Name:	dataModelSnapshot.png
Views:	11
Size:	14.6 KB
ID:	109   Click image for larger version

Name:	sqlServerSnapshot.png
Views:	8
Size:	13.5 KB
ID:	110  
__________________
Rod

Rod Stephens, Microsoft MVP

Essential Algorithms: A Practical Approach to Computer Algorithms

(Please post reviews at Amazon or wherever you shop!)




Similar Threads
Thread Thread Starter Forum Replies Last Post
problem creating entity data model Kourosh94 ASP.NET 4.5 General Discussion 0 December 7th, 2013 03:56 PM
Chapter 14 : Mapping data model to an object model robochrish BOOK: Beginning ASP.NET 4 : in C# and VB 8 March 5th, 2013 09:52 AM
entity data model problem and maximum exceeded errors Caden11998 ASP.NET 4 General Discussion 0 August 29th, 2012 11:55 AM
security (xss_clean) the data in controller or model? blackhorse66 BOOK: Professional CodeIgniter ISBN: 978-0-470-28245-8 0 January 27th, 2010 05:30 PM
Migrate user data to new membership model relaytest49 ASP.NET 2.0 Professional 2 May 24th, 2006 09:44 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.