DataAccessLayer.DataBase.GetAllAccounts C# (CSharp) Method

        public IEnumerable<Account> GetAllAccounts()
        {
            string queryString =
               "SELECT [dbo].accounts.accountid, login, mail, [dbo].accounts.name, [dbo].UsersRoles.RoleId " +
               "FROM [dbo].accounts, [dbo].UsersRoles " +
               "WHERE [dbo].UsersRoles.AccountId = [dbo].accounts.accountid;";

            using (SqlConnection connection = new SqlConnection(_connectionString))
            {
                var command = new SqlCommand(queryString, connection);
                var list = new List<Account>();
                connection.Open();

                var reader = command.ExecuteReader();

                while (reader.Read())
                {
                   list.Add(new Account()
                    {
                        Id = (Guid)reader[0],
                        Login = (string)reader[1],
                        Email = (string)reader[2],
                        Name = (string)reader[3]
                   });
                }
                return list;
            }
        }