Data is not inserted into SQL table using entity framework

Question

I have a table in a sql server database. I am trying to insert data into the table using entity framework but it's not working as expected.

Table

CREATE TABLE [dbo].[UserCompletedWorkouts] (
[Id]        INT          NOT NULL IDENTITY(1,1),
[UsersName] VARCHAR (50) NULL,
[WorkoutId] INT          NULL,
PRIMARY KEY CLUSTERED ([Id] ASC)
);

Model

   public class UsersContext : DbContext
{
    public UsersContext()
        : base("DefaultConnection")
    {
    }
    public DbSet<ConfirmedWorkoutModel> ViewWorkout { get; set; }
}
    [Table("UserCompletedWorkouts")]
public class ConfirmedWorkoutModel
{
    public int Id { get; set; }
    public string UsersName { get; set; }
    public int WorkoutId { get; set; }
}

}

Controller

        public ActionResult Index(int Id)
    {
        db.ViewWorkout.Add(new ConfirmedWorkoutModel() { WorkoutId = Id,  UsersName = User.Identity.Name});
        return View(db.ViewWorkout.ToList());
    }

Anthony Chu · Accepted Answer · 2014-04-26 23:23:45Z

2

You need to call SaveChanges() on the context...

    db.ViewWorkout.Add(new ConfirmedWorkoutModel() { WorkoutId = Id,  UsersName = User.Identity.Name});
    db.SaveChanges();
    return View(db.ViewWorkout.ToList());

answered Apr 26, 2014 at 23:23

Anthony Chu

37.6k10 gold badges85 silver badges72 bronze badges

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

Collectives™ on Stack Overflow

Data is not inserted into SQL table using entity framework

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related