Create class objects from a database

Question

How do you create a new class object and add data to it from a database?

I have a table(tblCars) in a database and would like to loop through each row(Using sqldatareader?) and create a new object named after the primary key(Registration number), then add data to it from the other columns.

So instead of this:

carClass car1 = new carClass();
car1.registration = "RT11 HWY";
car1.make = "Ford";

It would be something like:

//connection and reader stuff
carClass <registration> = new carClass();
<registration>.registration = column1;
<registration>.make = column2;

Honza Brestan · Accepted Answer · 2012-11-25 15:10:59Z

4

You can use some lightweight ORM for this kind of mapping. Take a look here, there are many free solutions for this. There are also at least two made by Microsoft, LINQ to SQL and Entity Framework

answered Nov 25, 2012 at 15:10

Honza Brestan

11k2 gold badges37 silver badges44 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

marc_s Over a year ago

Also: see Dapper Dot Net which powers this site :-)

Collectives™ on Stack Overflow

Create class objects from a database

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related