How to initialize implicit variable

Question

Hi How to initialize Result variable Result = (from t2 in context.View_SessionDeliveryCalendarDetails_Students where t2.MentorID == mentorId select new { t2.StudentID, Name = t2.Name + " - " + t2.MobileNo }).Distinct().ToList(); Thanks

Jignesh Kumar · Answer

Hello Ramco, you can create one class with same property you want use in select statement, for above you can create, Public class StudentDetails { public int StudentID {get;set;} public string Name {get;set;} public strin MobileNumber{get;set;} } You can initialize as below var Result = new List (); Result = (from t2 in context.View_SessionDeliveryCalendarDetails_Students where t2.MentorID == mentorId select new StudentDetails{ studentId = t2.StudentID, Name = t2.Name, MobileNumber = t2.MobileNo}).Distinct().ToList(); Then in UI/ Cshtml filr you can do string concate using Name + MobileNumber

Rajkiran Swain · Answer

the type of Result in this case is an anonymous type, as it is created using the new { } syntax in the select statement. The properties of this anonymous type are StudentID and Name .

Ramco Ramco · Answer

Hi Rajkiran What should be type of Result . How it should be initialized. var Result = (from t2 in context.View_SessionDeliveryCalendarDetails_Students where t2.MentorID == mentorId select new { t2.StudentID, Name = t2.Name + " - " + t2.MobileNo }).Distinct().ToList(); Thanks

Rajkiran Swain · Answer

The error "cannot convert from 'System.Collections.Generic.List ' to 'System.Collections.Generic.List '" is caused by a mismatch between the type of the result of your query and the type of the variable you are trying to assign it to.

Rajkiran Swain · Answer

you need to create a new instance of the "StudentsBreak" class for each item in your LINQ query result and add it to a new list of type " List " . You can use a foreach loop to iterate over the items in the query result and create new instances of the "StudentsBreak" class for each item, like this: List Result = new List (); foreach (var item in queryResult) { StudentsBreak student = new StudentsBreak(); student.StudentID = item.StudentID; student.Name = item.Name; Result.Add(student); } In this code, you would replace "queryResult" with your LINQ query result, and "StudentsBreak" with the name of your class that has the "StudentID" and "Name" properties. This will create a new list of "StudentsBreak" objects with the data from your query result.

Ramco Ramco · Answer

Hi Rajkiran I am getting error cannot convert from system.collection.generic to system.collection.dynamic. Result = (from t2 in context.View_SessionDeliveryCalendarDetails_Students where t2.MentorID == mentorId select new { t2.StudentID, Name = t2.Name + " - " + t2.MobileNo }).Distinct().ToList(); Thanks

Rajkiran Swain · Answer

List Result = new List (); Result = (from t2 in context.View_SessionDeliveryCalendarDetails_Students where t2.MentorID == mentorId select new { t2.StudentID, Name = t2.Name + " - " + t2.MobileNo }).Distinct().ToList();