How to pass two different elements into same object based in a single query

See more:

C#

entity-framework

Hi I am working on a console application where I have to query a table but can't run 2 query to get result set based on where clause. Its a internal restriction. Lets say I have a table which has a column header caller status and the default entries in it are paid or debt.

What I have tried:

I am working on a entity framework project where i am using dapper to map the sql output to map it into a c# object.

this is my code for mapping the sql query to a default object

userStatus = (await connection.QueryAsync<userstatusobject>)).Tolist().

if (userStatus?.Any()?? false)
    foreach (var res in userStatus)
        yield return res

in the userstatus we have some thing like this

public class userStatusObject 
{
    public string name {get; set;}
    public int id {get; set;}
    public string status {get; set;}
}

here the status may be paid or debt

now I need to pass the res based on status into two different object


the code is like this

(for result in userstatus)
{
     var paiduserstatus  = new paiduserinfo()// paid userinfor is a seperate object 
        {
           name = result.name,
           id = result.id,
           status = result.status,
           data = xxxxxxxx
        }

    var debtuserstatus  = new debtuserinfo()// debt userinfor is a seperate object 
        {
           name = result.name,
           id = result.id,
           status = result.status,
           data = xxxxxxxx
        }       
}

So what I am trying to do is run the query and and if the status is paid I need it to pass status as paid in paid user and no should not call debtuserstatus and same as vice-versa