Entity Framework cannot add new data on model

Question

i have a project where i work with a bookshop. And when a user buys a book, i want to add a record in the SoldBooks table with info about the book and the user. But everything is fine with the add except when i want to add the User Id. Visual studio wont allow me to add an int "Cannot Implicitly convert type INT to models.User"

db.SoldBooks.Add(new SoldBook
{
 Title = book.Title,
 Author = book.Author,
 Price = book.Price,
 PurchaseDate = DateTime.Now,
 CategoryId = catid,
 User = 1                           
});
db.SaveChanges();

But when i check my database the field UserId says its an INT

What should i do to be able to add the User ID to a new record? Thank you

Models/User.cs

class User
    {
        public int Id { get; set; }
        [Required]
        public string Name { get; set; }
        [Required]
        public string Password { get; set; }
        public DateTime LastLogin { get; set; }
        public DateTime SessionTimer { get; set; }
        public bool IsActive { get; set; }
        public bool IsAdmin { get; set; }
    }

Models/SoldBook.cs

class SoldBook
    {
        [Key]
        public int Id { get; set; }
        public string Title { get; set; }
        public string Author { get; set; }
        public int CategoryId { get; set; }
        public int Price { get; set; }
        public DateTime PurchaseDate { get; set; }
        public User User { get; set; }
    }

TheMixy · Accepted Answer · 2021-03-19 08:10:23Z

2

Make this changes (you have to add info about the ForeignKey so EF can know how both tables are related):

class SoldBook
{
    [Key]
    public int Id { get; set; }
    public string Title { get; set; }
    public string Author { get; set; }
    public int CategoryId { get; set; }
    public int Price { get; set; }
    public DateTime PurchaseDate { get; set; }
        
    public int IdUser { get; set; }
    [ForeignKey("IdUser")]
    public User User { get; set; }
}

and then add the record:

db.SoldBooks.Add(new SoldBook
{
 Title = book.Title,
 Author = book.Author,
 Price = book.Price,
 PurchaseDate = DateTime.Now,
 CategoryId = catid,
 IdUser = 1                           
});
db.SaveChanges();

answered Mar 19, 2021 at 8:10

TheMixy

1,3362 gold badges19 silver badges40 bronze badges

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

Comments

Marius Lukošiūnas · Accepted Answer · 2021-03-19 08:08:48Z

1

You should add additional UserId field to your SoldBook object and use it instead of User

public int UserId { get; set; }

answered Mar 19, 2021 at 8:08

Marius Lukošiūnas

565 bronze badges

Collectives™ on Stack Overflow

Entity Framework cannot add new data on model

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related