Entity Framework - Medium Trust

Question

I'm trying to get the entity framework working in medium trust. I've tried splitting the files and using a separate assembly but I seem to have one problem after another.

I moved the EDMX to a separate assembly, which causes a single .dll to be outpit to the sites /Bin directory. I'm referencing this as below from web.config.

<add name="ApplicationDB" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Application.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient" />
<add name="ShopEntities" connectionString="metadata=res://*/;provider=System.Data.SqlClient;provider connection string=&quot;Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Application.mdf;Integrated Security=True;User Instance=True;MultipleActiveResultSets=True&quot;" providerName="System.Data.EntityClient" />

Whenever I try to access one of the entity classes, I get an ArgumentException: 'An item with the same key has already been added.' It's critical this works with medium trust, but I seem to be running out of options. Any advice greatly appreciated.

Answer 1

You. Are. Done.

Does not work. Point.

Dont. use. That. Crap. Comes to my mind. EF 2 (.NET 4.0) is "BAD", but EF 1 (.NET 3.5) is total utter crap.

Medium trust - not supported scenario. Someone should have thought about that before starting programming. Checking requirements phase. No way to get it working (unless you "open up" medium trust, but then it is not medium trust anymore anyway).

Answer 2

You can use Entity Framework 3.5 in medium trust. However, there is a problem with running this on Windows 7 and Windows Server 2008. Microsoft released a patch for this. Read here for more info.

Answer 3

Moving the EDMX and all partial classes to a separate assembly was the eventual solution.