EF adding User without User ID in Sql-Server

Question

I want to add Users to my database Using DB Set but I am collecting only information about the Username and the password how can I add without UserID?

This is my constructor:

public class User
    {
        [Key]
        public int Id { get; set; }

        [Required]
        [MaxLength(30)]
        public string Username { get; set; }

        [Required]
        [MaxLength(30)]
        public string Password { get; set; }

        public List<Note> Notes { get; set; }

        public User(string username, string password)
        {
            this.Id =  1;
            this.Username = username;
            this.Password = password;
        }

And this is my Adding method:

                User user = new User(username, password);
                UserContext.Users.Add(user);
                UserContext.SaveChanges();

When I execute my code the database is still empty.

Can you share your entire user model please?

yannick
– yannick

2019-03-20 13:14:37 +00:00
Commented Mar 20, 2019 at 13:14 — yannick
– yannick, Commented Mar 20, 2019 at 13:14
Yes, I edited the post

Георги Димитров
– Георги Димитров

2019-03-20 13:30:09 +00:00
Commented Mar 20, 2019 at 13:30 — Георги Димитров
– Георги Димитров, Commented Mar 20, 2019 at 13:30

valerian Havaux · Accepted Answer · 2019-03-20 13:57:57Z

1

Try annotate the property like below to use the Auto-Increment https://www.w3schools.com/sql/sql_autoincrement.asp.

public class User
{
    [Key]
    [DatabaseGenerated(DatabaseGeneratedOption.Identity)]
    public int Id { get; set; }

    [Required]
    [MaxLength(30)]
    public string Username { get; set; }

    [Required]
    [MaxLength(30)]
    public string Password { get; set; }

    public List<Note> Notes { get; set; }

    public User(string username, string password)
    {
        this.Username = username;
        this.Password = password;
    }
}

or use fluent api like this

modelBuilder.Entity<User>()
            .HasKey(p => new { p.Id });

modelBuilder.Entity<User>().Property(p => p.Id).HasDatabaseGeneratedOption(DatabaseGeneratedOption.Identity);

answered Mar 20, 2019 at 13:57

valerian Havaux

1115 bronze badges

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

Collectives™ on Stack Overflow

EF adding User without User ID in Sql-Server

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related