I'm using the VB.NET code:

Using myEntities As New PlanetWroxEntities()

Even after using Imports PlanetWroxModel it tells me that PlanetWroxEntities is not defined, the suggested fix is to use:

Using myEntities As New PlanetWroxEntities1()

- which seems to work fine. Is this correct because the book doesnt state the 1?

Hi Alex,

Looks like you tried to add the model multiple times before you got one that worked.

When you add a new model using the Wizard, VWD adds a connection string to web.config named after the model. E.g. you get something like PlanetWroxEntities as a connection string.

If you then follow the same steps again you get a new connection with a sequential number. This in turn causes the model name to change. A few ways to fix it, depending on how important you find this:

1. Leave everything as is and work with PlanetWroxEntities1. Works, but may not be as nice from an aesthetic perspective

2. Delete the model files and the connection strings from web.config and redo your steps

3. Rename the connection string in web.config by removing the 1. Then use Find and Replace in Files to update the name for the model as well. Make sure you also update the EDMX file and its code behind file which may mean manually editing the XML for the EDMX file.

Hope this helps,

Imar

__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!

Thanks Imar, I did try to insert it before but no table diagrams came up so I copied the DB over again and it worked. I think I'll leave it as it is as long as I now understand what happened.