Interview-Q4 | C# Online Compiler

Interview-Q4 by Prahveen Thiruchelvam

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; }
}

​x
 
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; }
}
​

Compilation error (line 1, col 1): Program does not contain a static 'Main' method suitable for an entry point
Compilation error (line 1, col 1): Assuming assembly reference 'System.Data.Common, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' used by 'System.Data.SqlClient' matches identity 'System.Data.Common, Version=9.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' of 'System.Data.Common', you may need to supply runtime policy
Compilation error (line 15, col 41): 'SqlConnection' is obsolete: 'Use the Microsoft.Data.SqlClient package instead.'
Compilation error (line 1, col 1): Assuming assembly reference 'System.Runtime, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' used by 'System.Data.SqlClient' matches identity 'System.Runtime, Version=9.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' of 'System.Runtime', you may need to supply runtime policy
Compilation error (line 1, col 1): Assuming assembly reference 'System.Data.Common, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' used by 'System.Data.SqlClient' matches identity 'System.Data.Common, Version=9.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' of 'System.Data.Common', you may need to supply runtime policy
Compilation error (line 18, col 35): 'SqlCommand' is obsolete: 'Use the Microsoft.Data.SqlClient package instead.'
Compilation error (line 1, col 1): Assuming assembly reference 'System.Data.Common, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' used by 'System.Data.SqlClient' matches identity 'System.Data.Common, Version=9.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' of 'System.Data.Common', you may need to supply runtime policy
Compilation error (line 1, col 1): Assuming assembly reference 'System.Runtime, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' used by 'System.Data.SqlClient' matches identity 'System.Runtime, Version=9.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' of 'System.Runtime', you may need to supply runtime policy
Compilation error (line 1, col 1): Assuming assembly reference 'System.Data.Common, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' used by 'System.Data.SqlClient' matches identity 'System.Data.Common, Version=9.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' of 'System.Data.Common', you may need to supply runtime policy
Compilation error (line 1, col 1): Assuming assembly reference 'System.Runtime, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' used by 'System.Data.SqlClient' matches identity 'System.Runtime, Version=9.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' of 'System.Runtime', you may need to supply runtime policy
Compilation error (line 1, col 1): Assuming assembly reference 'System.Runtime, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' used by 'System.Data.SqlClient' matches identity 'System.Runtime, Version=9.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' of 'System.Runtime', you may need to supply runtime policy
Compilation error (line 1, col 1): Assuming assembly reference 'System.Runtime, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' used by 'System.Data.SqlClient' matches identity 'System.Runtime, Version=9.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' of 'System.Runtime', you may need to supply runtime policy
Compilation error (line 1, col 1): Assuming assembly reference 'System.Runtime, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' used by 'System.Data.SqlClient' matches identity 'System.Runtime, Version=9.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' of 'System.Runtime', you may need to supply runtime policy
Compilation error (line 1, col 1): Assuming assembly reference 'System.Data.Common, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' used by 'System.Data.SqlClient' matches identity 'System.Data.Common, Version=9.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' of 'System.Data.Common', you may need to supply runtime policy
Compilation error (line 43, col 41): 'SqlConnection' is obsolete: 'Use the Microsoft.Data.SqlClient package instead.'
Compilation error (line 1, col 1): Assuming assembly reference 'System.Runtime, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' used by 'System.Data.SqlClient' matches identity 'System.Runtime, Version=9.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' of 'System.Runtime', you may need to supply runtime policy
Compilation error (line 1, col 1): Assuming assembly reference 'System.Data.Common, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' used by 'System.Data.SqlClient' matches identity 'System.Data.Common, Version=9.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' of 'System.Data.Common', you may need to supply runtime policy
Compilation error (line 46, col 35): 'SqlCommand' is obsolete: 'Use the Microsoft.Data.SqlClient package instead.'
Compilation error (line 1, col 1): Assuming assembly reference 'System.Data.Common, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' used by 'System.Data.SqlClient' matches identity 'System.Data.Common, Version=9.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' of 'System.Data.Common', you may need to supply runtime policy
Compilation error (line 1, col 1): Assuming assembly reference 'System.Runtime, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' used by 'System.Data.SqlClient' matches identity 'System.Runtime, Version=9.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' of 'System.Runtime', you may need to supply runtime policy
Compilation error (line 1, col 1): Assuming assembly reference 'System.Runtime, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' used by 'System.Data.SqlClient' matches identity 'System.Runtime, Version=9.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' of 'System.Runtime', you may need to supply runtime policy

Last Run:	7:28:00 pm
Compile:	0.014s
Execute:	0s
Memory:	0b
CPU:	0s

View IL Code