Executing Raw sql with Entity Framework Core

Question

The below I can have a condition to execute view/table, which would load into AccountDataModel class.

 dbcontext.AccountDataModel.FromSql($"select * from account where id=123").FirstOrDefault(); 

How can I retrieve without using a class model, if I want to retrieve just 1 or 2 columns

example: select name from account where id=123

Do I always need a class model?

Answer 1

ADO.NET works in EFCore =)

using Microsoft.EntityFrameworkCore; using System.Data.Common; using System.Data.SqlClient; using System; public void ExampleMethod(DbContext context) { SomeObjectResult result = null; DbCommand cmd = context.Database.GetDbConnection().CreateCommand(); cmd.CommandText = "Select C.ID, C.CarModelID as ModelID, C.VIN, C.RegNumber,cast(C.CountValue as int) as Course,A.BrandID from A inner join C on A.ID = C.KeyID Where A.ID = @appID"; cmd.Parameters.Add(new SqlParameter("@appID", appointmentID)); if (cmd.Connection.State != ConnectionState.Open) { cmd.Connection.Open(); } using (var reader = await cmd.ExecuteReaderAsync()) { if (reader.Read()) { result = new SomeObjectResult() { BrandID = (int)reader["BrandID"], Course = (int)reader["Course"], ID = (int)reader["ID"], ModelID = (int?)reader["ModelID"], RegNumber = (string)reader["RegNumber"], VIN = (string)reader["VIN"] }; } } } 

Answer 2

Yes. like this :

var account = dbcontext.AccountDataModel.FromSql(@"select a.id, a.name from account a where a.id=123"); 

source : FromSql for non entity type

Answer 3

This queries the database

 var name = dbcontext.GetDBConnection().Query("select name from account where id=123").FirstOrDefault();