How to use views in db first entity framework

Question

i have a question what i couldnt resolve it for 2 days. I'm working on .NET Core 2.2 by the way and thats why i'm using Entity Framework Core.

I have a views in my database and i dont know how to get view from code side. Because my views consisting of these;

CREATE VIEW table_column as
SELECT db.database_id,db.name,col.TABLE_NAME,col.COLUMN_NAME from sys.databases as db
INNER JOIN INFORMATION_SCHEMA.COLUMNS as col ON db.name = col.TABLE_CATALOG

Someone adviced me these;

var rawSQL = dbContext.Database.SqlQuery<SomeModel>("Raw SQL Query").ToList();

and this

var rawSQL = dbContext.SomeModels.FromSql("your SQL");

but they didnt work. As the last one i tried this;

how to use views in code first entity framework

but again didnt work because this is for the code first project.

AS A RESULT WHAT CAN I DO. I am about to go crazy.

I would remove the EF 6 tag if this refers to EF core. If it is EF core, views are discussed here — Steve Greene
– Steve Greene, Commented Jun 14, 2019 at 14:20
As linked in Steves Comment, please look here: msdn.microsoft.com/magazine/mt847184 — Roman R.
– Roman R., Commented Aug 20, 2019 at 11:00

H. Herzl · Accepted Answer · 2019-06-14 19:28:46Z

1

The answer provided by Steve Greene is right.

Also In order to use views in EF Core you need to complete these points:

Create entity to represent view result
Create DbContext class
Set mapping between entity and view (Data annotations of Fluent API)

Assuming you have setup those points, You'll perform a query like this:

var list = await dbContext.TableColumns.ToListAsync();

Let me know if this reply is useful.

answered Jun 14, 2019 at 19:28

H. Herzl

3,2881 gold badge18 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Furkan Güllü Over a year ago

Thank you so much your advice gave me some idea and it worked.

Collectives™ on Stack Overflow

How to use views in db first entity framework

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related