Aura.Msgr.Database.MsgrDb.GetGroups C# (CSharp) Метод

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