MvcWrench.Models.UserRepository.GetUserFromOpenId C# (CSharp) Method

        public static User GetUserFromOpenId(string openid)
        {
            NpgsqlConnection conn = new NpgsqlConnection (conn_string);
            conn.Open ();

            NpgsqlCommand comm = conn.CreateCommand ();

            string sql = "SELECT * FROM openids WHERE id = @id";
            comm.CommandText = sql;

            comm.Parameters.Add ("@id", openid);

            NpgsqlDataReader reader = comm.ExecuteReader ();

            int user_id = -1;

            while (reader.Read ())
                user_id = (int)reader["UserID"];

            reader.Close ();
            comm.Dispose ();
            conn.Close ();

            if (user_id == -1)
                return null;

            return GetUser (user_id);
        }