Populate a class automatically?

[Steven Blair]

I am using an objectdatasource and binding to an aggregate data type.

My aggregate data type is ebing populated like:

http://www.rafb.net/paste/results/6WeLS821.html

Is there some way of automatically doing this?
Something like:

MyClass = myDataSet; //yes I want to be lazy :P

The approach on the code uses only a couple of parameters which is fine,
but my app will have excess of 20 parameters.

Thanks in advance

Steven

*** Sent via Developersdex http://www.developersdex.com ***

[Brian]

You could build a constructor that takes a dataset, or use a code
generator to do all the boring monkey code.

BugSentry needs beta testers!
www.bugsentry.com

*** Sent via Developersdex http://www.developersdex.com ***

[sdurity]

Check out DevForce from IdeaBlade (www.ideablade.com). There is a free
Express version for client-server, SQL Server applications. Anyway, it
generates your business objects from your database schema (with your
tweaks). It also handles the bi-directional data binding and other
complexities of building regular database business applications. I'm a
satisfied client.

[Robbe Morris [C# MVP]]

I built a code generator to do all this crap for me.
I'm not proud of the code in the sample but the
code it generates is pretty solid.

http://www.eggheadcafe.com/articles/..._generator.asp

--
Robbe Morris - 2004-2006 Microsoft MVP C#
http://www.eggheadcafe.com/forums/merit.asp

"Steven Blair" <st**********@btinternet.com> wrote in message
news:Ob**************@TK2MSFTNGP11.phx.gbl...

I am using an objectdatasource and binding to an aggregate data type.

My aggregate data type is ebing populated like:

http://www.rafb.net/paste/results/6WeLS821.html

Is there some way of automatically doing this?
Something like:

MyClass = myDataSet; //yes I want to be lazy :P

The approach on the code uses only a couple of parameters which is fine,
but my app will have excess of 20 parameters.

Thanks in advance

Steven

*** Sent via Developersdex http://www.developersdex.com ***

[Mark Rae]

"Robbe Morris [C# MVP]" <in**@eggheadcafe.com> wrote in message
news:OS**************@TK2MSFTNGP10.phx.gbl...

I built a code generator to do all this crap for me.

Me too. Basically, it is a simple WinForms app which works thus:

1) The user types in the SQL Connection string and hits the "Connect"
button.

2) Assuming the connection is successful, a ComboBox is populated with all
the user tables in the database specified in the SQL connection string

3) When the user selects one of the tables listed in the ComboBox, the
following code is generated:

a) INSERT stored procedure
b) UPDATE stored procedure
c) DELETE stored procedure
d) EXISTS stored procedure
e) SELECT stored procedure
f) C# class with all of the fields from the tables as properties, an
Insert() method, an Update() method, a Delete() method, an Exists() method
and a Select() method

This does about 95% of everything I need.

[Robbe Morris [C# MVP]]

than generating basic stuff. This guy creates object oriented
layers of ADO.NET code based on the existing stored procedures
and tables.

--
Robbe Morris - 2004-2006 Microsoft MVP C#
http://www.eggheadcafe.com/forums/merit.asp

"Mark Rae" <ma**@markN-O-S-P-A-M.co.uk> wrote in message
news:%2****************@TK2MSFTNGP12.phx.gbl...

"Robbe Morris [C# MVP]" <in**@eggheadcafe.com> wrote in message
news:OS**************@TK2MSFTNGP10.phx.gbl...

I built a code generator to do all this crap for me.

Me too. Basically, it is a simple WinForms app which works thus:

1) The user types in the SQL Connection string and hits the "Connect"
button.

2) Assuming the connection is successful, a ComboBox is populated with all
the user tables in the database specified in the SQL connection string

3) When the user selects one of the tables listed in the ComboBox, the
following code is generated:

a) INSERT stored procedure
b) UPDATE stored procedure
c) DELETE stored procedure
d) EXISTS stored procedure
e) SELECT stored procedure
f) C# class with all of the fields from the tables as properties, an
Insert() method, an Update() method, a Delete() method, an Exists() method
and a Select() method

This does about 95% of everything I need.