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

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!)

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.

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

   

__________________
Rod

Rod Stephens, Microsoft MVP

Essential Algorithms: A Practical Approach to Computer Algorithms

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