How do I select, specify, or multi-column with SqlQuery in C# WPF Entity Framework?

Question

I'm using WPF, C#, Entity Framework database-first with a SQL Server database.

I did execute this query with successfully in SQL Server:

SELECT   
    SUM(MEGHk) AS Meghksm,   
    SUM(MABL_K) AS Mablksm,   
    SUM(N_MOIN) AS N_MOINSM,   
    SUM(IMBAA) AS IMBAAsm   
FROM   
    INVO_LST   
WHERE  
    (TAG = 2) AND (NUMBER = 4)  

In C# code:

 var quer_Sumfactor5 = dbms.Database.SqlQuery<INVO_LST>("SELECT SUM(MEGHk) AS Meghksm, SUM(MABL_K) AS Mablksm, SUM(N_MOIN) AS N_MOINSM, SUM(IMBAA) AS IMBAAsm FROM INVO_LST WHERE(TAG = 2) AND (NUMBER = " + TextB_Number.Text + ")").ToList();  

I get this error:

I think Entity Framework needs all columns that won't select single or multi columns.

How can I get the result of my query as in SQL Server?

Please help

I hope my explanation is clear

Answer 1

You get a new model with the SQL query, please create a new model for the query data.
Create a new model named NewINVO_LST

 public class NewINVO_LST  
    {  
        public float Meghksm { get; set; }  
        public float floatMablksm { get; set; }  
        public float floatN_MOINSM { get; set; }  
        public float floatIMBAAsm { get; set; }  
    }  

Then update your SQL Query：

var quer_Sumfactor5 = dbms.Database.SqlQuery<NewINVO_LST>("SELECT SUM(MEGHk) AS Meghksm, SUM(MABL_K) AS Mablksm, SUM(N_MOIN) AS N_MOINSM, SUM(IMBAA) AS IMBAAsm FROM INVO_LST WHERE(TAG = 2) AND (NUMBER = " + TextB_Number.Text + ")").ToList();  
  

It it doesn't work for you, please post here and I will try my best to help you.

---

If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Try another SQL query:

SELECT 
     NUMBER,
     SUM(MEGHk) AS Meghksm, 
     SUM(MABL_K) AS Mablksm, 
     SUM(N_MOIN) AS N_MOINSM, 
     SUM(IMBAA) AS IMBAAsm 
FROM INVO_LST 
WHERE (TAG = 2) AND (NUMBER = 4)
GROUP BY NUMBER