Strong Type Class Generator

[John Mark Howell]

Does anyone know if there is a utility that VS uses to generate the Strongly
Typed Dataset classes for C#? Right now, it blows when you try to have a
default on a DateTime column because a DateTime is not CLS compliant.

BTW, what date / time type are we supposed to use if we need CLS
compliance???

[Daniel O'Connell [C# MVP]]

BTW, what date / time type are we supposed to use if we need CLS
compliance???

You've *really* got to stop posting the same question everywhere. Its
obnoxious and won't help you get your question answered.

[John Mark Howell]

OK, Dannyboy, you tell my company to put OE back on my computer or re-write
Microsoft's H&S front end or stop complaining. I was using OE until two
days ago when my company removed it for security reasons. I needed to ask a
simple question in the news groups and Microsoft's H&S front end does *NOT*
allow mutli-group posting.

"Daniel O'Connell [C# MVP]" wrote:

BTW, what date / time type are we supposed to use if we need CLS
compliance???

You've *really* got to stop posting the same question everywhere. Its
obnoxious and won't help you get your question answered.

[Daniel O'Connell [C# MVP]]

"John Mark Howell" <Jo************@discussions.microsoft.com> wrote in
message news:95**********************************@microsof t.com...

OK, Dannyboy, you tell my company to put OE back on my computer or
re-write
Microsoft's H&S front end or stop complaining. I was using OE until two
days ago when my company removed it for security reasons. I needed to ask
a
simple question in the news groups and Microsoft's H&S front end does
*NOT*
allow mutli-group posting.

*ONE* bloody question in *ONE* newsgroup would have done fine, most people
read a wide range of them, I obviously do. Instead you have the same
question across a half dozen groups(some of which with different
information) and a different set of threads going in atleast three of them
now.

Your question really isn't important enough to need to ask it in every
single group that it even has a passing resemblence to being ontopic on.

[John Mark Howell]

Well, Dannyboy, since you have declared that no one in Microsoft's
newsgroups should multi-group post, and you've flamed me twice, you must be
so unbelievably smart that you should be able to answer this simple
question, shouldn't you? Or is this one too tough for even the great Danny
O.
Answer this and I'll post an apology to you in every group I posted in.

How do I put a default on a DateTime field in an XSD for Visual Studio to
correctly generate the CS with the default coded for the column? I don't
want to you simply say, "It can't be done". I also don't want you to tell
me to simply "edit the CS after it is generated". I also don't want you to
say "it will work in whidbey". Let's see what you can come up with.

[Daniel O'Connell [C# MVP]]

> Well, Dannyboy, since you have declared that no one in Microsoft's

newsgroups should multi-group post, and you've flamed me twice, you must
be so unbelievably smart that you should be able to answer this simple
question, shouldn't you? Or is this one too tough for even the great
Danny O.
You want a flame? Ok, got one for ya...You are an idiot. Your logic is
throughly flawed and your arguments are extremely personal. Your rude,
unable to form a clear question, and quite unworth answering. Furthermore, I
have declared nothing. Multiposting like this is, in general, rude and
unhelpful. It irks the people who are here trying to help you as they have
to pay attention across multiple groups(especially when the poster is
incapable of responding to one without refering or inferencing the other)
and it marks you as lazy, impatient, and a bit self important.

Had I noticed that you multiposted, I likely would have not bothered
responding at all. There are thousands of messages here, billboarding, clock
advancing, and multiposting do little but push you towards the back of the
queue, if not off it entirely.

I doubt I'm alone on that.
How do I put a default on a DateTime field in an XSD for Visual Studio to
correctly generate the CS with the default coded for the column? I don't
want to you simply say, "It can't be done". I also don't want you to
tell me to simply "edit the CS after it is generated". I also don't want
you to say "it will work in whidbey". Let's see what you can come up
with.

I can tell you that xsd.exe\MSDataSetGenerator is lacking in a number of
ways atleast in 2k3, I've never tried it on whidbey so I couldn't say. And I
will also tell you that you would have a better shot at getting an answer on
a data or xml group than you will here. I despise XSD and pretty much avoid
datasets at all costs(I prefer entity objects combined with data readers).

And, fwiw, DataSet supports a WriteXml method that can spit out a schema
using a particular XmlWriteMode enumeration member. Perhaps you can pump out
a column with a default value, write the schema, and see what that produces?
If the generated dataset doesn't produce a column default, I would imagine
the generator simply doesn't support it.

If that doesn't work, you might also want to consider a replacement dataset
generator. I don't know of any off hand, as I've said before its not really
my core competency.

Repost your query into the ado group, they will likely know more about
strongly typed datasets.

[John Mark Howell]

You are calling me rude?!? You are saying that my remarks are personal?!?!?
You just called me an idiot! You said my logic is flawed and you have no
idea what I'm coding! You started this flame thread not me. But you know
what, as much as I'm itching to flame you back, I will not. Not because I
don't want to, but I feel everyone is entitled to their own opinions, even
you. I should not have called you Dannyboy and for that one I do apologize.
I should have just informed you that I don't agree with you. I do not
apologize for multi-group posting. I needed an urgent answer. 90% of the
time I find my answer by Googling even before I do any posting, but not this
time.

I despise XSD and pretty much avoid datasets at all costs(I prefer entity objects combined with data readers).

I am in agreement, however, I'm in a group project and this is a requirement
so I have to support it.
DataSet supports a WriteXml method

I did try that. I can build the XSD, I just cannot get the
StronglyTypedClass generator to generate it.

As for a solution, I will re-post to the ADO group and see if someone there
has insight to this problem. Thanks for your suggestions.

[Daniel O'Connell [C# MVP]]

"John Mark Howell" <Jo************@discussions.microsoft.com> wrote in
message news:F1**********************************@microsof t.com...

You are calling me rude?!? You are saying that my remarks are
personal?!?!?
You just called me an idiot! You said my logic is flawed and you have no
Your logic is flawed inasmuch as that I'm going to know an answer simply
because I don't like your multiposting, and, secondly, that you don't want a
"it can't be done" answer.

Sometimes, sadly, that is the answer.
idea what I'm coding! You started this flame thread not me. But you know No, I simply suggested, a touch harshly perhaps, that multiposting was not
the best way to get an answer. Again, I would not have replied had I seen
the multipost. I'm sure you lost some other potential respondants for the
same reason.

I despise XSD and pretty much avoid

datasets at all costs(I prefer entity objects combined with data readers).

I am in agreement, however, I'm in a group project and this is a
requirement
so I have to support it.

Ya, sometimes you get stuck with that, however, you'll have to work around
it or make your case for entity objects.

DataSet supports a WriteXml method

I did try that. I can build the XSD, I just cannot get the
StronglyTypedClass generator to generate it.

Then I suspect that the generator simply doesn't support the feature.
As for a solution, I will re-post to the ADO group and see if someone
there
has insight to this problem. Thanks for your suggestions.

Good luck.

[John Mark Howell]

I thought you might be interested in this. The tool that is used is XSD.EXE
in the .Net SDK.
ms-help://MS.MSDNQTR.2004JUL.1033/cpguide/html/cpconGeneratingStronglyTypedDataSet.htm

I don't know what features are and are not supported. When I find out, I'll
let you know.
Thanks again.

[Ravichandran J.V.]

There is a utility called xsd.exe but whether or not, VS.Net uses it I
cannot vouch for. Anyway, why don't you use the FillSchema method of the
dataadapter to fill the dataset with the schema then work out the other
aspects of developing a strongly typed dataset. The FillSchema method
usually suffices, though your requirements may require more.

with regards,
J.V.Ravichandran
- http://www.geocities.com/
jvravichandran
- http://www.411asp.net/func/search?
qry=Ravichandran+J.V.&cob=aspnetpro
- http://www.southasianoutlook.com
- http://www.MSDNAA.Net
- http://www.csharphelp.com
- http://www.poetry.com/Publications/
display.asp?ID=P3966388&BN=999&PN=2
- Or, just search on "J.V.Ravichandran"
at http://www.Google.com

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!