C#: What Else Do You Use Besides DataSet C#: What Else Do You Use Besides DataSet sql sql

C#: What Else Do You Use Besides DataSet


Since .NET 3.5 came out, I've exclusively used LINQ. It's really that good; I don't see any reason to use any of those old crutches any more.

As great as LINQ is, though, I think any ORM system would allow you to do away with that dreck.


We've moved away from datasets and built our own ORM objects loosely based on CSLA. You can get the same job done with either a DataSet or LINQ or ORM but re-using it is (we've found) a lot easier. 'Less code make more happy'.


I was fed up with DataSets in .Net 1.1, at least they optimised it so that it doesn't slow as exponentially for large sets any more.

It was always a rather bloated model - I haven't seen many apps that use most of its features.

SqlDataReader was good, but I used to wrap it in an IEnumerable<T> where the T was some typed representation of my data row.

Linq is a far better replacement in my opinion.