How can convert these query in entityframework

Gaurav Raj

public new List Profile(int id)
{

var q = from a in db.RegisterTables

where a.Id == id
select
new Profile1
{
Name = a.F_Name + ' ' + a.L_Name,
Email_Id = a.Email_Id,
gender = a.Gender,
DateJoin = a.DateJoin.ToString(),
Location = a.Counttry,
UserName = a.UserName,
DOB = a.DOB.ToString(),
About_Me = a.AboutYou,
BlogPic = a.Pic
};

return q.ToList();

}

5 Replies

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

Faisal Pathan8y ago
Yes Its correct.
0
Gaurav Raj8y ago
this is my controller
public new List Profile(int id)
{
var q = db.RegisterTables.Where(a => a.Id.Equals(id)).Select
(a => new Profile1()
{
Name = a.F_Name + ' ' + a.L_Name,
Email_Id = a.Email_Id,
gender = a.Gender,
DateJoin = a.DateJoin.ToString(),
Location = a.Counttry,
UserName = a.UserName,
DOB = a.DOB.ToString(),
About_Me = a.AboutYou,
BlogPic = a.Pic
});
return q.ToList();
}

and my view

$(document).ready(function () {
$.ajax({
type: "GET",
contentType: "application/json",
url: "Account/getProfile/",
data: "{id:" +2 +"}",
datatype: "json",
success: function (data) {
var d = data.d;
$('#pName').html(d[0].F_Name);
$('#pUserName').html(d[0].UserName);
$('#pDOB').html(d[0].DOB);
$('#pDateJoin').html(d[0].DateJoin);
$('#pGender').html(d[0].gender);
$('#pEmailid').html(d[0].Email_Id);
}
0

Faisal Pathan8y ago

Can you please send query which you written?

Gaurav Raj8y ago

helloo

Faisal Pathan

i am getting these type of error

Unable to create a constant value of type 'System.Object'. Only primitive types or enumeration types are supported in this context.

Faisal Pathan8y ago

var q = db.RegisterTables().Where(a=> a.Id == id).Select

(a => new YourModel()

{

Name = a.F_Name + ' ' + a.L_Name,

Email_Id = a.Email_Id,

gender = a.Gender,

DateJoin = a.DateJoin.ToString(),

Location = a.Counttry,

UserName = a.UserName,

DOB = a.DOB.ToString(),

About_Me = a.AboutYou,

BlogPic = a.Pic

}).ToList();