This is a migrated thread and some comments may be shown as answers.

[Solved] Can't update database from model

9 Answers 274 Views

General Discussions

This is a migrated thread and some comments may be shown as answers.

This question is locked. New answers and comments are not allowed.

Gordon Buxton asked on 03 Aug 2010, 11:13 AM

Hi,

I have set up a brand new project using the 2010.2.714 ORM release, and I'm having trouble producing an update script from my model.

My steps were:

1. Set up a new project (Namespace: Oxinet.PEMS.DataModel)
2. Create a new data model called PEMSData
3. Import from existing database, which is still being designed, so most of the tables are there, but not all the mapping tables
(what I was hoping that we could use ORM to create "glue" mapping tables for us).
4. Make a few changes to property names, and make a couple of associations which involve the creation of new mapping tables.
5. This seems to work ok and creates some nice partial classes from my original database tables, one of which is called "Person"
6. Try to do "update database from model", where I go through the wizard and it just pops up with "Could not load type Oxinet.PEMS.DataModel.Person. Please rebuild the project and run the wizard again."
so (duh!) I rebuilt the project and ran the wizard again and I get the same result. I have no build errors or even any warnings.

What am I doing wrong?

9 Answers, 1 is accepted

answered on 05 Aug 2010, 05:41 PM

Hi Gordon Buxton,

This error message is most probably shown due to the fact that Telerik OpenAccess is unable to load a specific type. In this case there is a cached Database instance which metadata is not refreshed with the latest changes made from the designer.

There are two methods you could try to avoid this issue:

1. Change the connection string in order to obtain a new Database instance which OpenAccess will work internally with;

2. Restart Visual Studio;

At last you should rebuild your project before running the Update Schema from Model wizard.

Hope that helps.

Kind regards,
Damyan Bogoev
the Telerik team

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items

answered on 30 Aug 2010, 09:07 AM

Hello Brent,

When you close your visual studio instance can you please open the solution folder and delete all compiled assemblies manually before opening the visual studio again. This should fix your problem. Please note that you will have to rebuild your project once you open your solution again. We have eliminated the need of a compiled assembly from the forward mapping wizard and you should not encounter such problems in our next versions.
We are sorry for any inconvenience caused.

Greetings,
Petar
the Telerik team

answered on 02 Sep 2010, 03:34 PM

Hello Greg and Brent,

We are still working on the improved version of the forward mapping wizard. What we are targeting is to completely remove the need of a compiled assembly for the wizard to run. This will greatly ease the work with the wizard and dramatically reduce the problems that are present now. I will post here once we have an internal build containing the new version.
Once again sorry for the inconvenience caused.

All the best,
Petar
the Telerik team