using System;

using System.Collections.Generic;

using System.Data.SqlClient;

​

namespace CodeReviewExercise

{

    public class User

    {

        public int Id { get; set; }

        public string Name { get; set; }

        public string Email { get; set; }

    }

​

    public class UserRepository

    {

        private string connectionString;

        public UserRepository(string connStr)

        {

            connectionString = connStr;

        }

​

        public List<User> GetAllUsers()

        {

            List<User> userList = new List<User>();

            SqlConnection conn = new SqlConnection(connectionString);

            SqlCommand cmd = new SqlCommand("SELECT Id, Name, Email FROM Users", conn);

            conn.Open();

            SqlDataReader reader = cmd.ExecuteReader();

            while (reader.Read())

            {

                User user = new User

                {

                    Id = reader.GetInt32(0),

                    Name = reader.GetString(1),

                    Email = reader.GetString(2)

                };

                userList.Add(user);

            }

​

            conn.Close();

            return userList;

        }

​

        public void InsertUser(User u)

        {

            SqlConnection conn = new SqlConnection(connectionString);

            SqlCommand cmd = new SqlCommand("INSERT INTO Users (Name, Email) VALUES ('" + u.Name + "', '" + u.Email + "')", conn);

            conn.Open();

            cmd.ExecuteNonQuery();

            conn.Close();

        }

    }

​

    class Program

    {

        static void Main(string[] args)

        {

            var connStr = "YourConnectionStringHere";

            UserRepository repo = new UserRepository(connStr);

            User newUser = new User

            {

                Name = "John Doe",

                Email = "john.doe@example.com"

            };

            repo.InsertUser(newUser);

            List<User> users = repo.GetAllUsers();

            foreach (User user in users)

            {

                Console.WriteLine("Id: " + user.Id + ", Name: " + user.Name + ", Email: " + user.Email);

            }

        }

    }

}