SiteMap  | About    

Difference between Typed DataSets and UnTyped DataSets

Strongly Typed Datasets


A Strongly Typed Dataset is a custom class and it consists of classes derived form DataSet, DataTable and DataRow. A typed class assumes all of the functionality of the DataSet class and can be used with methods that take an instance of a DataSet class as a parameter. It is bind with the database tabless at design time and you have all the schema information at design time in your code.

It is stored in an .xsd file and do error checking regarding their schema at design time using the .xsd definitions. You can access the tables and columns with the actual names because it is added as .xsd file in your application. In case of a Strongly Typed Datasets, you are the one who tells what to do. You can specify exactly what you want, no matter if it is not exactly what you have in the database.

C# Strongly Typed Datasets example     VB.Net Strongly Typed Datasets example

UnTyped DataSets

DataSet ds = new DataSet();

An UnTyped DataSet is an instance of class System.Data.DataSet. It is binded with the tables at runtime and there no corresponding built-in schema. You are not aware of the schema of the dataset at design time and there is no error checking facility at the design time as they are filled at run time when the code executes.

C# Dataset Samples     VB.Net Dataset Samples (C) 2016    Founded by raps mk
All Rights Reserved. All other trademarks are property of their respective owners.