Declare variable globally

Ramco Ramco

I want to declare var Result once only. How it can be declared

var Result = (from t2 in context.View_GroupParticipants
                                  select new { t2.StudentID, Name = t2.Name + " - " + t2.MobileNo }).OrderBy(x => x.Name).Distinct().ToList();

Thanks

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Naimish Makwana3y ago

Accepted answer

Hello Ramco,

you can define a named type for the objects returned by the LINQ query:

public class GroupParticipant
{
    public int StudentID { get; set; }
    public string Name { get; set; }
}

// Declare the variable
List Result;

// Execute the LINQ query and assign the result to the variable
Result = (from t2 in context.View_GroupParticipants
          select new GroupParticipant { StudentID = t2.StudentID, Name = t2.Name + " - " + t2.MobileNo })
          .OrderBy(x => x.Name)
          .Distinct()
          .ToList();

Thanks

Naimish Makwana

Ramco Ramco3y ago
Hi Naimish

It gives error Cannot convert from system.collection.generic.list to system.collection.generic.list

Thanks
0
Jignesh Kumar3y ago
Hello Raco,

You can refer this link,

https://www.c-sharpcorner.com/Forums/how-to-initialize-implicit-variable
+1

Naimish Makwana3y ago

Hello Ramco,

To declare the variable Result only once, you can separate the LINQ query from the variable declaration and assign the result of the query to the Result variable.

// Declare the variable
List Result; //You can declare it with class level.

// Execute the LINQ query and assign the result to the variable
Result = (from t2 in context.View_GroupParticipants
          select new { t2.StudentID, Name = t2.Name + " - " + t2.MobileNo })
          .OrderBy(x => x.Name)
          .Distinct()
          .ToList();

Thanks

Naimish Makwana

Tuhin Paul3y ago
To declare the variable Result once only, you can use the var keyword to infer the type of the result of your LINQ query.
```
 
 var Result = (from t2 in context.View_GroupParticipants
              select new { t2.StudentID, Name = t2.Name + " - " + t2.MobileNo })
             .OrderBy(x => x.Name)
             .Distinct()
             .ToList();
```
The var keyword is used to declare Result, and its type is inferred from the result of the LINQ query. The query is then chained with the OrderBy, Distinct, and ToList methods to sort, filter, and convert the result to a list.

The type of Result will be List, which is the type of the result of the LINQ query.
0