Map a dataset to a custom .NET object in ASP.NET

Question

I want to map data from datatable to custom .NET object. Let's say, I have a .NET object

Public Class MyClass
    Public ID
    Public Prop1
    Public Prop2
End Class

And a corresponding table in the database, which contains columns ID, Prop1 and Prop2.

I want to generate a list of .NET objects from the database. Currently I fill the dataset and map each property individually. Is there any way, to map the database automatically, so the properties would map according to property / column name.

'retreive dataset from db'
DaAdapter.Fill(ds)

'create a new list of my object'
Private l As New List(Of MyClass)

'iterate through dataset (this is the step I want to get rid of - of course'
'it could only work if the property of the MyClass and the column in '
'the database have the same name)'
For Each r As DataRow in ds.Tables(0).Rows
    Dim itm As New MyClass
    itm.ID = r("ID")
    itm.Prop1 = r("Prop1")
    itm.Prop2 = r("Prop2")
    l.Add(itm)
Next

Prashanth Thurairatnam · Accepted Answer · 2012-05-16 12:22:41Z

1

You can use some sort of Object Relational Mapping (ORM) framework. Entity Framework is one of them

answered May 16, 2012 at 12:22

Prashanth Thurairatnam

4,3592 gold badges17 silver badges17 bronze badges

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

Comments

Johnny_D · Accepted Answer · 2012-05-16 12:24:39Z

1

IMHO. The easiest way is using Linq2Sql

answered May 16, 2012 at 12:24

Johnny_D

4,6524 gold badges36 silver badges65 bronze badges

Comments

Community · Accepted Answer · 2017-05-23 11:48:46Z

1

There is no direct way , although many tools are available to create classes that exactly resembles database tables called Entity classes. See the following link for more details

Database tables to C# entity classes - generator for FluentNHibernate?

You can also use typeddataset, codesmith tool.

edited May 23, 2017 at 11:48

CommunityBot

11 silver badge

answered May 16, 2012 at 12:27

Imran Rizvi

7,47813 gold badges63 silver badges103 bronze badges

Comments

Diego · Accepted Answer · 2012-05-16 12:30:15Z

0

I suggest Entity Framework

You can use a database first approach where you just point to your database and it will create the Entities and associations for you.

Its really strait forward, I advise giving it a try

answered May 16, 2012 at 12:30

Diego

36.5k21 gold badges94 silver badges138 bronze badges

Collectives™ on Stack Overflow

Map a dataset to a custom .NET object in ASP.NET

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related