Loading

How to convert anonymous type to my database type

Asp.Net Hein

10y898.NET

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.

2 Replies

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

Ravi Patel10y ago
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 });
0
Vinay Singh10y ago
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/
+1