views:

207

answers:

3

Trying to use a typed dataset with nullable fields...

As been the case since the dawn of time, the typed dataset generator of visual studio does not support nullable types.

Is there, somewhere in the net, a generator for a properly typed dataset?

Thank you.

+1  A: 

Have you considered using Entity Framework instead of typed datasets? Older technology isn't updated as quickly as newer.

John Saunders
From what I've read, EF is not mature enough.
Stecy
Not mature enough for what, exactly? Why do you specifically need typed datasets?
Jacob
Unfortunately I don't remember why... I only remembered to not use EF until .NET 4.0 based on what I read a while back.
Stecy
There are enhancements in 4.0, but it's quite sufficiently mature.
John Saunders
I'll have a look at EF again then. Do you know if EF allows to use a DataSet as input as our closed-source vendor library we use returns a dataset?
Stecy
Wait. I was suggesting you use EF instead of datasets.
John Saunders
Exactly. But my input is not from a database but from a never-connected disconnected dataset coming from a vendor library.
Stecy
I don't know whether EF would work for your situation. Maybe, since it's now possible to create a DataReader over the contents of an existing DataTable. But you'd have to create your EF model without a database, and I don't know if that's supported.
John Saunders
A: 

Because EF generates totally unoptimized garbage sql that you have zero control over, that's why.

Jay Baywatch
A: 

EF can map to templated stored procedures which is much more than zero control over sql execution

rygar