Pass data from database

Question

This question is complicated, but I hope you will understand my problem. I'm using databases for the first time, sql server with dataset and adapters. This is my application in brief:

I have MainManager that calls the method (LoadData) in the MotelManager and that method then calls the method (LoadDataFromDB) in DataAccess that is a DLL project.

My question and need for help and understanding is to begin with, how do I get the values from the columns in each row back to the calling method in MainManager?

One way could perhaps be to create some temporarily object like the code below and pass that object back, but I can't create an instance of it in DataAccess!? I'm always get's in trouble when it's about references and namespace :( Is this the best and simpliest way? Help is preciated! Thanks!

    public class TempObj
{
    public string Id { get; set; }
    public string Name { get; set; }
    public string Age { get; set; }
    public string Gender { get; set; }
    public string Type { get; set; }
    public string Category { get; set; }
    public string Info { get; set; }

    public TempObj()
    {
    }
}

R u using a service to call your dll ?

praveen
– praveen

2012-08-07 06:50:20 +00:00
Commented Aug 7, 2012 at 6:50 — praveen
– praveen, Commented Aug 7, 2012 at 6:50
Typed DataTables? Hmm, what do you mena?

3D-kreativ
– 3D-kreativ

2012-08-07 06:56:09 +00:00
Commented Aug 7, 2012 at 6:56 — 3D-kreativ
– 3D-kreativ, Commented Aug 7, 2012 at 6:56

Alex · Accepted Answer · 2012-08-07 06:52:30Z

1

You're going to need to "map" data in a class, as you already guessed. But there's no build the whole mapping structure from scratch.

You can use Entity Framework (a.k.a. "EF") which is an infrastructure to automatically generate classes which reflect your database. MSDN, as in most cases, is your best friend here: Getting Started (Entity Framework)

answered Aug 7, 2012 at 6:52

Alex

23.3k4 gold badges43 silver badges76 bronze badges

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

1 Comment

Alex Over a year ago

Not at all, it's the first which came to mind because it's Microsoft's, and in my case is the one I'm the most familiar with. Alternatives are all along the lines of this though, and FYI it looks way harder than it really is to implement. Visual Studio takes care via wizards of almost all the "behind the scenes" work.

Collectives™ on Stack Overflow

Pass data from 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