Edycja w bazie danych

[HttpPost]
        public ActionResult Index2 (Students stud)
        {        
            SqlConnection connection = new SqlConnection("Data Source = (localdb)\\MSSQLLocalDB; Initial Catalog = Bazastud; Integrated Security = True; MultipleActiveResultSets = True; Application Name = EntityFramework");
            //connection.Open();
            SqlCommand com = new SqlCommand("update Students set [Name] = @Name, [Surname] = @Surname, [Address] = @Address, [Field of Study] = @Field, [Year of Study] = @Year, [Date of birth] = @Date where Id = @Id", connection);
            com.Parameters.AddWithValue("@Name", stud.Name);
                com.Parameters.AddWithValue("@Id", stud.Id);
                com.Parameters.AddWithValue("@Surname", stud.Surname);
                com.Parameters.AddWithValue("@Address", stud.Address);
                com.Parameters.AddWithValue("@Field", stud.Field_of_Study);
                com.Parameters.AddWithValue("@Year", stud.Year_of_Study);
                com.Parameters.AddWithValue("@Date", stud.Date_of_birth);

                connection.Open();

                com.ExecuteNonQuery();

                //connection.Close();
            
            return View();