Need generic function(s) for connecting to DB and retrieve data

Question

I'm making a DAL class which I can use to connect to DB and retrieve data. I'm using SQL Server 2005 Express (and Visual Web Developer 2008 Express Edition).

I found several examples on the web for connecting an retrieving data. But none where made inn to a class object.

This is kind of a pseudocode I've put together. Can anyone help me with some code which I can use to get data from MS DB?

namespace development.DAL {

    public class myDAL
    {
        SqlConnection conn;
        string conStr = "myConnectionString";

        public myDAL()
        {
            string connStr = Config.Get(this.conStr);
            this.conn = new SqlConnection(connStr);
        }

        // Function for retrieving data from DB
        public DataSet GetAllRows(string table)
        {

            string sql = string.Format(@"
                SELECT  *
                FROM    '{0}';
                ", table);

            DataSet dbDataSet = Command.CreateDataSet(cmd);  //Pseudocode!
            return dbDataSet;
        }
    }
}

Paul Sasik · Accepted Answer · 2009-07-22 15:47:16Z

1

Steven, There are also code generators out there that will create a complete DAL layer for you. Often the procedure is as simple as pointing the code generator at a db, selecting your tables and clicking go...

Check out: http://www.mygenerationsoftware.com (free, open source and my current fave) http://www.codesmithtools.com (solid, professional, no longer free but with free trial)

And there are literally dozens of others.

answered Jul 22, 2009 at 15:47

Paul Sasik

81.9k23 gold badges152 silver badges194 bronze badges

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

2 Comments

Steven Over a year ago

hmm... will have a look at this. But it would be really cool if someone could cut'n'paste an example in here though :)

Steven Over a year ago

Thanks for the tip psasik. Will have a closer look at this tomorrow. This one looks good to: subsonictools.codeplex.com

Lazarus · Accepted Answer · 2009-07-22 15:17:47Z

0

Search online for the repository pattern, I think that's what you are looking for. It'll help you abstract the data storage from the actual mechanics of accessing the database. Additionally, you'll find it easier to test and debug (or at least I do).

answered Jul 22, 2009 at 15:17

Lazarus

43.2k4 gold badges47 silver badges54 bronze badges

4 Comments

gbn Over a year ago

.. and perhaps OP could also look at "SQL injection" too

Lazarus Over a year ago

Ah! Good advice ;)I'm still astonished how often you still see published examples of that kind, beginners are then lead... by the hand... into bad habits. Sometimes I think it would better to give an example of good practice that takes a bit more explanation rather than the quick and dirty one, after all long after the quick has departed the dirty remains.

Steven Over a year ago

I don't know about you guys, but I don't handle 'SQL injection' prevention in my DAL.

Lazarus Over a year ago

It's the safest place to do it.

Collectives™ on Stack Overflow

Need generic function(s) for connecting to DB and retrieve data

2 Answers 2

2 Comments

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related