Databases
StackOverflow2013
Postsdbo
POEntity Framework Code-First Issues (SimpleMembership UserProfile table)
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POEntity Framework Code-First Issues (SimpleMembership UserProfile table)
    primarykey
    data
    text
    <p>If you've used ASP.NET MVC 4 you'll notice that the default for an Internet Application is to use the SimpleMembership provider, this is all well and good and works fine.</p> <p>The issue comes with the default database generation, they have a POCO for <code>UserProfile</code> defined like so:</p> <pre><code>[Table("UserProfile")] public class UserProfile { [Key] [DatabaseGeneratedAttribute(DatabaseGeneratedOption.Identity)] public int UserId { get; set; } public string UserName { get; set; } } </code></pre> <p>.. which is then generated like this:</p> <pre><code>using (var context = new UsersContext()) { if (!context.Database.Exists()) { // Create the SimpleMembership database without Entity Framework migration schema ((IObjectContextAdapter)context).ObjectContext.CreateDatabase(); } } </code></pre> <p>This works fine, the database is generated just fine and works without issue. However, if I am to change the POCO like this and delete the database:</p> <pre><code>[Table("UserProfile")] public class UserProfile { [Key] [DatabaseGeneratedAttribute(DatabaseGeneratedOption.Identity)] public int UserId { get; set; } public string EmailAddress { get; set; } public string FirstName { get; set; } public string Surname { get; set; } public string Country { get; set; } public string CompanyName { get; set; } } </code></pre> <p>Only the first 2 columns are generated, <code>UserId</code> and <code>EmailAddress</code>. It works just fine code-wise (talking login/registration), but obviously none of my other user data is stored.</p> <p>Am I missing something here? Surely it should generate the database based off the whole <code>UserProfile</code> object.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USRudi Visser
    plurals
    1. This table or related slice is empty.
    1. PL
      singulars
      1. LTLinked
    2. PL
      singulars
      1. LTLinked
    3. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POEntity Framework Code-First Issues (SimpleMembership UserProfile table)
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POEntity Framework Code-First Issues (SimpleMembership UserProfile table)
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POEntity Framework Code-First Issues (SimpleMembership UserProfile table)
      1. USHenk Holterman
      1. VTFavorite
    1. COLooks odd. Is this repeatable? I.e. Clean and rebuild everything, doublecheck the results. Are you looking at the right Db?
      singulars
      1. POEntity Framework Code-First Issues (SimpleMembership UserProfile table)
      1. USHenk Holterman
    2. CO@HenkHolterman Unfortunately yes, I've been driving myself mad for the past 2 days with this, I even tried attributing each column with it's own name and they're simply not there. What makes it worse is that `UserId` and `EmailAddress` (or whatever I rename these to) *are* there just fine.
      singulars
      1. POEntity Framework Code-First Issues (SimpleMembership UserProfile table)
      1. USRudi Visser
    3. CO@HenkHolterman Should also be worth noting that I've tried changing this table on a completely new project just as a test and it has the same issue. What I haven't tried is using Entity Framework standalone to generate the database, maybe I'll do that next, but would rather stay as aligned to the default ASP.NET MVC4 structure as possible for now..
      singulars
      1. POEntity Framework Code-First Issues (SimpleMembership UserProfile table)
      1. USRudi Visser
 

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