Non static method requires a target C# Entity Framework

Question

public InventorySales  getinvSales(int mgrId, int SalesId)
{
    Managerset res = null;


    InventorySales invSales = (from x in sbdb.tblSalesn.where(i => i.salesId == Sid)
                               join y in sbdb.tblProds on x.salesid equals y.salesid into resSales

     select new InventorySales()
                                      {
                                           ProductName = x.productname,
                                           Location = (xyz!= null) ? xyz.location:string.empty,
                                           Manager =  (res != null) ? res.Manager : string.empty // error line
                                      }).FirstOrDefault();

    return invSales
}

That's how my code looks,

Manager = (res != null) ? res.Manager : string.empty

is causing an error, there is no relation between the tblManager and tblSales table

Possible duplicate with: http://stackoverflow.com/questions/13717355/non-static-method-requires-a-target/ — Maarten, Jul 29 '16 at 11:31
i have used the null check, still it giving the erro (res != null) ? res.Manager : string.empty** — python, Jul 29 '16 at 11:35
Do the null check outside of the query, populate the property afterwards. — Maarten, Jul 29 '16 at 11:37

score 1 · Accepted Answer · answered Jul 29 '16 at 11:39

You can try to move the res != null decision out of the query.

public InventorySales  getinvSales(int mgrId, int SalesId) {
    var res = from ins in sbdb.tblManager
          where(managerId == mgrID)
          select new Managerset() {
            Manager = ins.Manager
          }).firstOrDefault();

    InventorySales invSales = (from x in sbdb.tblSalesn.where(i=>i.salesId == Sid)
                                join y in sbdb.tblProds on x.salesid equals y.salesid into resSales
                                from xyz in result.DefaultIfEmpty()
                                select new InventorySales()
                                {
                                    ProductName = x.productname,
                                    Location = (xyz!= null) ? xyz.location:string.empty,
                                    Manager =  string.empty
                                }).FirstOrDefault();

    if (invSales != null && res != null) {
        invSales.Manager = res.Manager;
    }

    return invSales
}

Non static method requires a target C# Entity Framework

1 Answers1