Shortcut for Converting Table to Class

[Jonathan Wood]

Just out of curiosity, I don't suppose ASP.NET provides any tools to make it
easier to read a table from a database and convert it to a class object,
does it?

As it is, I need to create a class for each table type, manually type in all
the members, and then write code to read the database, and finally to copy
the database table to the class, checking nullable fields with IsDBNull().

Just wanted to make sure there isn't a better way.

Also, it would also be nice if there was a shortcut for exposing private
members. As it is, I declare all my private members, and then type in all
the public get/set statements of the public property. Like everything else
in .NET, seems like a lot of typing.

Thanks.

--
Jonathan Wood
SoftCircuits Programming
http://www.softcircuits.com

[Liz]

"Jonathan Wood" <jw***@softcircuits.comwrote in message
news:eh****************@TK2MSFTNGP05.phx.gbl...

Just out of curiosity, I don't suppose ASP.NET provides any tools to make
it easier to read a table from a database and convert it to a class
object, does it?

As it is, I need to create a class for each table type, manually type in
all the members, and then write code to read the database, and finally to
copy the database table to the class, checking nullable fields with
IsDBNull().

Just wanted to make sure there isn't a better way.

Also, it would also be nice if there was a shortcut for exposing private
members. As it is, I declare all my private members, and then type in all
the public get/set statements of the public property. Like everything else
in .NET, seems like a lot of typing.

it would be fairly easy to write a little code generator to do all of that
with SMO ... or look at the product at simego.com

[Jonathan Wood]

SMO?

I'll check out simego.com.

Thanks.

--
Jonathan Wood
SoftCircuits Programming
http://www.softcircuits.com

"Liz" <li*@tiredofspam.comwrote in message
news:Ol**************@TK2MSFTNGP06.phx.gbl...

>
"Jonathan Wood" <jw***@softcircuits.comwrote in message
news:eh****************@TK2MSFTNGP05.phx.gbl...

>Just out of curiosity, I don't suppose ASP.NET provides any tools to make
it easier to read a table from a database and convert it to a class
object, does it?

As it is, I need to create a class for each table type, manually type in
all the members, and then write code to read the database, and finally to
copy the database table to the class, checking nullable fields with
IsDBNull().

Just wanted to make sure there isn't a better way.

Also, it would also be nice if there was a shortcut for exposing private
members. As it is, I declare all my private members, and then type in all
the public get/set statements of the public property. Like everything
else in .NET, seems like a lot of typing.

it would be fairly easy to write a little code generator to do all of that
with SMO ... or look at the product at simego.com

[Mark Rae [MVP]]

"Jonathan Wood" <jw***@softcircuits.comwrote in message
news:eO**************@TK2MSFTNGP05.phx.gbl...

SMO?

http://msdn2.microsoft.com/en-us/library/ms162169.aspx
--
Mark Rae
ASP.NET MVP
http://www.markrae.net

[=?Utf-8?B?YnJ1Y2UgYmFya2Vy?=]

see typed datasets.

http://msdn2.microsoft.com/en-us/lib...zb(vs.71).aspx

-- bruce (sqlwork.com)
"Jonathan Wood" wrote:

Just out of curiosity, I don't suppose ASP.NET provides any tools to make it
easier to read a table from a database and convert it to a class object,
does it?

As it is, I need to create a class for each table type, manually type in all
the members, and then write code to read the database, and finally to copy
the database table to the class, checking nullable fields with IsDBNull().

Just wanted to make sure there isn't a better way.

Also, it would also be nice if there was a shortcut for exposing private
members. As it is, I declare all my private members, and then type in all
the public get/set statements of the public property. Like everything else
in .NET, seems like a lot of typing.

Thanks.

--
Jonathan Wood
SoftCircuits Programming
http://www.softcircuits.com

[Patrice]

.... or you could also evaluate if LINQ would fit :
http://msdn2.microsoft.com/en-gb/library/bb397897.aspx

--
Patrice

"Jonathan Wood" <jw***@softcircuits.coma écrit dans le message de news:
eh****************@TK2MSFTNGP05.phx.gbl...

Just out of curiosity, I don't suppose ASP.NET provides any tools to make
it easier to read a table from a database and convert it to a class
object, does it?

As it is, I need to create a class for each table type, manually type in
all the members, and then write code to read the database, and finally to
copy the database table to the class, checking nullable fields with
IsDBNull().

Just wanted to make sure there isn't a better way.

Also, it would also be nice if there was a shortcut for exposing private
members. As it is, I declare all my private members, and then type in all
the public get/set statements of the public property. Like everything else
in .NET, seems like a lot of typing.

Thanks.

--
Jonathan Wood
SoftCircuits Programming
http://www.softcircuits.com

[Jonathan Wood]

Thanks!

--
Jonathan Wood
SoftCircuits Programming
http://www.softcircuits.com

"Mark Rae [MVP]" <ma**@markNOSPAMrae.netwrote in message
news:eZ**************@TK2MSFTNGP05.phx.gbl...

"Jonathan Wood" <jw***@softcircuits.comwrote in message
news:eO**************@TK2MSFTNGP05.phx.gbl...

>SMO?

http://msdn2.microsoft.com/en-us/library/ms162169.aspx
--
Mark Rae
ASP.NET MVP
http://www.markrae.net

[Jonathan Wood]

Thanks, although I've looked into LINQ a bit already and have trouble really
seeing why it is useful. I'll check out that link though.

--
Jonathan Wood
SoftCircuits Programming
http://www.softcircuits.com

"Patrice" <http://www.chez.com/scribe/wrote in message
news:uV*************@TK2MSFTNGP06.phx.gbl...

... or you could also evaluate if LINQ would fit :
http://msdn2.microsoft.com/en-gb/library/bb397897.aspx

--
Patrice

"Jonathan Wood" <jw***@softcircuits.coma écrit dans le message de news:
eh****************@TK2MSFTNGP05.phx.gbl...

>Just out of curiosity, I don't suppose ASP.NET provides any tools to make
it easier to read a table from a database and convert it to a class
object, does it?

As it is, I need to create a class for each table type, manually type in
all the members, and then write code to read the database, and finally to
copy the database table to the class, checking nullable fields with
IsDBNull().

Just wanted to make sure there isn't a better way.

Also, it would also be nice if there was a shortcut for exposing private
members. As it is, I declare all my private members, and then type in all
the public get/set statements of the public property. Like everything
else in .NET, seems like a lot of typing.

Thanks.

--
Jonathan Wood
SoftCircuits Programming
http://www.softcircuits.com

[Jonathan Wood]

I'll check that out. Thanks.

--
Jonathan Wood
SoftCircuits Programming
http://www.softcircuits.com

"bruce barker" <br*********@discussions.microsoft.comwrote in message
news:3D**********************************@microsof t.com...

see typed datasets.

http://msdn2.microsoft.com/en-us/lib...zb(vs.71).aspx

-- bruce (sqlwork.com)
"Jonathan Wood" wrote:

>Just out of curiosity, I don't suppose ASP.NET provides any tools to make
it
easier to read a table from a database and convert it to a class object,
does it?

As it is, I need to create a class for each table type, manually type in
all
the members, and then write code to read the database, and finally to
copy
the database table to the class, checking nullable fields with
IsDBNull().

Just wanted to make sure there isn't a better way.

Also, it would also be nice if there was a shortcut for exposing private
members. As it is, I declare all my private members, and then type in all
the public get/set statements of the public property. Like everything
else
in .NET, seems like a lot of typing.

Thanks.

--
Jonathan Wood
SoftCircuits Programming
http://www.softcircuits.com