Choosing between typed and untypes datasets .

Posted Date: 19 Jan 2005	Resource Type: Articles	Category: ASP.NET/Web Applications
Author: Rakesh Chander Sharma	Member Level: Silver
Rating:	Points: 7

Typed Dataset vs. untyped Datasets

A typed DataSet is DataSet that applies the information stored in XSD to generate a typed class. Information from the schema that contains the tables, columns, and rows is stored in a XSd file.The information regarding the table like column names and datatypes is already extracted out and stored in the XSD file. Pls note that if your table structure change frequently then u shud use untyped dataset because to acces the changes u again ned to do the modifications to the XSD file.

The normal DataSet is the one which we create programatically are the untyped datasets ,as the information is extracted during runtime .

Remeber the typed datasets are created during design time .Tou can easily get the difference between the two easily but by using them extensively in my recent project there is something i would like to discuss with you all.

Follwoing are the points you might want to conside while choosing Typed DataSet.

Typed datsets in some way reduce the overhead and might boost the performance as they already have the table schema with them

They reduce the chances of errors.

You can add validation code for the desired field in case of Typed datasets

They provide type-safe operations.

Any type mismatch erros can be caught at compile time instead of run time.

You can refer to the tables and columns with their respective name.No need to refer as tables(0) or column(0).

I see one disadvantage in using typed dataset if your table structure change frequently then u should use untyped dataset because to acces typed dataset changes u again need modify the XSD file.

On the whole it depends upon the project requirements and the functionality required which judges which of these two to use. Hope u find this article helpful .

Responses

Author: Ravi Makwana 21 Jan 2005

Member Level: Bronze Points : 0

It's a good article, but the concept was not fully covered. Secondly, an example or a link would have been better idea. The point is explained wat u hav experienced and not in general. Still, as per presentation and matter given, it's well and good.

Regards,

Author: Vijayakumaran 06 Jun 2005

Member Level: Silver Points : 0

its really a good article.
But, a small example for this could add a great value to this article and would help the readers a lot by gettiing in to the concepts easily. Hope, you would add an example for this article.
Good effort.

Feedbacks

Popular Tags

What are tags ?

Search Tags

(No tags found.)

Post Feedback

This is a strictly moderated forum. Only approved messages will appear in the site. Please use 'Spell Check' in Google toolbar before you submit.
You must Sign In to post a response.

	Next Resource: ASP.Net Performance
	Previous Resource: Performance Improvement in ASP.NET using Caching
	Return to Discussion Resource Index
	Post New Resource
	Category: ASP.NET/Web Applications

Post resources and earn money!

More Resources