Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Visual Basic > VB 2010 > BOOK: Stephens' Visual Basic Programming 24-Hour Trainer
Password Reminder
Register
Register | FAQ | Members List | Calendar | 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 tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developersí questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Display Modes
  #1 (permalink)  
Old May 12th, 2014, 02: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
Reply With Quote
  #2 (permalink)  
Old May 12th, 2014, 04:06 PM
Rod Stephens's Avatar
Wrox Author
Points: 3,145, Level: 23
Points: 3,145, Level: 23 Points: 3,145, Level: 23 Points: 3,145, Level: 23
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jan 2006
Location: , , .
Posts: 641
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!)
Reply With Quote
  #3 (permalink)  
Old May 12th, 2014, 07: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.
Reply With Quote
  #4 (permalink)  
Old May 12th, 2014, 07:56 PM
Rod Stephens's Avatar
Wrox Author
Points: 3,145, Level: 23
Points: 3,145, Level: 23 Points: 3,145, Level: 23 Points: 3,145, Level: 23
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jan 2006
Location: , , .
Posts: 641
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 Images
File Type: png dataModelSnapshot.png (14.6 KB, 2 views)
File Type: png sqlServerSnapshot.png (13.5 KB, 1 views)
__________________
Rod

Rod Stephens, Microsoft MVP

Essential Algorithms: A Practical Approach to Computer Algorithms

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


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
problem creating entity data model Kourosh94 ASP.NET 4.5 General Discussion 1 December 9th, 2013 02:38 AM
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 12:55 PM
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 10:44 AM



All times are GMT -4. The time now is 10:34 PM.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.