query on db print to console

Question

i want to write a query on my db that finds all the user name that are longer then 4 char and print them , my code goes:

also do i need to change it to some kind of return type for list/array?

public string[] FindNameByLength(int minimumCharNumber)
    {

        var query = from u in db.Users
                    where u.FullName.Length > minimumCharNumber
                    select u.FullName;


        string[] namesLength;
        int counter;

        foreach (var s in query)
        {
         namesLength.Concat(new[] {s });
        }
        return namesLength;

    }

how could i add each name into an array?

Iswanto San · Accepted Answer · 2013-02-13 13:38:59Z

2

Use Length property to check string length. Try this :

 public void FindName()
   {
       var query = from u in db.Users
                   where u.FullName.Length > 4
                   select u.FullName;

       foreach(var s in query) 
           Console.WriteLine(s);
   }

answered Feb 13, 2013 at 13:38

Iswanto San

18.6k13 gold badges60 silver badges79 bronze badges

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

Comments

gzaxx · Accepted Answer · 2013-02-13 13:39:43Z

1

You can do this in just one line of code (with LINQ):

public void FindName()
{
    db.Users.Where(x => x.FullName.Length > 4).ToList().ForEach(x => Console.WriteLine(x.FullName));
}

answered Feb 13, 2013 at 13:39

gzaxx

17.6k2 gold badges40 silver badges55 bronze badges

Comments

Indi · Accepted Answer · 2013-02-13 13:42:09Z

1

Write to console and return them as a List. Also you could pass the character length as a parameter to the function.

public List<string> FindName(int ChrLength)
{
       var query = db.Users.Where(u => u.FullName.Length > ChrLength)
                           .Select(u => u.FullName).ToList();

       foreach(var s in query) 
           Console.WriteLine(s);
       return query;
}

answered Feb 13, 2013 at 13:42

Indi

33.9k7 gold badges61 silver badges80 bronze badges

Collectives™ on Stack Overflow

query on db print to console

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related