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

Question

question

MojtabaHakim-8125 asked · Feb 15 at 06:44 AM

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

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

dotnet-csharp windows-wpf dotnet-wpf-xaml dotnet-entity-framework

qeeph.png (6.4 KiB)

zm9h9.png (20.1 KiB)

· 1

10 |1000 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

MojtabaHakim-8125 · Feb 15 at 06:45 AM

Here is my structure :

0 ·

untitled.png (4.3 KiB)

Answer 1 · 2021-02-15T08:42:14.53Z

Viorel-1 answered · Feb 15 at 08:42 AM

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

· 1 ·

10 |1000 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

MojtabaHakim-8125 · Feb 15 at 09:18 AM

Plesae help me about this : How do I get the result of SQL Query in C# Entity Framework?

0 ·

Answer 2 · 2021-02-16T06:59:12.517Z

DaisyTian-MSFT answered · Feb 16 at 06:59 AM

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.

·

10 |1000 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

question