How to convert anonymous type to my database type

Question

var user = ( db.Users .Where(u => u.CountryId == c)).Select( u=> new { u.UserName u.Email u.Country.Name u.PhoneNumber u.LastLogin }); In this code the datatype of 'Select' part is 'anonymous'. I don't want anonymous datatype and I want db.Users type. Kindly let me know how to solve this and thanks a lot for viewing my question.

Vinay Singh · Answer

Hi Have a look of the link this is going to help you sure https://blogs.msdn.microsoft.com/swiss_dpe_team/2008/01/25/using-your-own-defined-type-in-a-linq-query-expression/

Ravi Patel · Answer

Hi  try this i hope ' Userstype' is model class public class Userstype { public string UserName{get; set;} public string Email {get; set;} // more property } var user = ( db.Users .Where(u => u.CountryId == c)).Select( u=> new Userstype { UserName= u.UserName Email= u.Email });