public User Get(int id)
{
var query = $"SELECT * FROM [dbo].[dotnet_users] WHERE id = {id}";
var reader = Context.ExecuteReader(query);
User user = null;
while (reader.Read())
{
user = new User
{
Id = int.Parse(reader["id"].ToString()),
Name = reader["dotnet_name"].ToString(),
Email = reader["email"].ToString(),
Age = int.Parse(reader["age"].ToString()),
};
break;
}
return(user);
}
