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.

 

[Liz]

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.

 

[Mark Rae [MVP]]

SMO?

http://msdn2.microsoft.com/en-us/library/ms162169.aspx

 

[bruce barker]

see typed datasets.

http://msdn2.microsoft.com/en-us/library/esbykkzb(vs.71).aspx

-- bruce (sqlwork.com)

 

[Patrice]

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

 

[Jonathan Wood]

Thanks!

 

[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]

I'll check that out. Thanks.