using System;

using System.Collections.Generic;

using System.Data.SqlClient;

using System.Linq;

​

public class UserService

{

    private string _connectionString = "Server=myServer;Database=myDb;User Id=myUser;Password=myPass;";

    public List<User> GetUsers()

    {

        var users = new List<User>();

        try

        {

            using (var connection = new SqlConnection(_connectionString))

            {

                var query = "SELECT * FROM Users";

                var command = new SqlCommand(query, connection);

                connection.Open();

                var reader = command.ExecuteReader();

                while (reader.Read())

                {

                    users.Add(new User

                    {

                        Id = (int)reader["Id"],

                        Name = (string)reader["Name"],

                        Email = (string)reader["Email"]

                    });

                }

            }

        }

        catch (Exception ex)

        {

            Console.WriteLine("Error fetching users: " + ex.Message);

        }

        return users;

    }

​

    public void AddUser(User user)

    {

        try

        {

            using (var connection = new SqlConnection(_connectionString))

            {

                var query = $"INSERT INTO Users (Name, Email) VALUES ('{user.Name}', '{user.Email}')";

                var command = new SqlCommand(query, connection);

                connection.Open();

                command.ExecuteNonQuery();

            }

        }

        catch (Exception ex)

        {

            Console.WriteLine("Error adding user: " + ex.Message);

        }

    }

}

​

public class User

{

    public int Id { get; set; }

    public string Name { get; set; }

    public string Email { get; set; }

}

​