SQL Server Query DB to non entity type classes using EF Core

tquggr8v 于 2023-06-21 发布在其他

关注(0)|答案(1)|浏览(145)

I have an ASP.NET Core 7 app with EF Core 7. I need to query some tables from a database which is not in my control, and I don't even have the dbcontext , but I have the connection string to the database.

I need to query some table from that database using EF Core 7 to some DTO which are not entity types. I have tried with Dapper and it works, but how to achieve the same thing with EF Core?

sql-server

来源：https://stackoverflow.com/questions/76403452/query-db-to-non-entity-type-classes-using-ef-core

1条答案

按热度按时间

qyswt5oh1#

You can use my SqlQuery nuget library; https://www.nuget.org/packages/ErikEJ.EntityFrameworkCore.SqlServer.SqlQuery/7.0.0-preview1

var context = new ChinookContext();

var result = await context.SqlQueryAsync<MyDto>("SELECT * FROM MyTable");

赞(0）回复(0）举报 2023-06-21

我来回答

SQL Server Query DB to non entity type classes using EF Core

1条答案

相关问题

热门标签

最新问答