DB-Direct and batch update patterns in designing DAL?

Question

hi What's the difference between DB-Direct and batch update pattern in desiging DAL? TY

Kirtan Patel · Answer

DB-Direct In DB Directs the single record updated Immediately as you press Update Button :) in Batch Update First we have to find Which Rows have been Modified then Apply Changes in Database for those modified Rows at once :) you can use RowState propertie of row to check if its modified or not :)

Roei Bar · Answer

well this is preaty streight forward the answer: Batch Update is for Multiple Records and heavy commands while db direct is for a single command that wont overload the db too much on that single command