Forum Discussion

Jyothi13's avatar
Jyothi13
New Contributor
3 years ago

how do I get the value instead of count from the following code in C#.net

var or = await _context
.OrganisationID
.FromSqlRaw("SELECT pj.proj_org_id as orgId FROM[mapping].[DataResourceTenancy] as dt JOIN web.Project as pj on dt.drp_projCode = proj_code where drp_amrd_serialNumber like {0} ", deviceName)
.ToListAsync();

 

When I execute, it is giving me the count not the value. Please help me

No RepliesBe the first to reply