Griffin.MvcContrib.SqlServer.Localization.SqlLocalizedTypesRepository.GetAvailableLanguages C# (CSharp) Method

        public IEnumerable<CultureInfo> GetAvailableLanguages()
        {
            var sql = "SELECT distinct LocaleId FROM LocalizedTypes";
            using (var cmd = _db.Connection.CreateCommand())
            {
                cmd.CommandText = sql;
                using (var reader = cmd.ExecuteReader())
                {
                    var items = new List<CultureInfo>();
                    while (reader.Read())
                    {
                        items.Add(new CultureInfo((int)reader[0]));
                    }
                    return items;
                }
            }
        }