When adding controller unable to get metadata mvc4

Question

I am trying to create my first mvc class and am having an issue getting started. I am using a shared database on my hosting account and have created the following class

namespace MvcApplication2.Models
{
    public class tUsers
    {

            public int UserID { get; set; }
            public string Username { get; set; }
            public string UserEmail { get; set; }
            public string UserPassword { get; set; }
            public int GroupId { get; set; }


    }

    public class tUsersDBContext : DbContext
    {
        public DbSet<tUsers> tUsers { get; set; }
    }
}

and here is my connection string

   <add name="DefaultConnection" connectionString="Data Source=gdfgdfgdfg;Initial Catalog=fsdf_fdsf;Persist Security Info=True;User ID=ddd_reddntal;Password=fgfggfdg" providerName="System.Data.SqlClient" />

the error i get is

Unable to retrieve metadata for 'mvcapplication2.models.tusers' one or more validation errors were detected during model generation:

Entity type users has no defended key.

Also do my model names need to match my table names exact?

Eranga · Accepted Answer · 2012-08-14 04:21:47Z

5

Entity Framework can not identify the primary key property of your tUsers class. Annotate UserID property with Key attribute. If your table name is different from the class name use the Table attribute to specify the table name.

Try to use proper naming conventions for class names. In this case it should be User not tUsers.

[Table("MyTableName")]
public class tUsers
{       
        [Key]
        public int UserID { get; set; }
        public string Username { get; set; }
        public string UserEmail { get; set; }
        public string UserPassword { get; set; }
        public int GroupId { get; set; }
}

answered Aug 14, 2012 at 4:21

Eranga

32.5k5 gold badges100 silver badges98 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Joost Schepel Over a year ago

It can automatically find your primary key if you name the column Id instead of UserId, but personally I never use it, just to let you know

HELP_ME Over a year ago

this worked great but now i am getting the following error CREATE DATABASE permission denied in database 'master'.

Chandra Malla · Accepted Answer · 2014-02-03 03:59:27Z

0

Please make sure you have defined Id as Primary key in your Table and also Make sure you have properly defined properties for your Model Class. Also Please add your proper connection string to config file in addition to DefaultConnection provided by application. I hope this will help.

Thanks

answered Feb 3, 2014 at 3:59

Chandra Malla

2,44923 silver badges12 bronze badges

Collectives™ on Stack Overflow

When adding controller unable to get metadata mvc4

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related