private Dictionary<string, int> Data
        {
            get
            {
                Dictionary<string, int> data = new Dictionary<string, int>();

                using (SqlConnection conn = new SqlConnection(connectionString))
                {
                    SqlDataReader rdr = null;

                    conn.Open();

                    string query = "";

                    SqlCommand cmd = new SqlCommand(query, conn);

                    using (rdr = cmd.ExecuteReader())
                    {
                        while (rdr.Read())
                        {
                            data.Add(((DateTime)rdr["date"]).ToString("MM-yyyy"), (int)rdr["visits"]);
                        }
                    }
                }
                return data;
            }
        }

Basic SQL access

sql, c#

C#