Note: Not all Recordset objects supports batch updating. Affects only visible records in the current chapter if Filter is set to a string criteria.
Scalability is related to performance, but it can't be identified exclusively with that.I have to update a column 'PPMOProject ID' in the table, but in such way that if it is empty and tricky part is I have a scope of only parent child relation ship in the table like if MP- master parent, P- parent, Child - C: ID Parent ID PPMOProject ID MP1 NULL NULL //updating here by 889 P1 MP1 898 //It should not update, because it contains already value P2 MP1 NULL//it should update by 889 if it is empty else skip it C1 P1 NULL//Here it should update by 898 C2 P1 NULL//Here it should update by 898 C3 P2 NULL//Here it should update by 889 As per above logic : When I updating PPMOProject ID in parent record, I have to check all children's and master children's , if the record is empty I have to update by Immediate record parent, it that parent is empty and need to update by master column ID, if parent record has column ID , should update by Parent ID itself.This should be done in C# and LINQ , I have tried by below logic : var child Projects = db. Where(m = As per above logic : When I updating PPMOProject ID in parent record, I have to check all children's and master children's , if the record is empty I have to update by Immediate record parent, it that parent is empty and need to update by master column ID, if parent record has column ID , should update by Parent ID itself.A Recordset object consist of records and columns (fields).In ADO, this object is the most important and the one used most often to manipulate data from a database.When a dataset has related tables, Visual Studio generates a Table Adapter Manager class that you use to do the updates.The Table Adapter Manager class ensures that updates are made in the correct order based on the foreign-key constraints that are defined in the database.NET: Architecting Applications for the Enterprise”. Regular contributor to MSDN Magazine and Dev Pro Connections Magazine, Dino is a frequent speaker at industry events all over the world including Microsoft Tech ED and Dev Connections. It allows programmers to build a web of in-memory objects and relate contents coming from different tables and even from different data sources.After a decade of Web development, Dino jumped on the mobile bandwagon and is actively developing for i Os, Android and WP7. When inter-related tables are involved with the process of query and update, code strategies are important to preserve scalability and maintain high performance. fetch data across different tables, join columns, and filter data based on some user-specific criteria.When you first open a Recordset, the current record pointer will point to the first record and the BOF and EOF properties are False.If there are no records, the BOF and EOF property are True.In the next section we will take a closer look at ADO's batch updates, what they can offer you, and why they are so important.However, in this section you won't need them to solve the problem of updating a join, because in ADO, joins are naturally updatable.After read your description, I need to confirm that you want to update PPMOProject ID in parent record. If value is null, updating this value, if it is null, skip it in child table? Best Regards, Eric Du MSDN Community Support Please remember to click "Mark as Answer" the responses that resolved your issue.