I am curious the best way to update my table via LINQ/Entity Framework.
My table has a number of different fields for a WorkOrder.
Here is an example:
WorkOrder Id – Guid
WorkOrder Name – string
WorkOrder FileId – Guid
IsReportFile - Bool
IsOtherFile1 – Bool
IsOtherFile2 – Bool
IsOtherFile3 – Bool
CreateDt – Datetime
LastUpdatedDt - DateTime
Basically I keep the IsOtherFile1 – 2- 3 in another table and it is displaying on a grid where they can click an edit template and do inserts/updates/deletes. There is an X on the grid where they can delete this file – which is in a child grid of the work
order record. If they add an OtherFile1 I need to change the IsOtherFile1 column to true from false and update the LastUpdateDt etc. If they delete the OtherFile1 I need to change the IsOtherFile1 column to false from true and update the LastUpdateDt etc.
...
Go to the complete details ...