select array from linq list

Question

I have problem in selecting array from linQ list.

Array in general for some static data-

  List<string> nameList = new List<string>
            {
                "Jonathan", "Lisa", "Jordan", "Tyler", "Susan", "Brandon", "Clayton", "Elizabeth", "Jennifer"
            };

            var results = nameList.Where(n =>
                n.StartsWith(term, StringComparison.OrdinalIgnoreCase));

            return new JsonResult()
            {
                Data = results.ToArray(),
                JsonRequestBehavior = JsonRequestBehavior.AllowGet
            };

Linq query-

var names = (from u in db.Contacts
                         select u).ToList();

Now from this above linq query there will be names from this column. I want to select names from this above query by making array of its name. How do I setup an array for names in this query, as it is doing for static based data.

Edit-

  [HttpGet]
        public JsonResult GetNames(string term)
        {
            var names = (from u in db.Contacts
                         where u.name.Contains(term)
                         select u).ToArray();
            // A list of names to mimic results from a database

            var results = names.Where(n =>
                n.name.StartsWith(term, StringComparison.OrdinalIgnoreCase));

            return new JsonResult()
            {
                Data = results.ToArray(),
                JsonRequestBehavior = JsonRequestBehavior.AllowGet
            };
        }

I have modified this method from above , Now I can get list on the server's side. But at json result at it leaves me with internal server error (500).

Script-

<script type="text/javascript">
    $(function () {
        $('#typeahead').typeahead({
            source: function (term, process) {
                var url = '@Url.Content("~/Invoice/GetNames")';

                return $.getJSON(url, { term: term }, function (data) {
                    alert(data);
                    return process(data);
                });
            }
        });
    })
</script>

@Grundy, A circular reference was detected while serializing an object of type — user3163213
– user3163213, Commented Apr 8, 2014 at 8:08
possibly if you need only contact names better use select u.name instead of select u, also in this case should not be circular references — Grundy
– Grundy, Commented Apr 8, 2014 at 8:24
@Grundy, That was probably I was missing. Glad it worked now. — user3163213
– user3163213, Commented Apr 8, 2014 at 8:37

cat916 · Accepted Answer · 2014-04-08 06:44:31Z

2

It's simply :

var names = (from u in db.Contacts
            select new { Name = u.Name}).ToArray();

answered Apr 8, 2014 at 6:44

cat916

1,37110 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

user3094403 · Accepted Answer · 2014-04-08 07:14:40Z

0

Try

var names = db.Contacts.Select(x => x.PROP_NAME).ToArray();

edited Apr 8, 2014 at 7:14

user3094403

6,39011 gold badges50 silver badges56 bronze badges

answered Apr 8, 2014 at 6:48

Ni3

4893 silver badges12 bronze badges

1 Comment

Ni3 Over a year ago

try it :return Json(names,JsonRequestBehavior.AllowGet);

Collectives™ on Stack Overflow

select array from linq list

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related