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

        public static User GetUserFromSvn(string svn)
        {
            NpgsqlConnection conn = new NpgsqlConnection (conn_string);
            conn.Open ();

            NpgsqlCommand comm = conn.CreateCommand ();

            string sql = "SELECT * FROM users WHERE svn = @svn";
            comm.CommandText = sql;

            comm.Parameters.Add ("@svn", svn);

            NpgsqlDataReader reader = comm.ExecuteReader ();

            User user = null;

            while (reader.Read ())
                user = new User (reader);

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

            return user;
        }