Devart Forums

Hi everybody.

I developed an ASP.NET MVC2 application using Entity Framework (DotConnect 6.0.70).

In my developer machine everything works good.

In my deploy machine the application can't find the tables. It gives me this error:
With SqlDeveloper I can see every table I need in both machines.

The problem I think is the tablespace.

In my developer machine I use the user "test" with "test" as default tablespaces.

In my deploy machine the user is different, like the tablespaces.

In both cases the tablespace is the "default" for the user.

How can I set Entity Framework for let it work with the default tablespace?

Or, better, could be this the problem?

Thank you in advance

As far as I can understand, the problem you are encountering is caused by the schema name being referenced in the .edml file. This is done to handle the case of working with several schemas in a single model. To force ObjectContext to use the default schema, you can remove the 'Schema' parameter from the 'EntitySet' nodes of the .edml file.

Please tell us if this helps.

Thank you a lot! It seams to work.

Is there a way to do not have the Schema defined in the EntitySet in the SSDL content ?

If I remove it manually, then I have problem to "Update my model from database" later because entity fw doesn't match the already mapped tables with tables in the database.

Thanks a lot.
Sylvain

Try adding Devart Entity model instead of the Microsoft one.
They have almost identical functionality, but we have full control over metadata, so there should be no such problem on model updating.