ActivEarth.DAO.BadgeDAO.GetBadgeFromBadgeId C# (CSharp) Метод

        public static Badge GetBadgeFromBadgeId(int badgeId)
        {
            using (SqlConnection connection = ConnectionManager.GetConnection())
            {
                var data = new ActivEarthDataProvidersDataContext(connection);
                Badge badge = (from c in data.BadgeDataProviders
                        where c.id == badgeId
                        select
                            new Badge
                            {
                                ID = c.id,
                                UserID = c.user_id,
                                StatisticBinding = (Statistic)c.statistic,
                                Level = c.badge_level,
                                Progress = c.progress
                            }).FirstOrDefault();

                LoadExternalBadgeData(badge);

                return badge;
            }
        }