Databases
StackOverflow2013
Postsdbo
POCreating EF controls in MVC with enums as keys
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POCreating EF controls in MVC with enums as keys
    primarykey
    data
    text
    <p>Ok so here's some context: I'm using EF5, MVC4 and SQL CE4 to build up a web application. I've been loosely following this <a href="http://www.asp.net/mvc/tutorials/mvc-4/getting-started-with-aspnet-mvc4" rel="nofollow noreferrer">tutorial</a> with a few differences. </p> <ol> <li>My context class and POCO objects are in their own assembly.</li> <li>I'm using SQL CE4 instead of SQL Express Local DB</li> <li>My classes aren't as simple as the tutorial</li> </ol> <p>I've already used a <a href="https://stackoverflow.com/questions/12165185/mvc4-scaffolding-add-controller-gives-error-unable-to-retrieve-metadata/14576216#14576216">workaround</a> to get simple classes to work register.</p> <p>I had thought using enums in EF5 was <a href="http://msdn.microsoft.com/en-us/data/hh859576.aspx" rel="nofollow noreferrer">supported</a> in EF5, but can they be used in Keys?</p> <p>When I try to <strong>add a control</strong> (Add Controller, MVC controller with read/write actions and views, using Entity Framework) for a simple class (1 int key property, 1 string property), it works. I get varied errors when trying to add a class that has a property which is part of a key (primary or foreign)</p> <pre><code>Unable to retrieve metadata for 'blah'. Using the same DbCompiledModel to create contexts against different types of database servers is not supported. Instead, create a separate DbCompiledModel for each type of server being used. Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index C:\Program Files (x86)\Microsoft Visual Studio\11.0\Common7\IDE\ItemTemplates\CSharp\Web\MVC 4\ CodeTemplates\AddController\ControllerWithContext.tt(0,0) : error : Running transformation: System.IndexOutOfRangeException: Index was outside the bounds of the array. ---StackTrace--- </code></pre> <p>The only similarities I've found between these classes is that they have an emun that's tied to a key. Other classes with non-key enums generate correctly. Is this the issue or have I completely missed the mark?</p> <p>Edit: Example of a class which fails</p> <pre><code>public class A { public virtual AIdEnum Id { get; set; } public virtual string Name { get; set; } public virtual ICollection&lt;B&gt; Bs { get; set; } public virtual ICollection&lt;C&gt; Cs { get; set; } } </code></pre>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USCommunity
    1. USJake
    plurals
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. COread this post http://amiramk.wordpress.com/2012/07/24/entity-framework-5-and-enum-support/ ... I think it will give you better insight into EF 5 enum key support.
      singulars
      1. POCreating EF controls in MVC with enums as keys
      1. USDave Alperovich
    2. COCan you provide any of your code for your POCO objects (not the whole thing). Also are you using code first, models first, db first?
      singulars
      1. POCreating EF controls in MVC with enums as keys
      1. USMatt Whetton
    3. CO@MattWhetton I've added an example. I'm also using code first.
      singulars
      1. POCreating EF controls in MVC with enums as keys
      1. USJake
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload