What is the purpose of Dataset in ADO.NET?

In your applications, you might want to connect to a data store (for example, SQL Server), fetch data, do some manipulations on the data and update the changes in datastore. For this, the recommended approach is to connect and fetch data from data store.



Disconnect the connection, manipulate the data and then post the changes to the data store by establishing a connection again. This approach is possible in ADO.NET using dataset object. Dataset object helps you to manipulate on set of records obtained from disconnected data store.

The architecture of dataset object is shown below:



In the diagram, 1..n means “one or many instances”. For example, DataTable(1..n) means that Dataset can contain one or more DataTable objects. And the rhombus indicates parent/child relationship that exists between the DataTables.

| What is Private Access Modifier in C#? | What is Protected Access Modifier in C#? | What is Protected Internal Access Modifier in C#? | What is Public Access Modifier in C#? | What is the difference between virtual and abstract keywords in .NET? | What is the importance of Microsoft Application Blocks in .NET Architecture? | What is the need for Factory Method in C# | What is the purpose of ArrayList in .NET? | What is the purpose of Datareader in ADO.NET? | What is the purpose of Dataset in ADO.NET? | What is the purpose of finally block in C#? | What is the purpose of interlocked class in .NET? | What is the purpose of main() function in C# | What is the purpose of ManualResetEvent in .NET? | What is the purpose of sealed method in C#? | What is the purpose of Thread.Join() method in .NET? | What is the purpose of Thread.Sleep() method in .NET? | What is the purpose of throw keyword in C#? | What is the usage of ENUM in .NET? |


“Amazon and the Amazon logo are trademarks of Amazon.com, Inc. or its affiliates.”

| Privacy Policy for www.dotnet-guide.com | Disclosure | Contact |

Copyright - © 2004 - 2024 - All Rights Reserved.