DataSet vs DataView

using dataview we can just create the view of the table and perform any updations or deletions it wont be affected on the database table.

whare as dataset is used for disconnected architecture and we can store any number of tables in the dataset form different data sources using data adapters

Comments

Post a Comment

Popular posts from this blog

Singleton pattern implementation in C#

using System; public sealed class Singleton { private static volatile Singleton instance; private static object syncRoot = new Object(); private Singleton() {} public static Singleton Instance { get { if (instance == null) { lock (syncRoot) { if (instance == null) instance = new Singleton(); } } return instance; } } } This approach ensures that only one instance is created and only when the instance is needed. Also, the variable is declared to be volatile to ensure that assignment to the instance variable completes before the instance variable can be accessed. Lastly, this approach uses a syncRoot instance to lock on, rather than locking on the type itself, to avoid deadlocks. This double-check locking approach solves the thread concurrency problems while avoiding an exclusive lock in every call to the Instance property method. It also allows you ...
Read more