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