MyMethod

List<Dictionary<Object, Object>> responseList = new List<Dictionary<object, object>>();
            Database db = new Database();
            Street myStreet = new Street();
            using (db.sqlConnection)
            {
                db.sqlConnection.Open();
                using (var cmd = new SqlCommand("areaGetStreetTypes", db.sqlConnection))
                {
                    cmd.CommandType = System.Data.CommandType.StoredProcedure;
                    cmd.Parameters.Add(new SqlParameter("@city_id", city_id));
                    cmd.Parameters.Add(new SqlParameter("@language_id", language_id));
                    using (SqlDataReader dr = cmd.ExecuteReader(CommandBehavior.KeyInfo))
                    {
                        while (dr.Read())
                        {
                            Dictionary<Object, Object> newDictionary = new Dictionary<object, object>();
                            for (int lp = 0; lp < dr.FieldCount; lp++)
                            {
                                newDictionary.Add(dr.GetName(lp), dr.GetValue(lp));
                            }
                            responseList.Add(newDictionary);
                        }
                    }
                }
            }
            return responseList;
        } //returnes a list of street types