.NET (Core and Framework)

larsp777 wrote:

I think adding the "Seriously, do it" was unnecessary, like I was some idiot.

var movie = new Movie {
    Name = "Shrek!"
};

Movie movie = new Movie
{
  Name = "Batman vs Superman",
  ReleaseYear = 2016,
  Rating = 4.5
}

Movie movie = new Movie();
movie.Name = "Batman vs Superman";
movie.ReleaseYear = 2016;
movie.Rating = 4.5;

Movie movie = new Movie
{
  Name = "Batman vs Superman",
  ReleaseYear = 2016,
  Rating = 4.5,
  Actors = new List<string> { "Ben Afleck", "Jessie Eisenberg", "Gal Gadot", "Henry Cavill" }
};

public ActionResult DoMyThing(MyViewModel vm)
{
   if (vm.ChangeAddressFoo)
   {
      vm.PermanantAddress.CopyMethod(vm.PresentAddress);
      _context.MyRepoUpdateMethod(vm.PermanantAddress);
      return Json(new{Change = true})
   }
   return Json(new{Change = false})
}

1. Do your stored procedures need to run inside transactions?
2. Can they return data or are they execution only?
3. Can they accept tables?
4. How is the application going to know that it needs to call a particular procedure?
5. How are you going to map from code to parameters from your stored proc?
6. Do the procedures need to be retriable?