ChatterService.ProfilesServices.GetInactiveProfiles C# (CSharp) Method

        public List<int> GetInactiveProfiles()
        {
            System.Text.StringBuilder sql = new System.Text.StringBuilder();

            string connstr = ConfigurationManager.ConnectionStrings["ChatterService.Properties.Settings.profilesConnectionString"].ConnectionString;

            sql.AppendLine("select personid from [Profile.Data].[Person] where IsActive = 0");

            SqlConnection dbconnection = new SqlConnection(connstr);
            SqlCommand dbcommand = new SqlCommand();

            dbconnection.Open();
            dbcommand.CommandType = CommandType.Text;

            dbcommand.CommandText = sql.ToString();
            dbcommand.CommandTimeout = 5000;

            dbcommand.Connection = dbconnection;

            List<int> retval = new List<int>();
            using (SqlDataReader dbreader = dbcommand.ExecuteReader(CommandBehavior.CloseConnection))
            {
                while (dbreader.Read())
                {
                    retval.Add(dbreader.GetInt32(0));
                }
            }

            return retval;
        }