Need help about DbHelper class.

DungPT · August 9th, 2009, 11:25 AM

In method GetHRPaidTimeOffConnectionString(),

I can't use ConfigurationManager class to get connection string in web.config because it doesn't appear in ItelliSense.

When I copy DBHelper.cs file in source code of this book to Framework folder and press Ctrl + F5 to run project,

one error come up:

"The name 'ConfigurationManager' does not exist in the current context."

I think ConfigurationManager class can be accessed in PaidTimeOffUI not DAL layer, right?

What can I do to slove this problem?

Here is DBHelper class:

Code:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Configuration;

namespace V2.PaidTimeOffDAL.Framework
{
    public class DBHelper
    {
        private const string HRPAIDTIMEOFF_CONNSTRING_KEY = "HRPaidTimeOffConnString";

        public static string GetHRPaidTimeOffConnectionString()
        {
            return ConfigurationManager.ConnectionString[HRPAIDTIMEOFF_CONNSTRING_KEY].ConnectionString;
        }
    }
}

kalel_4444 · August 10th, 2009, 04:56 AM

You need to add a reference to System.Configuration to the V2.PaidTimeOffDAL.

Right Click the V2.PaidTimeOffDAL project, Select Add Reference, under .NET tab add System.Configuration.

the using should now be recognized.

Ronnie

DungPT · August 10th, 2009, 05:56 AM

Hi Ronnie,

Thank for kindly reply, that is the stupid error!

It works perfectly now.

Thanks again.