Having problems with Entity Framework

Rushino · November 24th, 2010, 07:49 PM

Hello,

I refactored the name of my Entity Framework model and im getting this error.

Server Error in '/' Application.

Schema specified is not valid. Errors:
App_Code.EFLINQ.ssdl(3,4) : error 0019: The EntityContainer name must be unique. An EntityContainer with the name 'EFLINQModelStoreContainer' is already defined.
App_Code.EFLINQ.ssdl(11,4) : error 0019: Each type name in a schema must be unique. Type name 'EFLINQModel.Store.Personnes' was already defined.
App_Code.EFLINQ.ssdl(21,4) : error 0019: Each type name in a schema must be unique. Type name 'EFLINQModel.Store.Roles' was already defined.
App_Code.EFLINQ.ssdl(29,4) : error 0019: Each type name in a schema must be unique. Type name 'EFLINQModel.Store.FK_Personnes_Roles' was already defined.

Any ideas ?

Thanks.

Rushino · November 24th, 2010, 08:02 PM

Seem i fixed the problem it was due to the connection string.

"metadata=res://EFLINQ_wASPxGridView/App_Code.EFLINQ.cs

after the res:// you should specify the project assembly name.

Now i have another problem.. i can't seem to include the Entity Model in my default.aspx file.

Imar · November 25th, 2010, 03:52 AM

Hi Rushino,

What do you mean with "i can't seem to include the Entity Model in my default.aspx file."?

Imar

Rushino · November 25th, 2010, 07:31 AM

Hi Imar,

Well that not what i meant. Actually i had lots of problem with Entity Framwork 4 with a Web Application Project. I am correct to think that they are not at all the same ? (vs website projects)

I was adding the entity model in the App_Code folder but wasnt unable to make it being seen by others classes even if i imported the namespace. (i figured out App_Code wasnt supported to a web application project)

I also had to add 2 assembly entry in the web.config to make it work :

<add assembly="System.Data.Entity, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />
<add assembly="System.Data.Entity.Design, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />

If you ever refactoring the entity model.. you now get errors such :

Schema specified is not valid. Errors:
App_Code.EFLINQ.ssdl(3,4) : error 0019: The EntityContainer name must be unique. An EntityContainer with the name 'EFLINQModelStoreContainer' is already defined.
App_Code.EFLINQ.ssdl(11,4) : error 0019: Each type name in a schema must be unique. Type name 'EFLINQModel.Store.Personnes' was already defined.
App_Code.EFLINQ.ssdl(21,4) : error 0019: Each type name in a schema must be unique. Type name 'EFLINQModel.Store.Roles' was already defined.
App_Code.EFLINQ.ssdl(29,4) : error 0019: Each type name in a schema must be unique. Type name 'EFLINQModel.Store.FK_Personnes_Roles' was already defined.

The Entity Contexte must be unique... ?? ok but i had only one ?? lol dunno what happened. So the best bet is to create a Classe Folder and then put our classes in it.. and i have to add an import to the [AssemblyProjectName].Classes to access thoses classes.. since adding the model to the directory.. it consider to be added to the namespace .Classes.. so.

I couldn't use the Import EntityModel; import as mentionned in your book is there any reasons ? i suppose its because its a web application ?

I can't use a web site project because i need dll deployment support.

Thanks.

Imar · November 25th, 2010, 07:58 AM

Hi Rushino,

When you use a Web Application Project, you can't use App_Code. Simply create another folder, such as Code or Classes and add your EF model to that folder.

Cheers,

Imar

Rushino · November 25th, 2010, 08:48 AM

Alright thanks! That probably the root of the problem.

Imar · November 25th, 2010, 11:58 AM

Yes, I guess so. When used in an Web App, App_Code is compiled twice: once at development time into your assembly, and once at run-time, causing all kinds of conflicts such as duplicate types.

Cheers,

Imar

Hank_Marietta · June 12th, 2013, 05:17 PM

I know this is an old answer, but it helped me after a day of fruitless trials. Imar is the best and has helped me for years!