I am building a website as a school project, which uses ASP.NET webservice. I am implementing the DAL, BLL structure in my webservice. As mentioned in most of the articles, the tableAdapter automatically generates the update method (the option is selected). In the BLL, I have a function called UpdateInformation , which in turn calls the tableAdapter.Update(). I want to know how does the TableAdapter.Update() method actually execute? To be more precise, if the user has updated only say 1 of the fields, does the update method still update all of the fields in the database? Or is it smart enough to only update the fields that have been changed?
If it is updating all fields no matter what, then my professor has suggested making individual updates for each field. Is that feasible?
I am trying to make the design as good as possible, as someone else will be continuing with this project once I graduate.