public ICollection<Group> GetGroups(User user)
{
var result = new Dictionary<int, Group>();
using (var conn = this.Connection)
using (var mc = new MySqlCommand("SELECT * FROM `groups` WHERE `contactId` = @contactId", conn))
{
mc.Parameters.AddWithValue("@contactId", user.Id);
using (var reader = mc.ExecuteReader())
{
while (reader.Read())
{
var group = new Group();
group.Id = reader.GetInt32("groupId");
group.Name = reader.GetStringSafe("name");
// Override duplicate ids
result[group.Id] = group;
}
}
}
return result.Values;
}