Hello friends, Let’s go through about DBNull today. DBNull represents a nonexistent value returned from the database. In a database, for example, a column in a row of a table might not contain any data whatsoever. That is, the column is considered to not exist at all instead of merely not having a value. A DBNull object… Continue reading Efficiently handling DBNull in C#
Category: ADO.NET/EF
Remove Duplicates in Dataset Efficiently
Hello guys, Do you remember the pain of removing duplicates in fetched dataset by looping, comparing etc. it can be handled easily by using DataView.ToTable Method. The syntax is below. DataView.ToTable(bool distinct, string[] columnNames) distinct: If it’s true, the returned DataTable contains rows that have distinct values for all its columns specified in the second… Continue reading Remove Duplicates in Dataset Efficiently