C# is having Dataset and datatables which can be used much similar to external database (eg. ms access database (.mdb)).
Even when the database is more optmized to handle query for selection and sorting, it is advisable to use built-in Dataset/Datatables.
Because I/O operations between the C#/.net application and the external database will consume significant time which will ultimately reduce the performance/speed of execution.
I can see significant performance difference between these two approaches when we did some performance testing using the code developed based on database and the code using built-in datatables.
But I am not sure whether Dataset will be useful if we need to handle large amount of data.
More Articles...
Popular Posts
- Software Testing Quiz Questions and Answers
- Javascript Quiz Questions and Answers
- MySQL Quiz Questions and Answers
- SEO Your Blog the Easy Way - Guest Post
- SEO (Search Engine Optimization) Quiz Questions and Answers.
- HTML Quiz Questions and Answers
- PHP Quiz Questions and Answers
- Best Motivational Quotes Book | Kindle eBook and Paperback | Read for FREE with Amazon's Kindle Unlimited
- Basic Computer Hardware Quiz Questions and Answer.
- Use of tinyurl in Twitter

1 comment:
Here is a database compatible with .NET, Silverlight, Windows Phone, Mono, Monodroid, and Monotouch:
http://www.kellermansoftware.com/p-43-ninja-net-database-pro.aspx
Post a Comment